17,377
社区成员
发帖
与我相关
我的任务
分享
WITH df AS
(SELECT tablespace_name, round(SUM(bytes) / 1024 / 1024) totalspace
FROM dba_data_files
GROUP BY tablespace_name),
fs AS
(SELECT tablespace_name, round(SUM(bytes) / 1024 / 1024) freespace
FROM dba_free_space
GROUP BY tablespace_name)
SELECT df.tablespace_name "Tablespace", (df.totalspace - nvl(fs.freespace, 0)) "Used MB",
nvl(fs.freespace, 0) "Free MB", df.totalspace "Total MB",
round(100 * (nvl(fs.freespace, 0) / df.totalspace)) "Pct. Free"
FROM df
LEFT OUTER JOIN fs
ON (df.tablespace_name = fs.tablespace_name)
WHERE df.tablespace_name = 'USERS';