檢視資料庫表空間

檢視錶空間使用率：

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