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 -> Clarification on sequences without CACHE parameter

Clarification on sequences without CACHE parameter

From: Rajesh Bhave <rajeshb_at_india.hp.com>
Date: Tue, 10 Nov 1998 11:05:49 +0530
Message-ID: <3647D0B4.62BC4E8A@india.hp.com> 





Hello



It is known that Oracle keeps 20 sequence numbers in cache by default. I
need to understand following : If a system failure occurs, then will all
the sequence numbers in cache which are not used in committed DML
statements, lost. If this is correct then it means that Oracle does not
recover the sequence table fully. Please explain.



Thanks and Regards,


Rajesh

Received on Mon Nov 09 1998 - 23:35:49 CST












Original text of this message













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