SQL Tracker by SID sqltrackerbysid.sql

col SAMPLE_TIME format a25
col program format a20
col SQL_EXEC_START format a25
col machine format a15
set lines 140 pages 200
alter session set nls_date_format=’DD-MON-RRRR:HH24:MI:SS’;

select SAMPLE_TIME, SESSION_ID, SESSION_SERIAL#, USER_ID, sql_ID, Machine, program, SQL_EXEC_START
from gv$active_session_history
where session_id = &v_session_id
and sample_time > sysdate – 1/24
order by sample_time
/