Home
  •  

Segments: Segments with too few allocatable extents

ozsoft.sap.Monitor.Oracle.Segments.TooFewAllocatableExtents (UnitMonitor)

Number of segments with too few allocatable extents

Knowledge Base article:

Summary

A number of segments with too few allocatable extents

Configuration

N/A

Causes

The number of segments with too few allocatable extents has exceeded the configured threshold.

"Too few" is defined in the properties of another monitor node, "Fewest allocatable extents for a segment."

All segments that would raise a yellow or red alert in that node (Fewest allocatable extents for a segment) are counted and included in this node. Only segments in the SAP schema for which PCTINCREASE is set to zero are considered

Resolutions

To determine which segments are affected, run the analysis method, which will list all segments with fewer allocatable extents than specified in the node’s thresholds. If the NEXT storage parameter for this segment is set too high, decrease it to allow the segment to allocate more extents. If NEXT is set as intended, add another datafile to the tablespace or activate the feature to extend datafiles

Additional

N/A

External

Please refer to SAP Documentations and Notes

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
Segments with too few allocatable extents
{0} : {1} has a value {2}
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.Segments.TooFewAllocatableExtents" 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.Segments.TooFewAllocatableExtents.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>Segments w. too few allocatable extents</CounterName>

    <ObjectName>Segments</ObjectName>

    <Frequency>300</Frequency>

    <HighThreshold>5</HighThreshold>

    <LowThreshold>0</LowThreshold>

  </Configuration>

</UnitMonitor>