How To Fix DB11022 - Cantidad de segmentos con demasiado pocos extents asignables

SAP Error Message - Details

• Message type: E = Error

• Message class: DB11 - Oracle Monitor: messages

• Message number: 022

• Message text: Cantidad de segmentos con demasiado pocos extents asignables

¿Qué causa este problema?

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.

¿Cómo arreglar este error?

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.

El sistema emite un mensaje de error y no le permitirá continuar con esta transacción hasta que se resuelva el error.

Extracto de mensaje de error del sistema SAP. Copyright SAP SE.