Wrox Home  
Search P2P Archive for: Go

  Return to Index  

expert_oracle_performance thread: sequence cache --- chapter 4


Message #1 by "Stan" <stan0074@y...> on Tue, 4 Mar 2003 00:31:39
Yes, Cached sequence value will be lost , even if you do :alter system 
flush shared pool.

11:31:00 scott@O...> create sequence test_seq cache 1000;

Sequence created.

Elapsed: 00:00:00.02
13:52:55 scott@O...> select test_seq.nextval from dual;

   NEXTVAL
----------
         1
13:53:02 scott@O...> set autotrace off
13:53:07 scott@O...> alter system flush shared_pool;

System altered.

Elapsed: 00:00:00.01
13:53:13 scott@O...> select test_seq.nextval from dual;

   NEXTVAL
----------
      1001

Elapsed: 00:00:00.05 > finally i got the chance to look the sample 
chapters of your new book in beta today (interesting topics covered), 
another must to have book for all dba's :-) 

> okay, i was going through chap. 4 page 8 where you discuss about 
sequence being one of cause for 'recursive calls' and how to mitigate 
those calls. don't know what it might be worth of..."There is a chance due 
to shutting down,..." Sequences doesn't loose its cached value if the 
database are shutdown normal or immediate only on aborts seqeunce looses 
its cached value. not sure if you want to be that specific but thats my 2 
cents.

> once again thanks for yet another wonderful book and the service that 
you provide to dba's / developers through asktom.oracle.com 

> Stan


  Return to Index