You are using Oracle 11g DBMS with Cost-Based Optimizer (CBO). In order to perform SQL tuning for…

You are using Oracle 11g DBMS with Cost-Based Optimizer (CBO). In order to perform SQL tuning for a query, you decide to use ‘set autotrace’ option of SQ*Plus as below: SQL> SET AUTOTRACE ON SQL> sele