RE: Do you use KEEP Buffer Pool in your production system?

I am of the opinion that the majority of DBA's would be better off adding the 
buffers allocated to the keep and recycle pool to the regular buffer cache and 
allowing Oracle to manage it based on demand rather than to manually have to 
manage the keep and recycle pools.

Assumming that the pools could all be sized correctly initially the DBA still 
has the problem that over time many application work loads change.  Unless 
constanst monitoring is employed the pools can easily get "out of tune ".

Just let Oracle manage the buffer cache unless you have an extremely important 
process that requires manual tuning beyond what you can get through SQL alone.


________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of Leyi Zhang (Kamus)
Sent: Friday, March 26, 2010 6:42 AM
To: oracle_l
Subject: Do you use KEEP Buffer Pool in your production system?

Refer to AskTom:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:1590999000346302363

Tom Kyte said:
I would not use the keep pool, the default buffer cache is almost certainly 
better than good enough.
The keep buffer would definitely be in the SGA, it is just another buffer cache.

What do you think? Do you use  KEEP Buffer Pool in your production system?

--
Kamus <kamusis@xxxxxxxxx<mailto:kamusis@xxxxxxxxx>>

Oracle8i & 9i Certified DBA from China
Oracle ACE
Visit my blog for more article: http://www.dbform.com

Other related posts: