RE: [Q] why sequence number jump?

That is because sequences are allocated in the library cache since 7.3. And objects from this area of the shared pool are prone to be flushed. As Gorbounov said you can set them nocache or use the dbms_shared_pool.keep for pinning them in the library cache.

Regards.
> -----Mensaje original-----
> De: Vadim Gorbounov [SMTP:vgorbounov_at_simplyengineering.com]
> Enviado el: martes 6 de marzo de 2001 21:14
> Para: Multiple recipients of list ORACLE-L
> Asunto: RE: [Q] why sequence number jump?
>
> do
> ALTER SEQUENCE xxx nocache;
>
>
> -----Original Message-----
> Sent: Tuesday, March 06, 2001 2:35 PM
> To: oracle-l_at_fatcity.com; oracledba_at_quickdoc.co.uk
>
>
> We have ORACLE 8.1.6 on UNIX server. The database has been run 4 years no
> sequence number probem. Recently, user complaint on couple of sequence
> nuber jump rapidly. The sequence number jump may 20, 40 or 100.
>
> I know I can use "alter sequence XXX nocahe" to avoid this problem. I
> want know why it jump?
>
>
> Thanks.
>
>
> --------
> Think you know someone who can answer the above question? Forward it to
> them!
> to unsubscribe, send a blank email to oracledba-unsubscribe_at_LAZYDBA.com
> to subscribe send a blank email to oracledba-subscribe_at_LAZYDBA.com
> Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Vadim Gorbounov
> INET: vgorbounov_at_simplyengineering.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Trassens, Christian
  INET: CTrassens_at_uni2.es

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).