SEARCH
Disclaimer: Authors have full rights over their works. Reproduction of any part of the content is prohibited without prior authorization.
BOOK USING THE ORACLE ORADEBUG UTILITY DEBUGGING ORACLE APPLICATIONS 2002
SUMMARY
-
Items Found: 31
- Introduction 1
- Invoking Oradebug 1
- Using Debug 3
- Monitoring the Current Session With the oradebug setmypid 4
- Using DUMP 5
- Commands not requiring SPID to be set 7
- Using Oradebug for System Hangs: 10
- Getting a PROCESSTATE DUMP 11
- Getting a ERRORSTACKS DUMP 12
- Using ORADEBUG to Trace A Sessions SQL 12
- How to Find the Right PID for oradebug setospid 16
- Tracing Errors Using ORADEBUG 17
- Using ORADEBUG to Find Semaphore and Memory Segments 19
- Finding Parallel SQL Processes Using ORADEBUG 21
- Tracking down ORA-04030 errors 22
- Using Oradebug to Debug Spinning Processes 22
- Oracle 8 IDLM and ORADEBUG 23
- How to determine the Events Set in a System 24
- Using ORADEBUG to Release DDL locks 24
- How to Trace Trigger Actions Using Oradebug 26
- Checking on Temporary Segment Usage with Oradebug 26
- Suspending a process using Oradebug 27
- Resuming A Process using Oradebug 27
- Looking at a Processes Statistics using Oradebug 28
- Looking at a Process Error Stack 29
- Using Oradebug to Dump the SGA 29
- Using Oradebug to Look at Latches 30
- Using ORADEBUG to Look at Library Cache States 30
- Getting Parallel Server DML Locks Using Oradebug 31
- Dumping the Control File Contents Using ORADEBUG 31
- Summary 33
