Written by one the world's most widely-read Oracle script developers and author
of 14 best-selling Oracle books, Mike Ault targets his substantial
knowledge of Oracle tuning in this concise eBook. With decades of
experience using Oracle, Mike Ault shares secrets for Oracle
* Use ORADEBUG
to Trace A Sessions SQL.
* Find Parallel SQL Processes Using ORADEBUG.
* Learn how to determine the Events Set in a System.
* Use ORADEBUG to Look at Library Cache States.
About the Author:
has five Oracle Masters Certificates. Ault was the first popular Oracle author with his book "Oracle7 Administration and Management"
and he also
wrote several of the "Exam Cram" books.
Table of Contents:
Monitoring the Current Session With the oradebug setmypid
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