Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How are the snapshot ids generated in statspack?

Re: How are the snapshot ids generated in statspack?

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 8 Nov 2005 08:02:49 -0800
Message-ID: <1131462599.217141.19780@g44g2000cwa.googlegroups.com>

#Srikanth wrote:

#> 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?

Yes.

But you can always run a SQL query and check out the snapshot id and what time it corresponds to if you need to. Received on Tue Nov 08 2005 - 10:02:49 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US