实验环境

搭建平台：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;