Fwd: Level of Statspack Report (5 or 7) ? .. Basic Qs

From: Nigel Thomas <nigel.cl.thomas_at_googlemail.com>
Date: Fri, 31 Oct 2008 08:51:49 +0000
Message-ID: <53258cd50810310151q33ae02baofcd6639097ac4991@mail.gmail.com>


  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

Received on Fri Oct 31 2008 - 03:51:49 CDT

Original text of this message