Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: sequence
Thank you for the reply guys.
regards
Daud
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<dq6Wa.2665$bo1.1534_at_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 - 08:49:48 CDT
![]() |
![]() |