need to know REAL space used
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 ?...
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.
On Asktom or in his books there is a SHOW_SPACE proc. that you can use to crosscheck - works for me !!
Click Here to Expand Forum to Full Width