--对正在执行的会话中的SQL，查看执行SQL耗时
select datediff(s, last_recv_time, sysdate) exectime,
dbms_lob.SUBSTR(sf_get_session_sql(sess_id)) sql_txt,
CUR_SQLSTR,
sess_id,
state,
user_name,
clnt_ip,
clnt_ver
from v$sessions
where state = 'ACTIVE'
order by exectime desc