Monitorando TEMP space

Query monitorar utilizaçao/tamanho área temporária:

select sum(u.blocks * blk.block_size) / 1024 / 1024 "TAMANHO UTILIZADO",

(hwm.max * blk.block_size) / 1024 / 1024 "TAMANHO TOTAL"

from v$sort_usage u,

(select block_size from dba_tablespaces where contents = 'TEMPORARY') blk,

(select segblk# + blocks max

from v$sort_usage

where segblk# = (select max(segblk#) from v$sort_usage)) hwm

group by hwm.max * blk.block_size / 1024 / 1024;