Re: How are the snapshot ids generated in statspack?

From: Chuck <skilover_at_softhome.net>
Date: 8 Nov 2005 07:01:13 -0800
Message-ID: <1131462073.135125.23190@o13g2000cwo.googlegroups.com>

"Srikanth" <srikanth.nalla_at_gmail.com> wrote in news:1131438693.621847.138190_at_g49g2000cwa.googlegroups.com:

> I am testing an Oracle Statspack feature and I assumed that snapshot
> ids are generated in sequential order 1,2,3...10 etc if the database
> instance is not shutdown during that period. Is my assumption
> correct?
>

There are ascending sequential but can have gaps.

  SELECT snap_id, snap_time,STARTUP_TIME

      FROM stats$snapshot
     WHERE snap_id BETWEEN 4198 AND 4207

  ORDER BY snap_id;

SNAP_ID SNAP_TIME STARTUP_TIME

------- -------------------- ---------------------
4198    11/8/2005 3:00:04 AM 10/30/2005 7:05:24 AM
4199    11/8/2005 4:00:05 AM 10/30/2005 7:05:24 AM

4206 11/8/2005 5:00:02 AM 10/30/2005 7:05:24 AM 4207 11/8/2005 6:00:02 AM 10/30/2005 7:05:24 AM

As you can see the startup time of the databases did not change but ID's 4200-4205 were skipped. Received on Tue Nov 08 2005 - 09:01:13 CST