need to know REAL space used

Hello all..

I know there are bunch of SQL scripts that will give the space allocated, space used, percentage free and things like that.

but iam looking for a script that will tell me how of space is used inside the space used column ?..

because my current "used space" shows 2 GB but i know that it is not 2 GB anymore sicen we did a huge purge of data and the EXP file shows 520 mb. So how do we know what the exact size of that database used space is ?...


thnaks
Ron

Analyze your tables, take the avg row size, and multiply by the number of rows. That's probably the closest you will get.

Indexes, you'd be best to rebuild them.

Good Luck!
Jodie

On Asktom or in his books there is a SHOW_SPACE proc. that you can use to crosscheck - works for me !!
:cool: