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 -> Caching in Sequence generators

Caching in Sequence generators

From: D. Oakley <no-one_at_nowhere.com>
Date: Tue, 20 Apr 1999 17:27:48 +0100
Message-ID: <RU1T2.968$kY3.440@news.indigo.ie> 





(Running Oracle 7.3 on Unix)



Hi,



I was having a problem with a sequence generator that i was using in that it
seemed to be skipping numbers in blocks of 20. I presumed this was being
caused by the default cache setting of 20. Firstly, is this a safe
presumtion?



Secondly, what effect will there be on performance of the sequence generator
if I set the caching to NOCACHE?



Thanks.


Received on Tue Apr 20 1999 - 11:27:48 CDT












Original text of this message













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