判断Oracle表空间满的查询sql

判断Oracle表空间满的查询sql：

SELECT
	A .tablespace_name "表空间名",
	A .bytes / 1024 / 1024 "表空间大小(M)",
	(A .bytes - b.bytes) / 1024 / 1024 "已使用空间(M)",
	b.bytes / 1024 / 1024 "空闲空间(M)",
	ROUND (
		((A .bytes - b.bytes) / A .bytes) * 100,
		2
	) "使用比"
FROM
	(
		SELECT
			tablespace_name,
			SUM (bytes) bytes
		FROM
			dba_data_files
		GROUP BY
			tablespace_name
	) A,
	(
		SELECT
			tablespace_name,
			SUM (bytes) bytes,
			MAX (bytes) largest
		FROM
			dba_free_space
		GROUP BY
			tablespace_name
	) b
WHERE
	A .tablespace_name = b.tablespace_name
ORDER BY
	((A .bytes - b.bytes) / A .bytes) DESC