Re: sequence

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Thu, 31 Jul 2003 10:44:25 GMT
Message-ID: <dq6Wa.2665$bo1.1534@news-server.bigpond.net.au>

"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 Thu Jul 31 2003 - 05:44:25 CDT