FAQ
Folks

From a Statspack Report is it possible to know the Snap Level (5 or 7)
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***

Search Discussions

  • Nigel Thomas at Oct 31, 2008 at 8:51 am
    Vivek

    From a Statspack Report is it possible to know the Snap Level (5 or 7)

    From the Database how can the Level of an existing Statspack Snap be
    known?

    Snap level is recorded for each snapshot in STAT$SNAPSHOT.SNAP_LEVEL. It is
    reported by sprsqins.sql but not as far as I can quickly see by the general
    statspack report sprepins.sql (looking at an 10gR2 XE version).

    But nothing to stop you adding it yourself ....

    Regards Nigel

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedOct 31, '08 at 5:33a
activeOct 31, '08 at 8:51a
posts2
users2
websiteoracle.com

2 users in discussion

Nigel Thomas: 1 post VIVEK_SHARMA: 1 post

People

Translate

site design / logo © 2022 Grokbase