| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> Re: How are the snapshot ids generated in statspack?
The snapshot id's come from the STATS$SNAPSHOT_ID sequence.
Sequence values might be lost if the instance is shutdown or if the
cached values are flushed either explicitly (using alter system flush
shared_pool) or implicitly when space is insufficient.
If you want to avoid skipping sequence values alter the sequence to
nocache.
alter sequence perfstat.STATS$SNAPSHOT_ID nocache;
regards
srivenu
Received on Tue Nov 08 2005 - 10:21:45 CST
 |
 |