Temple of Oracle: last active queries in oracle

Showing posts with label last active queries in oracle. Show all posts

Friday, November 13, 2009

SELECT OSUSER,
SERIAL#,
SQL_TEXT
FROM V$SESSION, V$SQL
WHERE V$SESSION.SQL_ADDRESS = V$SQL.ADDRESS
AND V$SESSION.STATUS = 'ACTIVE';