Oracle Session 현황 SQL
Oracle Session 현황 SQL 세션에 연결된 SQL SELECT a.username, a.sid, a.serial#, a.osuser, b.tablespace, b.blocks, 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.tablespace, b.blocks 테이블 스페이스 사용량 select se.username, sum(su.blocks*ts.block_size/1024/1024)mb_used from v$sort_usage su, v$se..
2020. 1. 31.