oracle最常用的工具是,Oracle常用的小工具

SQL> oradebug

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

SQL>

SQL>oradebug setmypid

Statement processed.

SQL> alter session set events '10046 trace name context forever ,level 12';