Buffer cache tuning - Oracle 9i
Hello,
I would like to ask 2 questions about buffer cache tuning.
Current status:
- Cache hit ration 98% which is great
- but advisor tells me that if I increase buffer cache by factor of 2 then physical reads will decrease to half
- we have huge number of waits on db sequential reads and db scattered read
- currently buffer cache size is 8GB
1. Should I increase buffer cache to 16 GB? Will it help? What will happen with CPU usage? I know that general advices are to increase buffer cache if cache hit ratio is bad but what if there is huge number of waits on readings?
I would like to ask 2 questions about buffer cache tuning.
Current status:
- Cache hit ration 98% which is great
- but advisor tells me that if I increase buffer cache by factor of 2 then physical reads will decrease to half
- we have huge number of waits on db sequential reads and db scattered read
- currently buffer cache size is 8GB
1. Should I increase buffer cache to 16 GB? Will it help? What will happen with CPU usage? I know that general advices are to increase buffer cache if cache hit ratio is bad but what if there is huge number of waits on readings?
0