Please use the query below to identify and provide the SID and Serial#.
col first_seen for a30
col last_seen for a30
SELECT MIN(sample_time) AS first_seen,
MAX(sample_time) AS last_seen
FROM (
SELECT sample_time
FROM v$active_session_history
WHERE session_id = &sid
AND session_serial# = &serial
UNION ALL
SELECT sample_time
FROM dba_hist_active_sess_history
WHERE session_id = &sid
AND session_serial# = &serial
)
WHERE sample_time BETWEEN SYSDATE-1 AND SYSDATE;
Recent Posts