Home
  •  

Segments: Fewest allocatable extents for a segment

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

Fewest allocatable extents for a segment

Knowledge Base article:

Summary

Fewest allocatable extents for a segment

Configuration

N/A

Causes

The smallest number of extents left for any segment has fallen below the configured threshold. 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: Fewest allocatable extents for a segment
{0} : {1} has a value {2}
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.Segments.FewestAllocatableExtents" 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.FewestAllocatableExtents.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>Fewest allocatable extents for a segment</CounterName>

    <ObjectName>Segments</ObjectName>

    <Frequency>300</Frequency>

    <HighThreshold>3000</HighThreshold>

    <LowThreshold>2000</LowThreshold>

  </Configuration>

</UnitMonitor>