SEQUENCE_CACHE_ENTRIES setting
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: SEQUENCE_CACHE_ENTRIES setting

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    SQL> select count(*) "Number of Sequence" , SUM(CACHE_SIZE) "Cache Size Needed" from DBA_sequences
    2 /

    Number of Sequence Cache Size Needed
    ------------------ -----------------
    130 2560

    What should be set for SEQUENCE_CACHE_ENTRIES in initORCL.ora ?

    130 ? or 2560 ?
    1. www.dbasupport.com
    2. www.dbforums.com
    3. www.itpub.net
    4. www.csdn.net
    5. www.umlchina.com
    6. www.tek-tips.com
    7. www.cnforyou.com
    8. fm365.federal.com.cn
    9. www.programmersheaven.com
    10.http://msdn.microsoft.com/library/default.asp
    ligang1000@hotmail.com

  2. #2
    Join Date
    Dec 2000
    Location
    Ljubljana, Slovenia
    Posts
    4,439
    It doesn't matter what you set it at all, it has absolutely no influence whatsoever, unless you are using some very ancient release of Oracle.

    Since sequences were moved from row cache into library cache (sometime arount 7.2, I belive) that parameter was there only for backward compatibility. Check also http://www.ixora.com.au/q+a/params.htm

    In case you are using Oracle7.0 or Oracle6 or something like that, then set it to 130 for your situation - it was the number of sequences that mattered, not the number of values that were "cached". Because what realy is cached is the current number and the current HWM for each sequence, not the whole bucket of numbers for each of them.
    Jurij Modic
    ASCII a stupid question, get a stupid ANSI
    24 hours in a day .... 24 beer in a case .... coincidence?

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