Search This Blog

Total Pageviews

Saturday, 24 December 2016

Oracle oradebug



SQL> !ps -e -o pcpu,user,pid,args | sort -k 1 | grep oracle
0.0 oracle 15876 -bash
0.0 oracle 15902 sqlplus
0.0 oracle 15978 oracleorcl (DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))
0.0 oracle 15982 ora_w000_orcl
0.0 oracle 16387 /bin/bash -c ps -e -o pcpu,user,pid,args | sort -k 1 | grep oracle
0.0 oracle 16389 sort -k 1
0.0 oracle 16390 grep oracle
0.0 oracle 29333 /opt/app/oracle/product/11.2/bin/tnslsnr LISTENER -inherit -----
0.0 oracle 5867 -bash
0.0 oracle 6002 ora_pmon_orcl
0.0 oracle 6004 ora_vktm_orcl
0.0 oracle 6008 ora_gen0_orcl
0.0 oracle 6010 ora_diag_orcl
0.0 oracle 6012 ora_dbrm_orcl
0.0 oracle 6014 ora_psp0_orcl
0.0 oracle 6016 ora_dia0_orcl
0.0 oracle 6018 ora_mman_orcl
0.0 oracle 6020 ora_dbw0_orcl
0.0 oracle 6022 ora_lgwr_orcl
0.0 oracle 6024 ora_ckpt_orcl
0.0 oracle 6026 ora_smon_orcl
0.0 oracle 6028 ora_reco_orcl
0.0 oracle 6030 ora_mmon_orcl
0.0 oracle 6032 ora_mmnl_orcl
0.0 oracle 6034 ora_d000_orcl
0.0 oracle 6036 ora_s000_orcl
0.0 oracle 6101 ora_arc0_orcl
0.0 oracle 6103 ora_arc1_orcl
0.0 oracle 6105 ora_arc2_orcl
0.0 oracle 6107 ora_arc3_orcl
0.0 oracle 6117 ora_qmnc_orcl
0.0 oracle 6137 ora_q000_orcl
0.0 oracle 6139 ora_q001_orcl
0.0 oracle 6143 ora_cjq0_orcl
0.0 oracle 6685 ora_smco_orcl
0.0 root 15872 su - oracle
0.0 root 5859 su - oracle
100 oracle 16388 ps -e -o pcpu,user,pid,args

SQL> oradebug setospid 29333 ---- for LISTENER
ORA-00075: process "Unix process pid: 29333, image: " not found in this instance

SQL> oradebug setospid 6101
Oracle pid: 20, Unix process pid: 6101, image: oracle@apt-amd-02 (ARC0)

SQL> oradebug event 10046 trace name context off;
Statement processed.

SQL> oradebug TRACEFILE_NAME
/opt/app/oracle/diag/rdbms/orcl/orcl/trace/orcl_arc0_6101.trc

SQL> oradebug suspend
Statement processed.

SQL> oradebug resume
Statement processed.

SQL> oradebug event 10046 trace name context off;
Statement processed.

Oracle DBA

anuj blog Archive