Fwd: Level of Statspack Report (5 or 7) ? .. Basic Qs
Date: Fri, 31 Oct 2008 08:51:49 +0000
- 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 NigelReceived on Fri Oct 31 2008 - 03:51:49 CDT