What are the available commands for 1> Oradebug?
Log into the database as SYSDBA, through Oradebug help can see oradebug commonly used commands
Sqlplus/as SYSDBA
Oradebug Help
2> Tracking Current session information
Oradebug Setmypid--Track current session
Oradebug Setospid--Tracking system progress
Oradebug Setorapid--track Oracle Processes
Oradebug unlimit--Remove trace file size limit
Oradebug Close_trace--Close trace
Oradebug Tracefile_name--View trace filename and location
3> use Oradebug to do session level 10046 or 10053
Oradebug Setmypid
Oradebug Unlimit
Oradebug session_event 10046 Trace name Context forever, Level 4--Enable session 10046
Oradebug Event 10046 Trace name context off--shutdown 10046 Event
Oradebug Tracefile_name--View tracefile file location and filename
4> Oracle Process level 10046 with Oradebug
Oradebug Setorapid
Oradebug Unlimit
Oradebug Event 10046 Trace name Context forever, Level 4
Oradebug Event 10046 Trace name context off
Oradebug Tracefile_name
Analysis on the cause of 5> oradebug system Hang-live
If the system hang, as long as the SYS user can log in, then it is very useful to do the reason analysis with Oradebug
Oradebug Setmypid
Oradebug Unlimit
Oradebug Setinst All--rac environment
Oradebug Hanganalyze 3--level is generally specified as 3 enough
Oradebug-g def dump systemstate--rac Environment
Oradebug Tracefile_name
6> Getting status information for a process
Oradebug Setospid 22180
Oradebug Dump Processstate 10
Oradebug Tracefile_name
7> Get process Error information status
Oradebug Setospid 22180
Oradebug Dump Errorstack 3
8> tracks the cause of the error message, such as ORA-04031
Oradebug event 4031 Trace name Errorstack level 3
9> Tracking Oracle Process sample:
Oradebug Setorapid 120
Oradebug Unlimit
Oradebug Event 10046 Trace name Context forever, Level 4
Oradebug Event 10046 Trace name context off
Oradebug Tracefile_name
Oracle's ORADEBUG command usage