Using ORADEBUG

jarodwang, 08 May 2008, No comments
Categories: Oracle
Tags: ,

获得帮助信息

SQL> oradebug help

或者

SQL> oradebug help [command]

比如:

SQL> oradebug help setmypid
SETMYPID                                 Debug current process

SQL语句跟踪(SQL statement tracing)

SQL> oradebug setmypid
Statement processed.
SQL> oradebug event 10046 trace name context forever, level 4
Statement processed.
SQL> select * from v$option where parameter = ‘Real Application Clusters’;

PARAMETER                                VALUE
—————————————- —–
Real Application Clusters                TRUE

SQL> oradebug tracefile_name
/ee/oracle/rac/admin/orcldb/udump/orcldb1_ora_2011322.trc
SQL> oradebug close_trace
Statement processed.

错误堆栈转储(Error stack dumping)

SQL> oradebug setmypid
Statement processed.
SQL> oradebug event 942 trace name errorstack level 3
Statement processed.
SQL> select * from abc;
select * from abc
*
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> oradebug tracefile_name
/ee/oracle/rac/admin/orcldb/udump/orcldb1_ora_1253470.trc
SQL> oradebug close_trace
Statement processed.

Comments

Leave a Reply:

Name *

Mail (hidden) *

Website