[oracle] 查询历史会话、历史执行计划

1.查询历史连接信息 select * from dba_hist_active_sess_history a where a.SAMPLE_TIME BETWEEN TO_DATE('2020-10-04 12:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2020-10-04 13:00:00', 'YYYY-MM-DD HH24:MI:SS') select * from v$active_session_history D WHERE d.SAMPLE_TIME BETWEEN TO_DATE('2020-10-04 12:00:00', 'YYYY-MM-DD HH24:MI:SS') AND TO_DATE('2020-10-04 13:00:00', 'YYYY-MM-DD HH24:MI:SS')   2.查询历史sql信息 select * from v$sqlarea where sql_text like '%%'; 3.查询历史执行计划 select * from v$sql_plan; 如果缓存内查询不到，可以查询DBA_HIST_SQL_PLAN表 select * from DBA_HIST_SQL_PLAN;