ORADEBUG is an undocumented debugging utility supplied with Oracle
ORADEBUG is available:
ORADEBUG requires SYSDBA privileges.
To use ORADEBUG within SQL*Plus login using:
SQLPLUS /NOLOG SQL> CONNECT SYS/password AS SYSDBA
To distinguish them from other SQL*Plus commands, all ORADEBUG commands are prefixed with "ORADEBUG"
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:
| SETMYPID |
| SETOSPID |
| SETORAPID |
| SETORAPNAME |