监控undo空间和临时段的使用情况
--1.监控undo空间情况 select tablespace_name,round(sum(bytes)/(1024*1024),2) free_space from dba_free_space where tablespace_name='UNDOTBS1' group by tablespace_name; TABLESPACE_NAME FREE_SPACE ------------------------------ ---------- UNDOTBS1 167.44 --2.监控临时段的使用情况 select sum(nvl(blocks,0))*8/1024 Msize from v$sort_usage;