This content has been marked as final. Show 4 replies
user522961 wrote:start the query again, again.
on 11g R2.
How can I find explain plan already used when a query was running ?
you can check explain plan for running query....
check sql_id of running statement.....
find the sql plan using sql_id...
select * from TABLE(dbms_xplan.display_awr(’93djdy6ss3’));