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
One blog for all ORACLE DBA scripts & AWS Cloud commands, OCI commands etc