Level of Statspack Report (5 or 7) ? .. Basic Qs
- From: VIVEK_SHARMA <VIVEK_SHARMA@xxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2008 11:03:10 +0530
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***
Other related posts:
- » Level of Statspack Report (5 or 7) ? .. Basic Qs
