Home
  •  

Segments: Most allocated extents in any segment

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

Number of most allocated extents in any segment

Knowledge Base article:

Summary

Most allocated extents in any segment

Configuration

N/A

Causes

The number of allocated extents any segment has exceeded the configured threshold. Having few allocated extents per segment was significant when Oracle’s maximum MAX_EXTENTS value was relatively low based on Oracle’s block size. MAX_EXTENTS can now have a value of "unlimited," eliminating this concern. Having many extents should not cause problems, assuming none of the segments in this tablespace have PCTINCREASE set to non-zero and that the NEXT storage parameter settings for all segments in this tablespace are either all the same or multiples of one another

Resolutions

If you prefer segments with fewer allocated extents, you can use SAPDBA to reorganize the object

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: Most allocated extents in any segment
{0} : {1} has a value {2}
RunAsDefault

Source Code:

<UnitMonitor ID="ozsoft.sap.Monitor.Oracle.Segments.MostAllocatedExtents" 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.MostAllocatedExtents.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>Most allocated extents in any segment</CounterName>

    <ObjectName>Segments</ObjectName>

    <Frequency>300</Frequency>

    <HighThreshold>800</HighThreshold>

    <LowThreshold>400</LowThreshold>

  </Configuration>

</UnitMonitor>