-
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.
-
The avg_space - is the average number of free bytes in each
block.
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.
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|