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

Thread: space

  1. #1
    Join Date
    Jul 2000
    Hello, all:

    What is the meaning of columns avg_space and empty_block in table dba_tables? I used command to analyze the tables and select from dba_tables to get table statistics. But something feel strange to me. I have table A and B:

    avg_row_len num_rows avg_space empty_block
    A 60 650 1541 109
    B 82 16680 551 95

    It suppose that B consumes more space.

    Could you help me explain it? Thanks.

  2. #2
    Join Date
    Feb 2000
    phoenix, AZ,USA

    The avg_space - is the average number of free bytes in each

    empty_block - is the number of data blocks above the
    highwater mark.
    (Total blocks allocated=Blocks + emptyblocks +1 )

    Blocks - represents the highwater mark.

    Hope this helps to some extent.

  3. #3
    Join Date
    Feb 2000
    Washington DC
    EMPTY_BLOCKS : The number of empty(never used) data blocks in the table.

    AVG_SPACE : The average available freespace in the table

    Now try imply thses definitions to the tables A,B here. B consumes more space. It is.

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.