How To Fix DB11022 - Nombre de segments avec trop peu d'extents pouvant être affectés

SAP Error Message - Details

• Message type: E = Error

• Message class: DB11 - Oracle Monitor: messages

• Message number: 022

• Message text: Nombre de segments avec trop peu d'extents pouvant être affectés

Quelle est la cause de ce problème?

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.

Comment corriger cette erreur?

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.

Le système émet un message d'erreur et ne vous permettra pas de poursuivre cette transaction tant que l'erreur n'est pas résolue.

Extrait du message d'erreur du système SAP. Copyright SAP SE.