Databases Reference
In-Depth Information
find out which interconnect address and protocol RAC instances use
modify data structures in the SGA
In all likelihood, the last item will be relevant only to Oracle Support personnel.
ORADEBUG Workflow
When using
ORADEBUG
, the basic workflow is as follows:
Start SQL*Plus and connect as
SYSDBA.
1.
2.
Attach to a process of an ORACLE instance.
3.
Issue one or more
ORADEBUG
commands.
4.
Examine screen output or trace files.
5.
Detach from the process (occurs automatically when exiting from SQL*Plus or attaching to
another process).
ORADEBUG Command Reference
The SQL*Plus help facility does not cover
ORADEBUG
, but the command itself has a help option
that prints all available commands.
SQL> ORADEBUG HELP
HELP [command] Describe one or all commands
SETMYPID Debug current process
SETOSPID <ospid> Set OS pid of process to debug
SETORAPID <orapid> ['force'] Set Oracle pid of process to debug
SHORT_STACK Dump abridged OS stack
DUMP <dump_name> <lvl> [addr] Invoke named dump
DUMPSGA [bytes] Dump fixed SGA
DUMPLIST Print a list of available dumps
EVENT <text> Set trace event in process
SESSION_EVENT <text> Set trace event in session
DUMPVAR <p|s|uga> <name> [level] Print/dump a fixed PGA/SGA/UGA variable
DUMPTYPE <address> <type> <count> Print/dump an address with type info
SETVAR <p|s|uga> <name> <value> Modify a fixed PGA/SGA/UGA variable
PEEK <addr> <len> [level] Print/Dump memory
POKE <addr> <len> <value> Modify memory
WAKEUP <orapid> Wake up Oracle process
SUSPEND Suspend execution