Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> New Extent Allocation of Segments
I want a method of determining when a segment such as a data table is
about to acquire a new extent because all existing extents are almost
full. This method should ideally involve querying the dictionary or
executing an Oracle-provided package, and could for example identify the
remaining number of average-sized records that can be inserted into the
table before another extent will be required.
Received on Sun Jul 11 1999 - 23:40:46 CDT
![]() |
![]() |