Name
oradebug
Use oradebug to enable/disable tracing for a user session, suspend/wake up processes, manipulate and dump SGA structures, and so on. The oradebug utility is invoked from sqlplus, and you need SYSDBA privileges to execute it.
Warning
oradebug is an undocumented utility, and, therefore, its functionality and syntax may change without notice. You must use utmost care when invoking oradebug. Ideally, you should use this utility only on the recommendation of Oracle Support.
Syntax
oradebugaction
action
::= { HELP [command
] |SETMYPID |SETOSPIDospid
|SETORAPIDorapid
['force'] |DUMPdump_name lvl
[addr
] |DUMPSGA [bytes
] |DUMPLIST |EVENTtext
|SESSION_EVENTtext
|DUMPVAR {p|s|u}ganame
[level
] |SETVAR {p|s|u}ganame value
|PEEKaddr len
[level
] |POKEaddr len value
|WAKEUPorapid
|SUSPEND |RESUME |FLUSH |CLOSE_TRACE |TRACEFILE_NAME |LKDEBUG |NSDBX |-G {Inst-List | def | all} |-R {Inst-List | def | all} |SETINST {instance# .. | all} |SGATOFILESGA_dump_dir
|DMPCOWSGASGA_dump_dir
|MAPCOWSGASGA_dump_dir
|HANGANALYZE [level
] [syslevel
] |FFBEGIN |FFDEREGISTER |FFTERMINST |FFRESUMEINST |FFSTATUS |SKDSTTPCSifname ofname
|WATCHaddress len
{self|exist|all|target} |DELETE {local|global|target} watchpointid
|SHOW {local|global|target} watchpoints |CORE |UNLIMIT |PROCSTAT |CALLfunc
[arg1
] ... [argn
] }
Parameters
HELP
[command
]Displays help on all commands, or on the specified command.
SETMYPID
Debugs the current process.
SETOSPID
ospid
Debugs the process with the specified OSPID.
SETORAPID ...
Get Oracle Utilities Pocket Reference now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.