DBA_TABLES之BLOCKS AND EMPTY_BLOCKS

来源：互联网发布：法语官方国家知乎编辑：程序博客网时间：2024/05/21 06:59

SQL> select owner,table_name,blocks,EMPTY_BLOCKS from dba_tables where EMPTY_BLOCKS <>0;OWNER                          TABLE_NAME                         BLOCKS EMPTY_BLOCKS------------------------------ ------------------------------ ---------- ------------SCOTT                          TEST_1                             245550         1106用show_space查看Total Blocks  ..........................246656Total Bytes   ..........................2020605952Total MBytes  ..........................1927Unused Blocks ..........................1106Unused Bytes  ..........................9060352Unused KBytes ..........................8848Used Blocks   ..........................245550Used Bytes    ..........................2011545600Used KBytes   ..........................1964400Last Used Ext FileId....................4Last Used Ext BlockId...................376704Last Used Block.........................7086BLOCKS*NUMBERNumber of used data blocks in the tableEMPTY_BLOCKS*NUMBERNumber of empty (never used) data blocks in the tableBLOCKS 列代表该表中曾经使用过得数据库块的数目，即水线。EMPTY_BLOCKS 代表分配给该表，但是在水线以上的数据库块，即从来没有使用的数据块

0 0