ORADEBUG SQL Plus Command - Secrets of the Oracle Database - page 486

Table 37-3. ERRORSTACK Trace File Contents

Trace File Sections Level 1 Level 2 Level 3

Current SQL statement yes yes yes

Call stack trace yes yes yes

Process state (includes session wait history) no yes yes

Enabled events at session and instance level no no yes

Cursor dump no no yes

Following is an example of an ERRORSTACK dump:

SQL> ORADEBUG SETOSPID 6524
Oracle pid: 16, Unix process pid: 6524, image: [e-mail]
SQL> ORADEBUG DUMP ERRORSTACK 1
Statement processed.
SQL> ORADEBUG TRACEFILE_NAME
/opt/oracle/obase/admin/TEN/udump/ten1_ora_6524.trc
SQL> !less /opt/oracle/obase/admin/TEN/udump/ten1_ora_6524.trc
Received ORADEBUG command 'DUMP ERRORSTACK 1' from process Unix process pid: 6518,
image:
*** 2007-09-09 12:36:02.525
ksedmp: internal or fatal error
Current SQL statement for this session:
SELECT sys_context('userenv', 'sessionid'),sys_context('userenv', 'client_identifier
'),sys_context('userenv', 'client_info'),sys_context('userenv', 'host'), /* correspo
nds to v$session.machine */sys_context('userenv', 'os_user'), /* corresponds to v$se
ssion.osuser */ sys_context('userenv', 'terminal')FROM dual
----- Call Stack Trace -----
calling call entry argument values in hex
location type point (? means dubious value)
-------------------- -------- -------------------- ----------------------------
ksedst()+27 call ksedst1() 1 ? 1 ?
ksedmp()+557 call ksedst() 1 ? 2A120F04 ? 76010B ?
2A11FC8E ? 0 ? BFFFB638 ?
ksdxfdmp()+1382 call 0C94496E 1 ? 83CD95B ? C816D60 ?
BFFFB7DC ? 83E55FD ?
2EAF9940 ?
ksdxcb()+1321 call 00000000 BFFFBAE8 ? 11 ? 3 ?
BFFFBA48 ? BFFFBA98 ?
sspuser()+102 call 00000000 1 ? 2000 ? 0 ? 0 ? 0 ? 0 ?
0071A7A0 signal 00000000 C ? BFFFBF70 ? BFFFBFF0 ?
nttrd ()+155 call snttread() D ? C86BEC6 ? 810 ? 0 ?
…