Using the Oracle oradebug utility: debugging Oracle applications

Cover......Page 1
Notice Notice......Page 5
Using the Oracle oradebug Utility : Publication Information......Page 6
Table Of Contents......Page 7
Invoking Oradebug......Page 10
Using Debug......Page 12
Monitoring the Current Session With the oradebug setmypid......Page 13
Using DUMP......Page 14
Commands not requiring SPID to be set......Page 16
Using Oradebug for System Hangs:......Page 19
Getting a PROCESSTATE DUMP......Page 20
Using ORADEBUG to Trace A Sessions SQL......Page 21
How to Find the Right PID for oradebug setospid......Page 25
Tracing Errors Using ORADEBUG......Page 26
Using ORADEBUG to Find Semaphore and Memory Segments......Page 28
Finding Parallel SQL Processes Using ORADEBUG ORADEBUG......Page 30
Using Oradebug to Debug Spinning Processes......Page 31
Oracle 8 IDLM and ORADEBUG......Page 32
Using ORADEBUG to Release DDL locks......Page 33
Checking on Temporary Segment Usage with Oradebug......Page 35
Resuming A Process using Oradebug Oradebug......Page 36
Looking at a Processes Statistics using Oradebug Oradebug......Page 37
Using Oradebug to Dump the SGA......Page 38
Using ORADEBUG to Look at Library Cache States States......Page 39
Dumping the Control File Contents Using ORADEBUG ORADEBUG......Page 40
Summary......Page 42