Step1 : explain plan for <select query>;
Step 2: Select * from table (dbms_xplan.display);
This will show the explain plan for the above query.
One blog for all ORACLE DBA scripts & AWS Cloud commands, OCI commands etc
Step1 : explain plan for <select query>;
Step 2: Select * from table (dbms_xplan.display);
This will show the explain plan for the above query.
Comments
Post a Comment