C:\Documents and Settings\Administrator>sqlplus sys/password@wrd as sysdba

SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 1月 19 13:15:04 2010

连接到:

Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> oradebug help

HELP [command] Describe one or all commands

SETMYPID Debug current process

SETOSPID Set OS pid of process to debug

SETORAPID ['force'] Set Oracle pid of process to debug

SHORT_STACK Dump abridged OS stack

DUMP [addr] Invoke named dump

DUMPSGA [bytes] Dump fixed SGA

DUMPLIST Print a list of available dumps

EVENT Set trace event in process

SESSION_EVENT Set trace event in session

DUMPVAR [level] Print/dump a fixed PGA/SGA/UGA variable

DUMPTYPE

Print/dump an address with type info

SETVAR Modify a fixed PGA/SGA/UGA variable

PEEK [level] Print/Dump memory

POKE Modify memory

WAKEUP Wake up Oracle process

SUSPEND Suspend execution

RESUME Resume execution

FLUSH Flush pending writes to trace file

CLOSE_TRACE Close trace file

TRACEFILE_NAME Get name of trace file

LKDEBUG Invoke global enqueue service debugger

NSDBX Invoke CGS name-service debugger

-G Parallel oradebug command prefix

-R Parallel oradebug prefix (return output

SETINST Set instance list in double quotes

SGATOFILE Dump SGA to file; dirname in double quotes

DMPCOWSGA Dump & map SGA as COW; dirname in double quotes

MAPCOWSGA Map SGA as COW; dirname in double quotes

HANGANALYZE [level] [syslevel] Analyze system hang

FFBEGIN Flash Freeze the Instance

FFDEREGISTER FF deregister instance from cluster

FFTERMINST Call exit and terminate instance

FFRESUMEINST Resume the flash frozen instance

FFSTATUS Flash freeze status of instance

SKDSTTPCS Helps translate PCs to names

WATCH

Watch a region of memory

DELETE watchpoint Delete a watchpoint

SHOW watchpoints Show watchpoints

CORE Dump core without crashing process

IPC Dump ipc information

UNLIMIT Unlimit the size of the trace file

PROCSTAT Dump process statistics

CALL [-t count] [arg1]...[argn] Invoke function with arguments

oradebug dump heapdump 7 (1-PGA; 2-Shared Pool; 4-UGA; 8-CGA; 16-top CGA; 32-large pool)

SQL>oradebug setmypid

Statement processed.

SQL>oradebug dump heapdump 2

Statement processed.

SQL> oradebug setmypid;
Statement processed.

SQL> oradebug dump controlf 4;
Statement processed.

ITPub博客

oradebug应用

最新文章