How To Fix DB11022 - Anzahl der Segmente mit zu wenig zuordenbaren Extents

SAP Error Message - Details

• Message type: E = Error

• Message class: DB11 - Oracle Monitor: messages

• Message number: 022

• Message text: Anzahl der Segmente mit zu wenig zuordenbaren Extents

Was verursacht dieses Problem?

This is the number of segments that can allocate fewer extents than
specified by the preset threshold. Either the storage parameter NEXT is
set too high or there is too little remaining space in the tablespace.
The preset threshold that determines when a segment has too few
allocatable extents is set in the monitoring attribute "Fewest
allocatable extents for a segment" which displays the smallest number
of allocatable extents for any segment whose PCTINCREASE is set to 0.
Since read-only segments do not allocate space, the threshold for this
attribute should be set to at least the number of read-only segments to
ensure that critical alerts will be generated only when read/write
segments have too few allocatable extents.

Wie behebe ich diesen Fehler?

Start the analysis tool by double-clicking on the current node in the
monitoring tree. This will display a list of all segments that have
fewer allocatable extents than specified by the threshold. Also
displayed are the number of remaining allocatable extents for each
segment, its tablespace, and its storage parameter NEXT.
To eliminate this problem, either:
Increase the tablepace size by adding another datafile, or
Decrease the size of the segment's NEXT parameter.

Das System gibt eine Fehlermeldung aus und erlaubt Ihnen nicht, mit dieser Transaktion fortzufahren, bis der Fehler behoben ist.

Fehlermeldungsextrakt aus SAP-System. Copyright SAP SE