Days since Last successful update statistics
Last successful update statistics
N/A
Threshold is exceeded for number of days since the last successful run of brconnect -f stats with options -t all. Return codes 0 (success) or 1 (success with warning) indicate a successful update statistics
Run brconnect -f stats -t all
N/A
For additional information on how to tune the buffer cache, refer to Oracle's documentation
Target | ozsoft.sap.Oracle | ||
Parent Monitor | System.Health.PerformanceState | ||
Category | Operations | ||
Enabled | False | ||
Alert Generate | True | ||
Alert Severity | MatchMonitorHealth | ||
Alert Priority | Normal | ||
Alert Auto Resolve | True | ||
Monitor Type | ozsoft.sap.CCMSMetricMonitorType2 | ||
Remotable | True | ||
Accessibility | Public | ||
Alert Message |
| ||
RunAs | Default |
<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.Optimizer.LastUpdateStats" 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.Optimizer.LastUpdateStats.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="Success"/>
<OperationalState ID="Between" MonitorTypeStateID="SDKMetricUnderHighOverLowThreshold" HealthState="Warning"/>
<OperationalState ID="Over" MonitorTypeStateID="SDKMetricOverHighThreshold" HealthState="Error"/>
</OperationalStates>
<Configuration>
<CounterName>Last succ. update statistics</CounterName>
<ObjectName>Optimizer</ObjectName>
<Frequency>300</Frequency>
<HighThreshold>14</HighThreshold>
<LowThreshold>7</LowThreshold>
</Configuration>
</UnitMonitor>