select * from v$latch order by sleeps desc;
SELECT a.sid,
c.username,
b.name,
a.VALUE,
ROUND ( (SYSDATE - c.logon_time) * 24) hours_connected
FROM v$sesstat a, v$statname b, v$session c
WHERE c.sid = a.sid
AND a.statistic# = b.statistic#
AND a.VALUE > 0
AND b.name = 'parse count (hard)'
ORDER BY a.VALUE desc;
select sql_address,sql_hash_value from v$session where sid=62
select sql_text from v$sqltext where address='1217714C' and hash_value=3151937050 order by piece;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/611609/viewspace-541398/ ，如需转载，请注明出处，否则将追究法律责任。
