Mike Ault ORADebug Monograph

29 pages
22 views

Please download to get full document.

View again

of 29
All materials on our website are shared by users. If you have any questions about copyright issues, please report us to resolve them. We are always happy to assist you.
Share
Description
A monograph on using the ORADebug utility.
Tags
Transcript
  Mike Ault Monograph  Monograph M ONOGRAPH   P   AGE  2 C  OPYRIGHT  © 2002 ROBO B OOKS  . A LL R  IGHTS  R  ESERVED .    Notice While ROBO Books makes every effort to ensure the information presented inthis white paper is accurate and without error, ROBO Books, its authors and itsaffiliates takes no responsibility for the use of the information, tips, techniquesor technologies contained in this white paper. The user of this white paper issolely responsible for the consequences of the utilization of the information,tips, techniques or technologies reported herein. Change History ReleaseDateDescriptionBy 1.09/22/2002Initial release in ROBO Books FormatMichael R. Ault M ONOGRAPH   P   AGE  3C  OPYRIGHT  © 2002 ROBO B OOKS  . A LL R  IGHTS  R  ESERVED .    Table Of Contents Notice....................................................................................................................................3 Change History ..............................................................................................................................3 Table Of Contents ................................................................................................................ 4Introduction ..........................................................................................................................6Invoking Oradebug .............................................................................................................. 6Using Debug .........................................................................................................................7 Monitoring the Current Session With the oradebug setmypid ......................................................8Using DUMP .................................................................................................................................8Commands not requiring SPID to be set .....................................................................................10Using Oradebug for System Hangs: ............................................................................................13Getting a PROCESSTATE DUMP .............................................................................................14Getting a ERRORSTACKS DUMP ............................................................................................14Using ORADEBUG to Trace A Sessions SQL ...........................................................................14How to Find the Right PID for oradebug setospid ......................................................................17Tracing Errors Using ORADEBUG ............................................................................................18Using ORADEBUG to Find Semaphore and Memory Segments .............................................. 20Finding Parallel SQL Processes Using ORADEBUG ................................................................ 21Tracking down ORA-04030 errors .............................................................................................22Using Oradebug to Debug Spinning Processes ...........................................................................22Oracle 8 IDLM and ORADEBUG ..............................................................................................23How to determine the Events Set in a System ...........................................................................23Using ORADEBUG to Release DDL locks ...............................................................................23How to Trace Trigger Actions Using Oradebug .........................................................................24Checking on Temporary Segment Usage with Oradebug ...........................................................24Suspending a process using Oradebug ........................................................................................25Resuming A Process using Oradebug .........................................................................................26Looking at a Processes Statistics using Oradebug ......................................................................26Looking at a Process Error Stack ................................................................................................27Using Oradebug to Dump the SGA ............................................................................................27Using Oradebug to Look at Latches ............................................................................................27Using ORADEBUG to Look at Library Cache States ................................................................28Getting Parallel Server DML Locks Using Oradebug ................................................................28Dumping the Control File Contents Using ORADEBUG ..........................................................29 Summary ............................................................................................................................. 29 M ONOGRAPH   P   AGE  4C  OPYRIGHT  © 2002 ROBO B OOKS  . A LL R  IGHTS  R  ESERVED .
Related Search
We Need Your Support
Thank you for visiting our website and your interest in our free products and services. We are nonprofit website to share and download documents. To the running of this website, we need your help to support us.

Thanks to everyone for your continued support.

No, Thanks