Commands Of Oradebug

来源:互联网 发布:js实现上一页下一页 编辑:程序博客网 时间:2024/05/19 12:25
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
SETORAPNAME   <orapname>               Set Oracle process name to debug
SHORT_STACK                             Get abridged OS stack
CURRENT_SQL                             Get current SQL
DUMP          <dump_name><lvl> [addr]  Invokenamed 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/dumpan address with type info
SETVAR        <p|s|uga><name><value>  Modify afixed 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
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            <Inst-List | def |all>   Paralleloradebug command prefix
-R            <Inst-List | def |all>   Paralleloradebug prefix (return output

SETINST       <instance# .. |all>     Set instance list in double quotes
SGATOFILE     <SGA dumpdir>        Dump SGA to file; dirname in double quotes

DMPCOWSGA     <SGA dump dir> Dump &map SGA as COW; dirname in double quotes
MAPCOWSGA     <SGA dumpdir>        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     <ifname> <ofname>       Helps translate PCs to names
WATCH         <address><len><self|exist|all|target> Watch a region of memory

DELETE        <local|global|target> watchpoint<id>   Delete a watchpoint
SHOW          <local|global|target>watchpoints       Show  watchpoints
DIRECT_ACCESS  <set/enable/disablecommand | select query> Fixed table access
CORE                                    Dump core without crashing process
IPC                                     Dump ipc information
UNLIMIT                                 Unlimit the size of the trace file
PROCSTAT                                Dump process statistics
CALL          <func> [arg1] ...[argn]  Invoke function with arguments
SQL>


















































































































































































































原创粉丝点击