By analyzing the awr report ,you found that there was some issue with a particular sql_id, and you want to get the explain plans associated with that sql_id. We can get the explains using dbms_xplan.display_awr

Suppose the sql_id is : 00tr6c6tngp4x

 

 

We can observe, for that particular sql_id, 3 explain plans were associated. This will help us in finding better explain plans running in the past.