Re: Determining when the NEXT EXTENT will happen

From: <xsun1913_at_my-dejanews.com>
Date: Thu, 29 Oct 1998 15:40:23 GMT
Message-ID: <71a297$6fh$1@nnrp1.dejanews.com>

In article <AjmZ1.2$MX6.23378_at_news20.bellglobal.com>, "Rob" <forstr_at_tdbank.ca> 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.
>
>

Hi, Rob,

You could get the information by using "sys.dbms_space" package. For more detail about the package, look at the Oracle manuals.

Xuening Sun

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Thu Oct 29 1998 - 09:40:23 CST