SELECT b.tablespace,
b.segfile#,
b.segblk#,
ROUND ( ( (b.blocks * p.VALUE) / 1024 / 1024), 2) size_mb,
a.sid,
a.serial#,
a.username,
a.osuser,
a.program,
a.status,
b.sql_id
FROM v$session a,
v$sort_usage b,
v$process c,
v$parameter p
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
AND a.paddr = c.addr
ORDER BY size_mb DESC;
Hiç yorum yok:
Yorum Gönder