col program for a35
col module for a40
col event for a30
set pages 300 lines 220
SELECT SESSION_ID, program, module, machine, event,sql_id ,TIME_WAITED,SESSION_STATE, sample_time
FROM dba_hist_active_sess_history
WHERE sample_time between to_date('24/01/2022 12:58:00','dd/mm/yyyy hh24:mi:ss')
and to_date('24/01/2022 16:13:00','dd/mm/yyyy hh24:mi:ss')
and module not in ('Oracle Enterprise Manager.Metric Engine')
order by sample_time;