How to get explain plan for plan hash value and sql_id in Oracle

How to get explain plan for plan hash value and SQL_ID in Oracle

Get Explain plan using sql_id

SELECT sql_id, child_number FROM v$sql WHERE sql_id LIKE '&sql_id';

SELECT sql_id, child_number FROM v$sql WHERE sql_text LIKE '&sql_text';

SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('sql_id',child_number));

Get Explain plan using plan_hash_value

SELECT DISTINCT sql_id, plan_hash_value FROM dba_hist_sqlstat WHERE sql_id = '&sql_id';

SELECT sql_id, child_number FROM v$sql WHERE sql_text LIKE '&sql_text';

SQL_ID               PLAN_HASH_VALUE

-------------------- ---------------

bz44ybqzjkhjd             2457659919

bz44ybqzjkhjd             3564465621

SELECT * FROM table(DBMS_XPLAN.DISPLAY_AWR('sql_id','plan_hash_value'));