查询表咋用大小

  SELECTSUM(bytes)/1024/1024/1024 AS GB
FROMdba_segments
WHEREsegment_type = 'TABLE';

查询所有文件占用大小

SELECTROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS "Size in GB"
FROMdba_data_files;

查询每个表空间大小

SELECTtablespace_name,ROUND(SUM(bytes) / 1024 / 1024 / 1024, 2) AS "Size in GB"
FROMdba_data_files
GROUP BYtablespace_name;

参考文章