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
Reply With Quote