查看Oracle数据库表的大小

查看某表的大小(按照提示输入要查看的表名)

SQL>select sum(bytes)/(1024*1024) as "size(M)" from user_segments where segment_name=upper('&table_name');

查看表空间物理文件的名称及大小:

SQL>select tablespace_name,file_id,file_name,round(bytes/(1024*1024),0) total_space from dba_data_files order by tablespace_name;