RE: HOW TO SET SEQUENCE VALUE

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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] 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

On Thu, Mar 29, 2012 at 2:49 PM, Taylor, Chris David <ChrisDavid.Taylor_at_ingrambarge.com> wrote:
> CACHE_SIZE = 20?
>
> Create sequence NOCACHE
>
> 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_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of jose soares
> Sent: Thursday, March 29, 2012 6:24 AM
> To: oracle_at_dunbar-it.co.uk
> Cc: oracle-l_at_freelists.org
> Subject: Re: HOW TO SET SEQUENCE VALUE
>
> I can't understand these two queries:
>
> select last)number from user_sequences where sequence_name='ANAGRAFICA_SEQ'
> last_number
> ---------------------
> 24
>
> select anagrafica_seq.nextval from dual nextval
> -------------------------------
> 5
>
> I expect to see 24 instead of 5.
> last_number is not the same value incremented by nextval ?
>
> j

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



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