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