Re: Calculating when a segment will need a new extent

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/10/18
Message-ID: <629gq1$ls4@bgtnsc02.worldnet.att.net>#1/1

Use the DBMS_SPACE package provided by ORACLE. It contains two procedures: UNUSED_SPACE and FREE_BLOCKS, that can provide the information you need.

You can find details about the DBMS_SPACE package and its contents in the script $ORACLE_HOME/rdbms/admin/dbmsutil.sql.

Hope this helps.

Michael Serbanescu

---

Claus Jensen wrote:
>
> Hi,
>
> Is there a good (as in relatively accurate) way of finding out how much
> room is left in the latest allocated extent for a table or index
> segment? Or put another way is there a way of figuring out which
> segments are close to needing an extra extent?
>
> This info could be used together with info on #extents, extent sizes and
> free space to see where any space problems may occur soon.
>
> Thanks in advance for any help!
>
> Please email any answer to me at cje_at_stibo.com since I don't read news
> regularly!
>
> Claus Jensen.
Received on Sat Oct 18 1997 - 00:00:00 CDT