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


How to check CPU cores in Linux

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.