Oracle查询正在执行的sql

最新推荐文章于 2024-05-30 07:33:52 发布

So_etheral

最新推荐文章于 2024-05-30 07:33:52 发布

阅读量107

点赞数 3

文章标签： oracle sql 前端

本文链接：https://blog.csdn.net/So_langdechibang/article/details/139301089

版权

SELECT
	ses.inst_id || chr( 58 ) || ses.sid AS inst_sid,
	username,
	( SYSDATE - sql_exec_start ) day ( 1 ) TO second ( 0 ) AS sql_exec_start,
	ses.sql_id,
	substr( SQL.sql_text, 1, 40 ) sql_text,
	substr( CASE time_since_last_wait_micro WHEN 0 THEN ( CASE wait_class WHEN 'Idle' THEN 'IDLE: ' || event ELSE event END ) ELSE 'ON CPU' END, 1, 33 ) event,
	( CASE time_since_last_wait_micro WHEN 0 THEN wait_time_micro ELSE time_since_last_wait_micro END ) / 1000000 wait_sec 
FROM
	gv$session ses,
	gv$sqlstats SQL 
WHERE
	ses.inst_id || chr( 58 ) || ses.sid <> sys_context ( 'USERENV', 'INSTANCE' ) || chr( 58 ) || sys_context ( 'USERENV', 'SID' ) 
	AND username IS NOT NULL 
	AND status = 'ACTIVE' 
	AND ses.sql_id = SQL.sql_id ( + ) 
ORDER BY
	sql_exec_start,
	username,
	ses.sid,
	ses.sql_id;