Re: User_Sequence's LAST_NUMBER column: what is it?

• post for FREE via your newsreader at post.newsfeeds.com ***

Hi,

Last sequence number written to disk. If a sequence uses caching, the number written to disk is the last number placed in the sequence cache. This number is likely to be greater than the last sequence number that was used

--
Roman Mirzaitov
Brainbench MVP for Oracle Administration
www.brainbench.com


"Jerry Liu" <taora2000_at_yahoo.com> wrote in message
news:1b78c562.0110101802.2b2cc970_at_posting.google.com...


> Would someone know what the "LAST_NUMBER" column of the user_sequences

> dictionary table contains? It does not seem to be related to the

> "NEXTVAL" or "CURRVAL" (see below)

> --------------------------------------------------------------------------

---


> SQL> ed

> Wrote file afiedt.buf

>

>   1  select SEQUENCE_NAME, min_value, max_value, last_number

>   2* from user_sequences where sequence_name = 'MY_SEQ_20011010'

> SQL> /

>

> SEQUENCE_NAME                   MIN_VALUE  MAX_VALUE LAST_NUMBER

> ------------------------------ ---------- ---------- -----------

> MY_SEQ_20011010                         1 1.0000E+27          21

>

> SQL> select MY_SEQ_20011010.nextval, MY_SEQ_20011010.currval from

> dual;

>

>    NEXTVAL    CURRVAL

> ---------- ----------

>          8          8

> --------------------------------------------------------------------------

-----


> Thanks,

>

> Jerry





-----= Posted via Newsfeeds.Com, Uncensored Usenet News =-----
http://www.newsfeeds.com - The #1 Newsgroup Service in the World!
-----==  Over 90,000 Newsgroups - 16 Different Servers! =-----