Home
  •  

Optional indexes: Too many indexes created

ozsoft.sap.Monitor.Oracle.OptionalIndexes.TooMany (UnitMonitor)

Too many indexes created

Knowledge Base article:

Summary

Too many indexes created

Configuration

N/A

Causes

Indexes defined in the ABAP Dictionary as optional database indexes have been found. All the indexes which are defined in the ABAP Dictionary but for which a flag is set that they should not be created on the database to their system configuration or database system are displayed here as well

Resolutions

Determine if these indexes have been created

Additional

N/A

External

N/A

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
Optional indexes: Too many indexes created
{0} : {1} has a value {2}
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.OptionalIndexes.TooMany" 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.OptionalIndexes.TooMany.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>Too many indexes created</CounterName>

    <ObjectName>Optional indexes</ObjectName>

    <Frequency>900</Frequency>

    <HighThreshold>200</HighThreshold>

    <LowThreshold>100</LowThreshold>

  </Configuration>

</UnitMonitor>