Invoking Oradebug Using Debug Monitoring the Current Session With the oradebug setmypid Using DUMP Commands not requiring SPID to be set Using Oradebug for System Hangs: Getting a PROCESSTATE DUMP Getting a ERRORSTACKS DUMP Using ORADEBUG to Trace A Sessions SQL How to Find the Right PID for oradebug setospid Tracing Errors Using ORADEBUG Using ORADEBUG to Find Semaphore and Memory Segments Finding Parallel SQL Processes Using ORADEBUG Tracking down ORA-04030 errors Using Oradebug to Debug Spinning Processes Oracle IDLM and ORADEBUG How to determine the Events Set in a System Using ORADEBUG to Release DDL locks How to Trace Trigger Actions Using Oradebug Checking on Temporary Segment Usage with Oradebug Suspending a process using Oradebug Resuming A Process using Oradebug Looking at a Processes Statistics using Oradebug Looking at a Process Error Stack Using Oradebug to Dump the SGA Using Oradebug to Look at Latches Using ORADEBUG to Look at Library Cache States Getting Parallel Server DML Locks Using Oradebug Dumping the Control File Contents Using ORADEBUG