Oracle 查看表空间是否自动扩展

SELECT
	tablespace_name,
	auto_ext
FROM
	(
	SELECT
		f.tablespace_name,
	CASE
			WHEN sum(decode(f.autoextensible, 'YES', 1, 'NO', 0)) = 0 THEN 'NO'
			ELSE 'YES'
		END AS auto_ext
	FROM
		dba_data_files f
	GROUP BY
		tablespace_name)
ORDER BY
	2