查ORACLE主库表空间用了多少

CREATE OR REPLACE FORCE VIEW V_MAX_TABLESPACE
(
   MAX_USED_RATE,
   TABLESPACE_NAME
)
AS
   SELECT ROUND (used_percent, 0) AS max_used_rate, tablespace_name
     FROM (SELECT used_percent, tablespace_name
             FROM dba_tablespace_usage_metrics -- where TABLESPACE_NAME in ('AA_DATA','AA_INDEX','SYSTEM','SYSAUX','USERS','UNDOTBS1','TEMP','TEMP_AA' )
           UNION ALL
           SELECT 20 AS used_percent, 'dg_test' AS tablespace_name FROM DUAL
           ORDER BY used_percent DESC) t
    WHERE ROWNUM <= 1;