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

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

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