Home » RDBMS Server » Server Administration » systemstate
systemstate [message #55648] Thu, 06 February 2003 10:03 Go to next message
rodger
Messages: 10
Registered: August 2002
Junior Member
Is there any documentation around to describe what each of the following diagnostic tools do, when to initiate them and how. What is the difference between them all?

Systemstates
Errorstacks
Hanganalyze
Event 10046
File header
Heapdumps
Operating system diagnostics
Oracle Net Services (SQL*Net)
Statspack
RDA

I cannot find any documentation and I know Oracle support use them, but we need to know what diagnostic tool to initiate when an error event occurs, before we call oracle support.

Thanks for help
Dawn
Re: systemstate [message #55653 is a reply to message #55648] Thu, 06 February 2003 12:41 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
most diagnostic options are from ORADEBUG
C:>svrmgrl

Oracle Server Manager Release 3.1.6.0.0 - Production

Copyright (c) 1997, 1999, Oracle Corporation.  All Rights Reserved.

Oracle8i Enterprise Edition Release 8.1.6.0.0 - Production
With the Partitioning option
JServer Release 8.1.6.0.0 - Production

SVRMGR> connect internal
Connected.
SVRMGR> 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> <level>       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&#124s&#124uga> <name> [[level]]  Print/dump a fixed PGA/SGA/UGA variable
SETVAR         <p&#124s&#124uga> <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 lock manager debugger
NSDBX                                    Invoke CGS name-service debugger
-G                                       OPS-command prefix
-R                                       lkdebug OPS-command prefix
SETINST                                  set instance list
RELEASE                                  release instance list
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
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

----------------------------------------------------------------------

RDA       - Remote Diagnostic agent
statspack - A very advanced version of utlbstat/utlestat ( search google for statspack..ya'll get a ton of them);
Event 10046 is tracing event.

Re: systemstate [message #55664 is a reply to message #55653] Fri, 07 February 2003 01:33 Go to previous message
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
Senior Member
hello,
and there is one more tool called as ORASTACK through which we can Increase or decrease the default space allocated for the processes .. like u can set u r defined size for oracle.exe etc., ..

sai
Previous Topic: Oracle 9i Installation problem - No Jre !
Next Topic: OracleTNSListener error
Goto Forum:
  


Current Time: Thu Sep 19 23:14:53 CDT 2024