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:[EMAIL PROTECTED]]
> 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: [EMAIL PROTECTED]; [EMAIL PROTECTED]
>
>
> 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 [EMAIL PROTECTED]
> to subscribe send a blank email to [EMAIL PROTECTED]
> 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: [EMAIL PROTECTED]
>
> 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
