Re: Database Cache Hit Ratio (Warning)

2020-04-03 Thread Rajiv Ranjan
. Johnston wrote: > On Tuesday, March 31, 2020, Rajiv Ranjan wrote: > >> Hi, >> >> Received a Database cache hit ratio warning alert from one of the >> monitoring tools, the threshold for the “database cache hit ratio %” is >> 90% for a High and 95% for Critical

Re: Database Cache Hit Ratio (Warning)

2020-04-03 Thread David G. Johnston
On Fri, Apr 3, 2020 at 5:17 AM Rajiv Ranjan wrote: > Does this unnamed monitoring tool (and undefined query) really think > higher percentages are worse or are you mis-communicating? > > Forget about the tool used for monitoring, important is to monitor the > "Cache hit ratio" is good or we can i

Re: Database Cache Hit Ratio (Warning)

2020-03-31 Thread David G. Johnston
On Tuesday, March 31, 2020, Rajiv Ranjan wrote: > Hi, > > Received a Database cache hit ratio warning alert from one of the > monitoring tools, the threshold for the “database cache hit ratio %” is > 90% for a High and 95% for Critical > Does this unnamed monitoring tool (a

Database Cache Hit Ratio (Warning)

2020-03-31 Thread Rajiv Ranjan
Hi, Received a Database cache hit ratio warning alert from one of the monitoring tools, the threshold for the “database cache hit ratio %” is 90% for a High and 95% for Critical Below hardware, CPU, disk and memory utilization of the system. Kindly suggest the parameters for a cache hit ratio or