select session_id, session_type, sql_opname, sql_id from gv$active_session_history
where sample_time between to_date('20211122 17:00:00', 'YYYYMMDD HH24:MI:SS') and to_date('20211122 17:01:00', 'YYYYMMDD HH24:MI:SS');
select sql_id, sql_text from v$sql where sql_id='&sql_id';
select distinct sql_opname from v$active_session_histroy;