查看表占用多少M

SQL> SELECT d.status "Status",d.tablespace_name "Name", d.contents "Type",
  2                           d.extent_management "Extent Management", NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
  3         NVL(a.bytes - NVL(f.bytes, 0), 0) / 1024 / 1024 "Used (M)",
  4         NVL((a.bytes - NVL(f.bytes, 0)) / a.bytes * 100, 0) "Used %"
  5    FROM sys.dba_tablespaces d,(select tablespace_name, sum(bytes) bytes
  6                           from dba_data_files group by tablespace_name) a,
  7                          (select tablespace_name, sum(bytes) bytes from dba_free_space
  8                          group by tablespace_name) f  WHERE d.tablespace_name = a.tablespace_name(+) AND
  9         d.tablespace_name = f.tablespace_name(+) AND  NOT
 10                        (d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY')
 11  UNION ALL  SELECT d.status "Status", d.tablespace_name "Name", d.contents "Type",
 12                             d.extent_management "Extent Management",
 13                             NVL(a.bytes / 1024 / 1024, 0) "Size (M)",
 14                             NVL(t.bytes, 0) / 1024 / 1024  "Used (M)",
 15                             NVL(t.bytes / a.bytes * 100, 0) "Used %"
 16    FROM sys.dba_tablespaces d,(select tablespace_name, sum(bytes) bytes
 17            from dba_temp_files group by tablespace_name) a,
 18                           (select tablespace_name, sum(bytes_cached) bytes
 19                           from v$temp_extent_pool group by tablespace_name) t
 20  WHERE d.tablespace_name = a.tablespace_name(+) AND
 21                            d.tablespace_name = t.tablespace_name(+) AND
 22                            d.extent_management like 'LOCAL' AND d.contents like 'TEMPORARY';

Status    Name                           Type      Extent Management   Size (M)   Used (M)     Used %
--------- ------------------------------ --------- ----------------- ---------- ---------- ----------
ONLINE    UNDOTBS1                       UNDO      LOCAL                    200    15.9375    7.96875
ONLINE    SYSAUX                         PERMANENT LOCAL                    280    265.375 94.7767857
ONLINE    RSFIS                          PERMANENT LOCAL              1132.5625       1132 99.9503338
ONLINE    CSFIS                          PERMANENT LOCAL                    850   829.5625 97.5955882
ONLINE    USERS                          PERMANENT LOCAL                      5     3.6875      73.75
ONLINE    SYSTEM                         PERMANENT LOCAL                    500    491.875     98.375
ONLINE    EXAMPLE                        PERMANENT LOCAL                    100    77.6875    77.6875
ONLINE    SSFIS                          PERMANENT LOCAL               630.8125   630.6875 99.9801842
ONLINE    INDX                           PERMANENT LOCAL                  83.75    82.8125 98.8805970
ONLINE    HDX_TEST_TABSPACE              PERMANENT LOCAL                     50      6.125      12.25
ONLINE    PERFSTAT                       PERMANENT LOCAL                     50     0.0625      0.125
ONLINE    TEMP                           TEMPORARY LOCAL                     20         18         90

12 rows selected

SQL>