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));