DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: How to find the information about free space of each table

  1. #1
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    I want to know how much free space in the table segment and there are distribution . Is it possible ?

  2. #2
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    Analyze you tables and then

    select table_name, empty_blocks from user_tables;

    It'll return the table's name and free blocks. You can calculate free space via empty_blocks * block_size.

    Cheers
    OCP 8i, 9i DBA
    Brisbane Australia

  3. #3
    Join Date
    Aug 2000
    Location
    Shanghai
    Posts
    433
    It's a good idea , It's even better if you can provide the way to have the free chunk (distribution in the extend)

  4. #4
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    use dbms_space

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