Sequence - Cache expire ?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 20 Aug 2002 09:30:11 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA70287E2FF@lnewton.leeds.lfs.co.uk>

Ender,

yes it could happen without an explicit flush.

When Oracle starts running out of space in the shared pool, it will flush out stuff that hasn't been used for a while to make room for new stuff it needs right this very minute. This will explain how your sequences seem to be missing values.

You can pin a squence in memory at by calling DBMS_SHERED_POOL.KEEP(sequence_name, 'Q') to avoid this happening.

Regards,
Norman.

---

Norman Dunbar
Database/Unix administrator
Lynx Financial Systems Ltd.
mailto:Norman.Dunbar_at_LFS.co.uk

Tel: 0113 289 6265
Fax: 0113 289 3146
URL: http://www.Lynx-FS.com


-------------------------------------

-----Original Message-----
From: Ender Wiggin [mailto:ender_wiggin29plus1_at_yahoo.com] Posted At: Tuesday, August 20, 2002 4:01 AM Posted To: server
Conversation: Sequence - Cache expire ?
Subject: Re: Sequence - Cache expire ?

could this happen without an explicit flush of shared pool ? Initial gut

feeling says "yes". Received on Tue Aug 20 2002 - 03:30:11 CDT