RE: DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

2003-07-23 Thread Hallas, John, Tech Dev
Not sure what exactly you are asking here but one way of sizing the multiple buffer pools is to look at V$DB_CACHE_ADVICE view. The following is from the 9i performance tuning manual V$DB_CACHE_ADVICE can be used to size all pools configured on an instance. Make the initial cache size estimate,

DB_BLOCK_LRU_LATCHES , multiple buffer pools , oracle9i

2003-07-23 Thread A.Bahar
when configuring multiple buffer pools in oracle9i , how are lru_latches set. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California