Level of Statspack Report (5 or 7) ? .. Basic Qs

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Fri, 31 Oct 2008 11:03:10 +0530
Message-ID: <69E1360E54B50C4A828A136C158E4742055466253E@BLRKECMBX02.ad.infosys.com>

Folks

1. From a Statspack Report is it possible to know the Snap Level (5 or 7)
2. From the Database how can the Level of an existing Statspack Snap be known?

If the following 3 Sections are Missing in the Statspack Report, does it imply that it is a Level 5 Report?

Cheers & Thanks V much

P.S. Sections in Statspack Report:-

Segments by Row Lock Waits DB/Inst: PNB70NR/PNB70NR Snaps: 1201-1203
-> End Segment Row Lock Waits Threshold: 100

                                                                       Row
                                           Subobject    Obj.          Lock   Pct
Owner      Tablespace Object Name          Name         Type         Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
. . .
          -------------------------------------------------------------

Segments by ITL Waits  DB/Inst: PNB70NR/PNB70NR  Snaps: 1201-1203


-> End Segment ITL Waits Threshold:         1


                                           Subobject    Obj.           ITL   Pct
Owner      Tablespace Object Name          Name         Type         Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
. . .
          -------------------------------------------------------------

Segments by Buffer Busy Waits  DB/Inst: PNB70NR/PNB70NR  Snaps: 1201-1203


-> End Segment Buffer Busy Waits Threshold:       100



                                           Subobject    Obj.           ITL   Pct
Owner      Tablespace Object Name          Name         Type         Waits Total
---------- ---------- -------------------- ------------ ----- ------------ -----
. . .
          -------------------------------------------------------------

**************** CAUTION - Disclaimer *****************

This e-mail contains PRIVILEGED AND CONFIDENTIAL INFORMATION intended solely for the use of the addressee(s). If you are not the intended recipient, please notify the sender by e-mail and delete the original message. Further, you are not to copy, disclose, or distribute this e-mail or its contents to any other person and any such actions are unlawful. This e-mail may contain viruses. Infosys has taken every reasonable precaution to minimize this risk, but is not liable for any damage you may sustain as a result of any virus in this e-mail. You should carry out your own virus checks before opening the e-mail or attachment. Infosys reserves the right to monitor and review the content of all messages sent to or from this e-mail address. Messages sent to or from this e-mail address may be stored on the Infosys e-mail system.
***INFOSYS******** End of Disclaimer ********INFOSYS***

--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 31 2008 - 00:33:10 CDT