本文提供了一个SQL查询示例，用于获取指定Oracle表的相关信息，包括表的所有者、表名、行数、大小（以MB为单位）、空闲块数量及最后分析时间。此查询对于了解表的具体情况非常有用。
select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';
[@more@]select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';
Here: AAA is the value of db_block_size ;
XXX is the table name you want to check
[@more@]select owner,table_name,
NUM_ROWS,
BLOCKS*AAA/1024/1024 "Size M",
EMPTY_BLOCKS,
LAST_ANALYZED
from dba_tables
where table_name='XXX';
Here: AAA is the value of db_block_size ;
XXX is the table name you want to check
来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/1724534/viewspace-884773/，如需转载，请注明出处，否则将追究法律责任。
转载于:http://blog.itpub.net/1724534/viewspace-884773/
扫一扫
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
