Oracle 19c 表空间使用情况查询语句 - 获取每个表空间的详细使用信息

要查询Oracle 19c数据库的表空间使用情况，您可以使用以下SQL语句：\n\nsql\nSELECT tablespace_name, \n ROUND(SUM(bytes) / 1024 / 1024, 2) AS "Total Size (MB)", \n ROUND(SUM(bytes - NVL(free_space, 0)) / 1024 / 1024, 2) AS "Used Size (MB)", \n ROUND(NVL(free_space, 0) / 1024 / 1024, 2) AS "Free Space (MB)", \n ROUND((SUM(bytes - NVL(free_space, 0)) / SUM(bytes)) * 100, 2) AS "Used %"\nFROM\n (SELECT tablespace_name, bytes, \n SUM(CASE WHEN autoextensible = 'YES' AND status = 'AVAILABLE' THEN maxbytes - bytes ELSE 0 END) AS free_space\n FROM dba_data_files\n GROUP BY tablespace_name, bytes\n UNION ALL\n SELECT tablespace_name, bytes, \n SUM(CASE WHEN autoextensible = 'YES' AND status = 'AVAILABLE' THEN maxbytes - bytes ELSE 0 END) AS free_space\n FROM dba_temp_files\n GROUP BY tablespace_name, bytes) \nGROUP BY tablespace_name;\n\n\n这个查询将返回每个表空间的名称，总大小（以MB为单位），已使用大小（以MB为单位），剩余空间（以MB为单位）和已使用百分比。