오라클
Temp TableSpace 사용량 확인
bedbmsguru
2020. 4. 10. 12:05
SELECT a.username
, a.sid
, a.serial#
, a.osuser
, b.tablespace
, (b.blocks * (select block_size from v$buffer_pool) /1024/1024) USED_SIZE_MB
, c.sql_text
FROM v$session a, v$tempseg_usage b, v$sqlarea c
WHERE a.saddr = b.session_addr
AND c.address= a.sql_address
AND c.hash_value = a.sql_hash_value
ORDER BY b.blocks DESC
--출처