See execution plan for sql_id from Cursor Cache
SET LINESIZE 150
SET PAGESIZE 2000
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_CURSOR('3rczgmwhnnv37', 0, 'ALL'));


See execution plan for sql_id from AWR Repository
SET LINESIZE 150
SET PAGESIZE 2000
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY_AWR('3rczgmwhnnv37'));

Forcing a New Explain Plan
EXPLAIN PLAN FOR 
SELECT * FROM XXX WHERE CHECK = 'YYY';
SELECT * FROM TABLE(DBMS_XPLAN.DISPLAY());