--查询后台进程---
SELECT * FROM (
SELECT
N.SID SID_,
N.USERNAME 实例名,
N.LOGON_TIME 登录打开页面时间,
N.PREV_EXEC_START 当前语句开始执行时间,
N.SQL_ID 当前SQLID,
N.MACHINE 机器名,
L.SQL_TEXT 当前SQL内容,
N.EVENT 当前等待事件,
L.SQL_FULLTEXT 当前SQL完整内容,
N.*,
ROW_NUMBER() OVER(PARTITION BY N.SID ORDER BY N.LOGON_TIME,N.PREV_EXEC_START) RN
FROM GV$SESSION N
JOIN GV$SQL L
ON L.SQL_ID = N.SQL_ID
WHERE N.STATUS = 'ACTIVE'
AND N.SCHEMANAME <> 'SYS'
ORDER BY N.LOGON_TIME,N.PREV_EXEC_START
) T WHERE T.RN = 1
oracle查看数据库进程
于 2018-07-13 10:56:53 首次发布