| Venkat |
Posted: Jan 19, 2008 04:46:00 PM |
Total Post: 2
Joined: Jan, 2008
|
Hi guys,
My database has high buffer cache hit ratio (95%) but buffer pool hit ratio is just 62%. Application is performing fine. Should I worry about buffer pool hit ratio? Should I increase db_cache_size? Please share your inputs.
Thanks,
Venkat |
|
|
 Mohammed Taj |
| Posted: Jan 19, 2008 11:17:46 PM |  |
|
Total Post: 746
Joined: Jul, 2007
|
Don't worry according ratio indication.
becuase ratio analyse is not useful for performance tuning.
|
|
|
|
|
| Murtuja |
| Posted: Jan 21, 2008 02:48:51 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi,
Can you tell Oracle version as 9i and 10g have lot of difference in performance tuning.
|
|
|
|
|
| Venkat |
| Posted: Jan 21, 2008 11:35:06 AM | |
|
Total Post: 2
Joined: Jan, 2008
|
The version is 9.2.0.6. The buffer pool hit ratio is for the default pool.
|
|
|
|
|
| Murtuja |
| Posted: Jan 22, 2008 12:14:11 AM | |
|
Total Post: 857
Joined: Jan, 2006
|
Hi Venkat,
Generate statspack report and upload it to this site home page.
Get free Database Tuning recommendations from instantly from our online analyzer. Just Upload your AWR or Statspack report and get recommendations. It is fast, free and easy.
http://www.dbapool.com/analyzer/
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
