--

-- List History of an Active Session

--

SET pause ON

SET pause 'Press Return to Continue'

SET pagesize 60

SET linesize 300

SET verify OFF

SELECT sample_time,

       sid,

       machine

FROM   dba_hist_active_sess_history

WHERE  sample_time 

BETWEEN 

To_date('2024-02-20 03:00:00','yyyy-mm-dd hh24:mi:ss') 

AND

To_date('2024-02-20 04:50:00', 'yyyy-mm-dd hh24:mi:ss')

ORDER  BY 

sample_time