Running 9.2.0.5 in OEM. If you look at a table on the statistics tab it
lists out 'Empty Blocks:' and 'No. of Freelist Blks:'. What is the
difference in these two values? I've got a table with 9795 empty blocks
but only 5 freelist blocks.
Are the empty blocks ones that were grabbed when the table extended but
have never had data in them, and the freelist blocks have data but are
still available for inserts?
Where can I find these values outside of OEM? dba_tables?
Thanks for any help.
Received on Thu Mar 23 2006 - 08:18:14 CST
