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***
