-
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 !!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|