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
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
considering a proposal regarding
the use of the 3
buffer pools represented by db_cache_size,
db_keep_cache_size,
and db_recycle_cache_size. I am wondering if this is
a good idea
or a bad idea. The proposal follows.
The buffer pool space can be divided into 3 separate
pools: db_cache_size
Hello,
Env: 9.2.0.2 on Solaris 2.9
We are currently considering a proposal regarding the use of the 3
buffer pools represented by db_cache_size, db_keep_cache_size,
and db_recycle_cache_size. I am wondering if this is a good idea
or a bad idea. The proposal follows.
The buffer pool space can
Bill
I don't think too many analytical studies have been done on multiple
buffer pools, but since I am extremely interested in this subject, I'll
provide my opinion, which is worth every bit you paid for it.
Just dividing the buffer pool into three pieces, in my opinion, would
degrade
the use of the 3
buffer pools represented by db_cache_size, db_keep_cache_size,
and db_recycle_cache_size. I am wondering if this is a good idea
or a bad idea. The proposal follows.
The buffer pool space can be divided into 3 separate
pools: db_cache_size, db_keep_cache_size