The BLOCKS and EMPTY_BLOCKS values in DBA_TABLES are only updated when you analyze your table. BLOCKS indicate the number of used data blocks in the table (below the HWM), while EMPTY_BLOCKS shows the number of empty (never used) data blocks in the table (above the HWM).
If you total BLOCKS + EMPTY_BLOCKS + [[header blocks]], you should get about the same values as is listed in DBA_SEGMENTS.
What's the difference between BLOCKS columns in DBA_TABLES & DBA_SEGEMENTS?
最新推荐文章于 2021-04-07 11:35:11 发布