Tools - ORADEBUG

ORADEBUG Introduction

ORADEBUG is an undocumented debugging utility supplied with Oracle

Available

• as a standalone utility on Unix (oradbx)
• as a standalone utility on VMS (orambx)
• within Server Manager (svrmgr)
• within SQL*Plus (Oracle 8.1.5 and above)

To use ORADEBUG within SQL*Plus login using

  SQLPLUS /NOLOG
  SQL> CONNECT SYS/password AS SYSDBA

For example to list the available options use

  ORADEBUG HELP

The commands vary with different releases and platforms

Note that various ORADEBUG commands do not work on some platforms, notably Windows NT and Windows 2000

Before using ORADEBUG commands, a process must be selected. Depending on the commands to be issued, this can either be the current process or another process.

Once a process has been selected, this will be used as the ORADEBUG process until another process is selected.

For more details see