Home
  •  

Buffers: Buffer cache

ozsoft.sap.Monitor.Oracle.Buffers.BufferCache (UnitMonitor)

Buffer cache hit ratio

Knowledge Base article:

Summary

Buffer cache

Configuration

N/A

Causes

The buffer cache hit ratio fell below the configured threshold

Resolutions

Increase the size of the buffer cache only if the previous size increase improved the buffer cache hit ratio. For most applications, the buffer cache hit ratio should be above 90%. Applications that mostly execute long table scans cannot benefit as much from the buffer cache since such applications tend to overwrite the buffer cache

Additional

N/A

External

For additional information on how to tune the buffer cache, refer to Oracle's documentation

Element properties:

Targetozsoft.sap.Oracle
Parent MonitorSystem.Health.PerformanceState
CategoryOperations
EnabledFalse
Alert GenerateTrue
Alert SeverityMatchMonitorHealth
Alert PriorityNormal
Alert Auto ResolveTrue
Monitor Typeozsoft.sap.CCMSMetricMonitorType2
RemotableTrue
AccessibilityPublic
Alert Message
Buffers: Buffer cache
{0} : {1} has a value {2}
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.Buffers.BufferCache" Accessibility="Public" Enabled="false" Target="ozsoft.sap.Oracle" ParentMonitorID="Health!System.Health.PerformanceState" Remotable="true" Priority="Normal" TypeID="ozsoft.sap.CCMSMetricMonitorType2" ConfirmDelivery="false">

  <Category>Operations</Category>

  <AlertSettings AlertMessage="ozsoft.sap.Monitor.Oracle.Buffers.BufferCache.AlertMessageResourceID">

    <AlertOnState>Warning</AlertOnState>

    <AutoResolve>true</AutoResolve>

    <AlertPriority>Normal</AlertPriority>

    <AlertSeverity>MatchMonitorHealth</AlertSeverity>

    <AlertParameters>

      <AlertParameter1>$Data/Context/ObjectName$</AlertParameter1>

      <AlertParameter2>$Data/Context/CounterName$</AlertParameter2>

      <AlertParameter3>$Data/Context/Value$</AlertParameter3>

    </AlertParameters>

  </AlertSettings>

  <OperationalStates>

    <OperationalState ID="Under" MonitorTypeStateID="SDKMetricUnderLowThreshold" HealthState="Error"/>

    <OperationalState ID="Between" MonitorTypeStateID="SDKMetricUnderHighOverLowThreshold" HealthState="Warning"/>

    <OperationalState ID="Over" MonitorTypeStateID="SDKMetricOverHighThreshold" HealthState="Success"/>

  </OperationalStates>

  <Configuration>

    <CounterName>Buffer cache</CounterName>

    <ObjectName>Buffers</ObjectName>

    <Frequency>60</Frequency>

    <HighThreshold>95</HighThreshold>

    <LowThreshold>80</LowThreshold>

  </Configuration>

</UnitMonitor>