need to know REAL space used
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: need to know REAL space used

  1. #1
    Join Date
    Oct 2002
    Posts
    284

    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

  2. #2
    Join Date
    Sep 2001
    Location
    Ohio
    Posts
    334
    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

  3. #3
    Join Date
    Jul 2003
    Posts
    323
    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
  •  


Click Here to Expand Forum to Full Width