? ? FROM dba_temp_files
? ? GROUP BY tablespace_name order by tablespace_name) a,
? (SELECT? tablespace_name, SUM(bytes_used? ) bytes
? ? FROM v\$temp_extent_pool
? ? GROUP BY tablespace_name) t,
? (SELECT? tablespace_name, MAX(bytes_cached) large
? ? FROM v\$temp_extent_pool
? ? GROUP BY tablespace_name order by tablespace_name) l
?WHERE d.tablespace_name = a.tablespace_name(+)
? AND d.tablespace_name = t.tablespace_name(+)
? AND d.extent_management LIKE 'LOCAL'
? AND d.contents LIKE 'TEMPORARY'
? ORDER by 1
?/
?prompt
?exit
?EOF
运行结果相对比较简单，也很清晰。
