Oracle查锁表、长等待相关sql
一、查询sid,sql_id
SELECT t.sql_id
,t.*
FROM gv$session t
WHERE username = 'TZQ'
AND status = 'ACTIVE'
AND osuser = 'tzq\tttzz';
二、查询执行的慢SQL详情
SELECT * FROM gv$sqlarea WHERE sql_id = 'duqj71r1bxr1s';
SELECT * FROM gv$sql WHERE sql_id = 'duqj71r1bxr1s';
三、查询执行剩余时间
SELECT *
FROM gv$session_longops
WHERE sid = 80
AND sofar <> totalwork;