How would you go about increasing the buffer cache hit
ratio?
- 1 Answers
- 2704 Views
- I also Faced
- E-Mail Answers
Answer Posted / Kalpana Gangwar
To increase the buffer cache hit ratio, you can optimize database queries, reduce the number of sorts and scans, ensure proper sizing of the SGA (System Global Area), use appropriate indexes, and minimize the use of temporary tables. Additionally, configuring the keep and reload settings for the buffer pools can help maintain a high cache hit ratio.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
