ORADEBUG - Undocumented Oracle Utility
This document describes the Oracle utility called oradebug. This tool is primarily used by Oracle Worldwide Customer Support. With the oradebug utility, you can literally see the database engine. oradebug is especially useful when things go very bad - e.g. the database just stops, hangs, or the database keeps crashing with the ORA-0600 error!
To run this tool you must have administrator privileges.
Among the many useful things that can be done with oradebug are:
- enabling/disabling the SQL tracing for another user's session.
- suspending intensive processes
- finding information about shared memory and semaphores
- closing the trace file so that new one can be generated
- manipulating and dumping internal structures
- wake up processes etc.
When asked to "Select a payment method" for your free download, choose "Print and Call". Your download code will be e-mailed to you after we authorize it. International customers should enter TruTek's address as the shipping address and enter their real shipping address in the Special Instructions field on the payment screen.
- Author:: Miladin Modrakovic
- Item #: Paper0022
