Error Stack

Error Stack

An error stack describes the current state of a process. It includes the current SQL statement and the process state for the process.Oracle recommends taking an error stack dump to diagnose

what the process is doinga problem identified by a systemstate dumpprocesses looping or hangingError stack dumps can also be triggered by an error

To dump an error stack use

ALTER SESSION SET EVENTS‘immediate trace name errorstack level level’;

where level is one of the following

Level Description0 Error stack only1 Error stack and function call stack2 As level 1 plus the process state3 As level 2 plus the context area

The following ORADEBUG command has the same effect

ORADEBUG DUMP ERRORSTACK level

An alternative syntax for the same command is

ORADEBUG EVENT IMMEDIATE TRACE NAME ERRORSTACK level

To dump a level 3 errorstack when ORA-00942 (table or view does not exist) use

ALTER SESSION SET EVENTS‘942 trace name errorstack level 3′;

A conditional errorstack dump can also be specified without a level e.g.

ALTER SESSION SET EVENTS‘604 trace name errorstack’;

Alternatively a conditional errorstack dump can be specified in the init.ora file

event = “942 trace name errorstack level 3″

Errorstacks can also be dumped conditionally using ORADEBUG

ORADEBUG EVENT 942 TRACE NAME ERRORSTACK LEVEL 3

A level 3 errorstack contains the following sections

Call Stack TraceFiles Currently OpenedProcess StatePinned Buffer HistoryCursor DumpFixed PGAFixed SGAFixed UGAIn memory trace dump

===============================================================

Inthirties关注Oracle数据库 维护，优化，安全，备份，恢复，迁移，故障处理

版权声明：本文内容由网络用户投稿，版权归原作者所有，本站不拥有其著作权，亦不承担相应法律责任。如果您发现本站中有涉嫌抄袭或描述失实的内容，请联系我们jiasou666@gmail.com 处理，核实后本网站将在24小时内删除侵权内容。