Re: New Extent Allocation of Segments

  In order to get the exact number of blocks that contain data for a
particular table you need to issue the following query:

   select count(distinct(substr(rowid,1,8))) from <table name>;

  This will bring back the number of distinct blocks for the table.

Jon Blake wrote:
>
> 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 Mon Jul 12 1999 - 02:30:36 CDT