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

oradebug action

action ::= {
   HELP [command]
   |SETMYPID
   |SETOSPID ospid
   |SETORAPID orapid ['force']
   |DUMP dump_name lvl [addr]
   |DUMPSGA [bytes]
   |DUMPLIST
   |EVENT text
   |SESSION_EVENT text
   |DUMPVAR {p|s|u}ga name [level]
   |SETVAR {p|s|u}ga name value
   |PEEK addr len [level]
   |POKE addr len value
   |WAKEUP orapid
   |SUSPEND
   |RESUME
   |FLUSH
   |CLOSE_TRACE
   |TRACEFILE_NAME
   |LKDEBUG
   |NSDBX
   |-G {Inst-List | def | all}
   |-R {Inst-List | def | all}
   |SETINST {instance# .. | all}
   |SGATOFILE SGA_dump_dir
   |DMPCOWSGA SGA_dump_dir
   |MAPCOWSGA SGA_dump_dir
   |HANGANALYZE [level] [syslevel]
   |FFBEGIN
   |FFDEREGISTER
   |FFTERMINST
   |FFRESUMEINST
   |FFSTATUS
   |SKDSTTPCS ifname ofname
   |WATCH address len {self|exist|all|target}
   |DELETE {local|global|target} watchpoint id
   |SHOW {local|global|target} watchpoints
   |CORE
   |UNLIMIT
   |PROCSTAT
   |CALL func [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.