--Query temp ts use
SELECT b.tablespace,
ROUND(((b.blocks * p.value) / 1024 / 1024), 2) || 'M' AS temp_size,
a.sid || ',' || a.serial# AS sid_serial,
NVL(a.username, '(oracle)') AS username,
a.program
FROM v$session a, v$sort_usage b, v$parameter p
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
ORDER BY b.tablespace, b.blocks;
SELECT b.tablespace,
ROUND(((b.blocks * p.value) / 1024 / 1024), 2) || 'M' AS temp_size,
a.sid || ',' || a.serial# AS sid_serial,
NVL(a.username, '(oracle)') AS username,
a.program
FROM v$session a, v$sort_usage b, v$parameter p
WHERE p.name = 'db_block_size'
AND a.saddr = b.session_addr
ORDER BY b.tablespace, b.blocks;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/26390465/viewspace-1853395/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
管好统计信息，开启SQL优化之门
下一篇：
Query undo ts use
请登录后发表评论
登录
全部评论
