查看表空间使用率：

select tablespace_name,sum(bytes)/1024/1024 sum_mb from dba_data_files group by tablespace_name;

SQL> select tablespace_name,sum(bytes)/1024/1024 sum_mb from dba_data_files group by tablespace_name;

TABLESPACE_NAME SUM_MB

------------------------------ ----------

SYSAUX 500

UNDOTBS1 300

DBS_OSS_KPI_INDEX 4608

USERS 36.25

DBS_OSS_DEFAULT 32524

SYSTEM 500

DBS_OSS_SAT_INDEX 512

DBS_OSS_SAT_DAT 7168

DBS_OSS_KPI_DAT 16384

9 rows selected.

查看剩余表空间：

select tablespace_name,sum(bytes)/1024/1024 free_mb from dba_free_space group by tablespace_name;

SQL> select tablespace_name,sum(bytes)/1024/1024 free_mb from dba_free_space group by tablespace_name;

TABLESPACE_NAME FREE_MB

------------------------------ ----------

UNDOTBS1 279.3125

SYSAUX 17.4375

DBS_OSS_KPI_INDEX 509.375

USERS 35.6875

DBS_OSS_DEFAULT 23261.6875

SYSTEM 1.5625

DBS_OSS_SAT_INDEX 486.875

DBS_OSS_SAT_DAT 4639.0625

ITPub博客

查看数据库表空间