IT農夫

Oracle 以sqlplus 登入查看每一個tablespace Size 大小指令

SELECT t.tablespace_name, round(SUM(bytes / (1024 * 1024)), 0) ts_size
FROM dba_tablespaces t, dba_data_files d
WHERE t.tablespace_name = d.tablespace_name
GROUP BY t.tablespace_name;

TABLESPACE_NAME                   TS_SIZE
------------------------------                    ----------
UNDOTBS1                                   100
SYSAUX                                        550
USERS                                              5
SYSTEM                                        690
EXAMPLE                                     100