Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Determining when the NEXT EXTENT will happen
Rob wrote:
>
> Is there someone who can tell me how to determine when an object (table or
> index) is going to throw an additional extent. ie.) how to find the
> highwatermark of the current extent, or something like that?
>
> Thanks,
> Rob.
Look at dbms_space.unused_space
--