Getting current space of a table ...

From: Thomas Klinger <t.klinger_at_mobilkom.at>
Date: Tue, 23 Mar 1999 15:37:02 GMT
Message-ID: <36f7b376.26787321@194.48.138.240>

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 - 09:37:02 CST