Re: Database Buffer Cache Hit Ratio

From: <chiragmajmundar_at_gmail.com>
Date: 5 Oct 2005 09:27:06 -0700
Message-ID: <1128529626.586062.218030@z14g2000cwz.googlegroups.com>

I just increased the same and right now it is 44.3%.

but keep on watching, it is increasing every other second.

give it sometime. Let someone shout abt the performance. Just don worry.

check the following results.

DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:26:28

---

Buffer Cache Hit Ratio: 44.29%
Data Dictionary / Row Cache Hit Ratio: 90.01% Library Cache Hit Ratio: 99.95%

SQL> / DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:26:31

---

Buffer Cache Hit Ratio: 44.3%
Data Dictionary / Row Cache Hit Ratio: 90.01% Library Cache Hit Ratio: 99.95%

SQL> / DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:26:38

---

Buffer Cache Hit Ratio: 44.3%
Data Dictionary / Row Cache Hit Ratio: 90.01% Library Cache Hit Ratio: 99.95%

SQL> / DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:27:00

---

Buffer Cache Hit Ratio: 44.36%
Data Dictionary / Row Cache Hit Ratio: 90.05% Library Cache Hit Ratio: 99.95%

SQL> / DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:27:07

---

Buffer Cache Hit Ratio: 44.36%
Data Dictionary / Row Cache Hit Ratio: 90.05% Library Cache Hit Ratio: 99.95%

SQL> / DWMRKP Hit Ratios for: Wednesday 4th October 2005, 12:27:16

---

Buffer Cache Hit Ratio: 44.38%
Data Dictionary / Row Cache Hit Ratio: 90.05% Library Cache Hit Ratio: 99.95%

SQL> regards - chirag Received on Wed Oct 05 2005 - 11:27:06 CDT