Re: Getting current space of a table ...

From: John Seitz <seitz_at_pobox.com>
Date: Wed, 24 Mar 1999 02:39:17 GMT
Message-ID: <36F85064.D60DFFFC@pobox.com>

there is a Oracle tool called Toad which gives the type of stats you are looking for. You can find it at
www.toadsoft.com

John

Thomas Klinger wrote:

> Hi there!
>
> Sounds like an easy question.
> I want to get the used space of a table in percentage digits.
>
> I.e. I have a table which takes at its init size ~174MB. And it is
> still at extent 0. Max_Extents=6.
> But how much is the table really filled up? How to do this?
>
> USED_SPACE_OF_CURRENT_TAKEN_BLOCKS=?
> FREE_SPACE_IN_THIS_EXTENT=100%-USED_SPACE_OF_CURRENT_TAKEN_BLOCKS
>
> Is it also possible to get the value of available rows which can be
> inserted into FREE_SPACE_IN_THIS_EXTENT and how much rows can be
> inserted at the max?
>
> Can anyone help me?
>
> Kind regards
>
> Thomas Klinger
> Systemspecialist
> =======================================
> t.klinger_at_mobilkom.at
> http://www.mobilkom.at
> =======================================
Received on Tue Mar 23 1999 - 20:39:17 CST