oradebug

miloluo

Reference from : http://www.orafaq.com/wiki/Oradebug

Oradebug is a command that can be executed from SQL*Plus (or Svrmgrl in Oracle 8i and lower releases) to display or dump diagnostics information.

Execute the "ORADEBUG HELP" command to obtain a list of valid ORADEBUG commands.

It looks like one can change memory locations with the ORADEBUG POKE command. Anyone brave enough to test this one for us?

Examples

Look at these oradebug examples:

Trace SQL statements with bind variables:

SQL> oradebug setospid 10121 Oracle pid: 91, Unix process pid: 10121, image: oracleorcl SQL> oradebug EVENT 10046 trace name context forever, level 12 Statement processed. SQL> ! vi /app/oracle/admin/orcl/bdump/ora_10121.trc

Trace Process Statistics:

SQL> oradebug setorapid 2 Unix process pid: 1436, image: ora_pmon_orcl SQL> oradebug procstat Statement processed. SQL> oradebug TRACEFILE_NAME /app/oracle/admin/orcl/bdump/pmon_1436.trc

List semaphores and shared memory segments in use:

SQL> oradebug ipc

Dump Error Stack:

SQL> oradebug setospid <pid> SQL> oradebug event immediate trace name errorstack level 3

Dump RAC DLM locks:

SQL> oradebug lkdebug -a convlock SQL> oradebug lkdebug -a convres SQL> oradebug lkdebug -r <resource handle> (i.e 0x8066d338 from convres dump)
try in my env:
SQL> select addr, pid, spid, program from  v$process;

ADDR            PID SPID         PROGRAM
-------- ---------- ------------ ------------------------------------------------
38D1ED68          1              PSEUDO
38D1F31C          2 3041         oracle@milo.com (PMON)
38D1F8D0          3 3043         oracle@milo.com (PSP0)
38D1FE84          4 3045         oracle@milo.com (MMAN)
38D20438          5 3047         oracle@milo.com (DBW0)
38D209EC          6 3049         oracle@milo.com (LGWR)
38D20FA0          7 3051         oracle@milo.com (CKPT)
38D21554          8 3053         oracle@milo.com (SMON)
38D21B08          9 3055         oracle@milo.com (RECO)
38D220BC         10 3057         oracle@milo.com (MMON)
38D22670         11 3059         oracle@milo.com (MMNL)
38D22C24         12 3061         oracle@milo.com (TNS V1-V3)
38D231D8         13 3063         oracle@milo.com (ARC0)
38D2378C         14 3065         oracle@milo.com (ARC1)
38D23D40         15 3203         oracle@milo.com (q001)
38D242F4         16 3069         oracle@milo.com (QMNC)
38D248A8         17 3211         oracle@milo.com (q002)
38D25410         19 3081         oracle@milo.com (q000)

18 rows selected.

SQL> oradebug setospid 3069
Oracle pid: 16, Unix process pid: 3069, image: oracle@milo.com (QMNC)
SQL> oradebug procstat
Statement processed.
SQL> oradebug TRACEFILE_NAME
/u01/app/oracle/admin/liuzhou/bdump/liuzhou_qmnc_3069.trc
SQL>
SQL>
SQL> oradebug setorapid 2
Unix process pid: 3041, image: oracle@milo.com (PMON)
SQL> oradebug procstat
Statement processed.
SQL> oradebug TRACEFILE_NAME
/u01/app/oracle/admin/liuzhou/bdump/liuzhou_pmon_3041.trc