sequence

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Fri, 1 Aug 2003 10:29:35 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703FAB139@lnewton.leeds.lfs.co.uk>

Hi Stan,

indeed they do !
Thanks.

Cheers,
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: Stan [mailto:stan0074_at_yahoo.com]
Posted At: Friday, August 01, 2003 6:07 AM Posted To: server
Conversation: sequence
Subject: Re: sequence

In addition norman and richard comments...

cached values will be lost only in shutdown abort mode. normal and immediate modes, they work normal.

hth,
Stan

Richard Foote wrote:
> "Norman Dunbar" <Norman.Dunbar_at_lfs.co.uk> wrote in message
>

news:E2F6A70FE45242488C865C3BC1245DA703F9B1C6_at_lnewton.leeds.lfs.co.uk...
>
>>Morning,
>
> <snip>
> PIN :
>
>>the sequence cannot be flushed out of the shared pool - so flushing
>>won't affect any cached entries, only shutdown.
>>
>
>
>
> Hi Norman,
>
> The only thing I would add is that a "Pinned" sequence can't be aged
out
> either which is possible if a sequence isn't accessed for a sufficient
> period of time.
>
> Cheers
>
> Richard
>
>
Received on Fri Aug 01 2003 - 04:29:35 CDT