Using the Oracle oradebug utility : debugging Oracle by Mike Ault

By Mike Ault

Show description

Read Online or Download Using the Oracle oradebug utility : debugging Oracle applications PDF

Similar oracle books

Oracle PL/SQL Programming 4Th Edition

За последние 10 лет книга Oracle PL/SQL Programming издательства O'Reilly's стала бестселлером среди книг по PL/SQL, процедурному языку базы данных Oracle. Снабженная примерами и полезными рекомендациями книнга является незаменимой как новичкам, так и гуру, как разработчикам на Oracle kinds, так и администраторам - используйте PL/SQL на полную мощь.

Oracle Streams 11g Data Replication

Grasp Oracle Streams 11g Replication permit real-time info entry and information sharing throughout your dispensed framework utilizing the professional info during this Oracle Press consultant. Oracle Streams 11g facts Replication explains the right way to organize and administer a unified firm facts sharing infrastructure.

Oracle Application Express 4 Recipes

Oracle software convey four Recipes presents an example-based method of studying program exhibit - the ground-breaking, fast software improvement platform incorporated with each Oracle Database license. The recipes layout is perfect for the quick-study who simply desires a superb instance or to kick begin their considering and get pointed within the correct path.

Additional info for Using the Oracle oradebug utility : debugging Oracle applications

Example text

Why this works: What actually being held on a stored pacakage/procedure/function when a user process is running it is a library cache pin. It remains in force till the execution completes. If the running process is interupted (gets ORA1013), then the process will rollback any changes (this could take a very long time) and then release the pin. During the rollback, the library cache pin is being held. If you kill the session (alter system kill session), the corresponding server process is not necessarily killed immediately.

By doing alter system kill session, followed by zapping processes, followed by PMON wakeup, you get nearly instant results. MONOGRAPH PAGE 25 COPYRIGHT © 2002 RAMPANT TECHPRESS. ALL RIGHTS RESERVED. ROBO BOOKS MONOGRAPH USING THE ORADEBUG UTILITY How to Trace Trigger Actions Using Oradebug Tracing trigger actions is easy to do in oradebug, you simply set the 10309 event using a level 1 trace. $ sqlplus -s /nolog SQL> connect / as sysdba Connected. SQL> oradebug event 10309 trace name context forever, Statement Porcessed.

ALL RIGHTS RESERVED. ROBO BOOKS MONOGRAPH USING THE ORADEBUG UTILITY Summary The ORADEBUG utility is a powerful and complex utility which allows you to easily control the dumping and tracing of virtually any database information relating processes. We have only touched the surface in this paper. Whenever using ORADEBUG be sure to try the options on a test environment before attempting them in a production situation. MONOGRAPH PAGE 33 COPYRIGHT © 2002 RAMPANT TECHPRESS. ALL RIGHTS RESERVED.

Download PDF sample

Rated 4.62 of 5 – based on 20 votes