SELECT
(select max(name) from v$tablespace where id=group_id) AS “表空间名称”,
PATH “数据文件”,
TO_CHAR(TOTAL_SIZEPAGE/1024/1024) AS “总大小(M)”,
TO_CHAR(FREE_SIZEPAGE/1024/1024)AS “空闲大小(M)”,
(TO_CHAR(100-FREE_SIZE*100/TOTAL_SIZE))||‘%’ AS “使用率(%)”,
CASE AUTO_EXTEND WHEN ‘0’ THEN ‘未开启’ WHEN ‘1’ THEN ‘开启’ END AS “自动扩展”,
MAX_SIZE AS “最大可扩展大小(M)”
FROM V$DATAFILE order by 1;
SELECT
(select max(name) from v$tablespace where id=group_id) AS “表空间名称”,
PATH “数据文件”,
TO_CHAR(TOTAL_SIZEPAGE/1024/1024) AS “总大小(M)”,
TO_CHAR(FREE_SIZEPAGE/1024/1024)AS “空闲大小(M)”,
(TO_CHAR(100-FREE_SIZE*100/TOTAL_SIZE))||‘%’ AS “使用率(%)”,
CASE AUTO_EXTEND WHEN ‘0’ THEN ‘未开启’ WHEN ‘1’ THEN ‘开启’ END AS “自动扩展”,
MAX_SIZE AS “最大可扩展大小(M)”
FROM V$DATAFILE order by 1;