NO CACHE in Sequence
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: NO CACHE in Sequence

  1. #1
    Join Date
    Sep 2001
    Posts
    44
    Hi all,

    Why would any one use NO CACHE option in Sequences.


  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    Probably to minimize the possibility of having "sequence gaps", for example in cases of shutdown abort or flushing the shared pool.

    Less probably to somewhat preserve space in shared pool (library cache) - that is perhaps more of a theoretical than a real life excuse.

    In any case, you would use NO CACHE only on sequences that are fairly seldom in use, not on those that are under constant pressure.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

  3. #3
    Join Date
    Sep 2001
    Location
    NJ, USA
    Posts
    1,287
    First reason - what Juriy wrote - flash shared pool
    Second reason, and I saw that in practice :
    when u do SHUTDOWN ABORT or u server crash then u loose
    all sequence values in cache.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width