Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: sequence

Re: sequence

From: Daud <daud11_at_hotmail.com>
Date: 31 Jul 2003 06:49:48 -0700
Message-ID: <f0bf3cc3.0307310549.3615f227@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US