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

Home -> Community -> Usenet -> c.d.o.misc -> sequence omits numbers?

sequence omits numbers?

From: Norman Dunbar <Norman.Dunbar_at_lfs.co.uk>
Date: Tue, 5 Aug 2003 15:59:09 +0100
Message-ID: <E2F6A70FE45242488C865C3BC1245DA703FE3663@lnewton.leeds.lfs.co.uk>


Hi Stephan,

'nocahce' will incur performance penalties if the sequence is hit a lot.

The best solution is to pin the sequence in memory, then you have the best of both worlds - fast(er) responses because the values are cached, and no loss of cached values (unless shutdown abort called).

Cheers,
Norm.



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

-------------------------------------
Received on Tue Aug 05 2003 - 09:59:09 CDT

Original text of this message

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