finding an explain plan by its hash value

Question

so when I'm looking at dba_hist_sqlstat data, I see the plan_hash_value of the chosen explain plan. How can I see the explain plan behind this hash value? I haven't been lucky with v$sql_plan or plan_table or dbms_xplan.display .

Answer 1

You'd want to join to dba_hist_sql_plan using the sql_id and plan_hash_value.