In the EXTENT management of an Oracle object category, you will find statements to manage allocation behavior by modifying the number of EXTENTS for an object. It is also possible to modify the size of each individual EXTENT and the percentage of EXTENT increments.
An EXTENT is a logical unit of storage allocation in the database storage space consisting of a number of contiguous data blocks.
Each segment is composed of one or more extensions.
When the existing space in a segment is completely used up, Oracle assigns a new extension up to the maximum extension set. Therefore, to keep the service running correctly, action must be taken to prevent objects from reaching the maximum EXTENT.
It is possible to modify some parameters to better manage storage space allocation for Oracle database objects.
Let’s continue with the article EXTENT management of an Oracle object.
In the Object EXTENT Management category, you will find statements to manage allocation behavior by modifying the number of EXTENTS for an object. It is also possible to modify the size of each individual EXTENT and the percentage of EXTENT increments.
With the article Query EXTENT TABLE Oracle, we provide a dynamic query to manage the extents of Oracle objects. Additionally, if an object does not have the possibility to extend, we will verify if increasing the number of extents is necessary. The smallest unit of measurement within the database is Read more…
With the article Query Oracle objects with few EXTENTS, we provide a query to display information about objects with less than 100 EXTENTS. As explained in the article Query EXTENT TABLE Oracle,the EXTENTS of a table have a well-defined number. Once this limit is reached, the following error message is Read more…
With the article Query EXTENT Oracle number and size, we have the opportunity to view many useful pieces of information for managing the extents of a table. The retrieved information includes the table size, extent size, the current number of extents, and the maximum number that extents can reach. As Read more…