Re: oradebug
- From: "DBA" <dba@xxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sat, 13 Mar 2004 13:37:27 +0530
Jared,
can u plz point me to some docs on this .What does it really do?.
Thanks
Deep
----- Original Message -----
From: Jared Still <jkstill@xxxxxxxxxx>
To: Oracle-L Freelists <oracle-l@xxxxxxxxxxxxx>
Sent: Friday, March 12, 2004 8:34 AM
Subject: Re: oradebug
>
> Sure there is:
>
>
> 19:04:07 poirot.jks.com - sys@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@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@xxxxxxxxxxxxx
> > > > put 'unsubscribe' in the subject line.
> > > > --
> > > > Archives are at //www.freelists.org/archives/oracle-l/
> > > > FAQ is at //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@xxxxxxxxxxxxx
> > > put 'unsubscribe' in the subject line.
> > > --
> > > Archives are at //www.freelists.org/archives/oracle-l/
> > > FAQ is at //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@xxxxxxxxxxxxx
> > put 'unsubscribe' in the subject line.
> > --
> > Archives are at //www.freelists.org/archives/oracle-l/
> > FAQ is at //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@xxxxxxxxxxxxx
> put 'unsubscribe' in the subject line.
> --
> Archives are at //www.freelists.org/archives/oracle-l/
> FAQ is at //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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
