【TUNE_ORACLE】查看真实的历史执行计划SQL参考

实验环境

搭建平台：VMware Workstation

OS：RHEL 6.10

Grid&DB：Oracle 11.2.0.4

SQL参考 select sql_id, plan_hash_value,operation,timestamp   from dba_hist_sql_plan   where sql_id='4h46z95mc36sa'   --需要查询的对应的SQL ID  order by timestamp desc; select * from v$sql_plan   where sql_id='4h46z95mc36sa'   order by timestamp desc;