Re: oradebug

From: Jared Still <jkstill_at_cybcon.com>
Date: Thu, 11 Mar 2004 19:04:38 -0800
Message-Id: <1079060678.11030.10699.camel@poirot>

Sure there is:

19:04:07 poirot.jks.com - sys_at_ts01 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
DUMP           <dump_name> <lvl> [addr]  Invoke named 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
SETVAR         <p|s|uga> <name> <value>  Modify a fixed 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>   Parallel oradebug command
prefix
-R             <Inst-List | def | all>   Parallel oradebug prefix
(return output
SETINST        <instance# .. | all>      Set instance list in double
quotes
SGATOFILE      <SGA dump dir>         Dump SGA to file; dirname in
double quotes
DMPCOWSGA      <SGA dump dir> Dump & map SGA as COW; dirname in double
quotes
MAPCOWSGA      <SGA dump dir>         Map SGA as COW; dirname in double
quotes
HANGANALYZE    [level]                   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
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

19:04:10 poirot.jks.com - sys_at_ts01 SQL>

On Thu, 2004-03-11 at 06:06, Mladen Gogala wrote:
> What would suspending a session actually mean? There is no such session state
> as "suspended".
>
> On 03/11/2004 09:15:34 AM, Database Admin wrote:
> > Hi Mladen,
> > thanks man I knw that but I am unable to SUSPEND a session using
> > oadebug suspend pid;
> > it asks for more params ,where can I find this info.I sent u a per mail
> > abt this on wangtrading it bounced.Do reply
> > cheers
> > Deep
> > >
> > > On 03/11/2004 08:32:28 AM, Database Admin wrote:
> > >> Hi,
> > >> Can u enlighten me abt oradebug.
> > >
> > > No. Just type oradebug help and try it. No enlightenment necessary. --
> > > Mladen Gogala
> > > Oracle DBA
> > > ----------------------------------------------------------------
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > ----------------------------------------------------------------
> > > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at http://www.freelists.org/archives/oracle-l/
> > > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > > -----------------------------------------------------------------
> >
> >
> >
> > ----------------------------------------------------------------
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > ----------------------------------------------------------------
> > To unsubscribe send email to: oracle-l-request_at_freelists.org
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at http://www.freelists.org/archives/oracle-l/
> > FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> > -----------------------------------------------------------------
> >
> ----------------------------------------------------------------
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> ----------------------------------------------------------------
> To unsubscribe send email to: oracle-l-request_at_freelists.org
> put 'unsubscribe' in the subject line.
> --
> Archives are at http://www.freelists.org/archives/oracle-l/
> FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
> -----------------------------------------------------------------

Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Mar 11 2004 - 20:58:41 CST