How to get Explain Plan

 How to get Explain Plan

explain plan for your_query;

Explained

Genrate Plan

select * from table(dbms_xplan.display);