Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> New Extent Allocation of Segments

New Extent Allocation of Segments

From: Jon Blake <jblake_at_swin.edu.au>
Date: Mon, 12 Jul 1999 14:40:46 +1000
Message-ID: <378971CE.D61893C3@swin.edu.au>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US