Querying the
does
not actually return the current value; it only returns an upper bound on that
value, that is, the end of the chunk of sequence values which has been
preallocated but not actually used. The
SYSCS_UTIL.SYSCS_PEEK_AT_SEQUENCE function shows you the very
next value which will be returned by a NEXT VALUE FOR clause. Users should never
directly query the SYSSEQUENCES table, because that will cause sequence
generator concurrency to slow drastically.