How to check execution plan of a query

First get the sql ID and then you can use below command to generate execution plan of a query in oracle

sql">SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('2t3nwk8h97vph',0));

In case you have more IDs, use below command to supply sql id every time you run the query

sql">SELECT * FROM table(DBMS_XPLAN.DISPLAY_CURSOR('&sql_id',0));