Identify a job history through SID and Serial Number
CharlovJul 5 2010 — edited Jul 5 2010Hey,
I ran the following select statement on the DB
SELECT
a.USERNAME, a.serial#, a.sid, a.STATUS, b.sql_text, b.SQL_ID
FROM V$SESSION a INNER JOIN V$SQLAREA b
ON a.SQL_ADDRESS= b.ADDRESS;
and there's one select statement with Serial# and SID 52596,141 that has been running for a while now.
Any idea how I can tell how long it has been running?
Oracle Rac 10G running on Linux