RE: HOW TO SET SEQUENCE VALUE

Also be advised that sequences can age out of the cache and lose your cached 
values.  The next time the sequence is called a new cache of numbers is 
generated and the unused sequence values [before it was aged out] are 'lost'. 
(I wanted to verify that info was correct before I posted so I double checked)



Chris Taylor

“Quality is never an accident; it is always the result of intelligent effort.”
-- John Ruskin (English Writer 1819-1900)

Any views and/or opinions expressed herein are my own and do not necessarily 
reflect the views of Ingram Industries, its affiliates, its subsidiaries or its 
employees. 


-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Ilmar Kerm
Sent: Thursday, March 29, 2012 7:01 AM
To: Oracle-L Freelists
Subject: Re: HOW TO SET SEQUENCE VALUE

Quite dangerous advice, I think... Cache is a very important part of sequence 
performance (and maybe the default 20 is too low nowadays also). Using NOCACHE 
should be a very rare occasion, when "losing"
sequence numbers on instance restarts is not allowed.
USER_SEQUENCES just reports what value is stored in data dictionary, but 
database instance is giving out cached sequence numbers. So the difference is 
normal.

Ilmar

--
http://www.freelists.org/webpage/oracle-l

Other related posts: