Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Blocks in DBA_TABLES and DBA_SEGMENTS
What is the difference between the BLOCKS column in dba_tables and
dba_segments?
The two numbers in my database are very different. Or say
dba_segments.blocks - dba_table.blocks = ?
What is the mean of empty_blocks in dba_tables? Does it include the blocks above HWM? Is it the block available for data insert?
Thanks a lot. Received on Thu May 02 2002 - 16:48:24 CDT