DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2000
    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

  2. #2
    Join Date
    Dec 2000
    Ljubljana, Slovenia
    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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.