Fwd: Level of Statspack Report (5 or 7) ? .. Basic Qs
- From: "Nigel Thomas" <nigel.cl.thomas@xxxxxxxxxxxxxx>
- To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
- Date: Fri, 31 Oct 2008 08:51:49 +0000
Vivek
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?
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
Other related posts:
- » Fwd: Level of Statspack Report (5 or 7) ? .. Basic Qs