--查询指定SESSION正在执行的SQL SELECT sql_text FROM v$sqltext a WHERE (a.hash_value, a.address) IN (SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value), DECODE(sql_hash_value, 0, prev_sql_addr, sql_address) FROM v$session b WHERE b.SID = &sid) ORDER BY piece ASC;
--查找正在执行的JOB的会话和执行的存储过程信息 SELECT a.job, a.SID, b.WHAT, b.interval FROM dba_jobs_running a, dba_jobs b WHERE a.JOB = b.JOB;
SELECT sql_text
FROM v$sqltext a
WHERE (a.hash_value, a.address) IN
(SELECT DECODE(sql_hash_value, 0, prev_hash_value, sql_hash_value),
DECODE(sql_hash_value, 0, prev_sql_addr, sql_address)
FROM v$session b
WHERE b.SID = &sid)
ORDER BY piece ASC;
SELECT a.job, a.SID, b.WHAT, b.interval
FROM dba_jobs_running a, dba_jobs b
WHERE a.JOB = b.JOB;