set autotrace traceonly explain, and condition : autotrace « SQL PLUS Session Environment « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. SQL PLUS Session Environment
3. autotrace

SQL>
SQL>
SQL> create table t
  2  as
  3  select mod(ROWNUM,3) a, ROWNUM b, ROWNUM c
  4    from all_tables;

Table created.

SQL>
SQL> set autotrace traceonly explain
SQL> select * from t where b = 1 and c = 1;

Execution Plan
----------------------------------------------------------
Plan hash value: 1601196873

----------------------------------
| Id  | Operation         | Name |
----------------------------------
|   0 | SELECT STATEMENT  |      |
|*  1 |  TABLE ACCESS FULL| T    |
----------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   1 - filter("C"=1 AND "B"=1)

Note
-----
   - rule based optimizer used (consider using cbo)

SQL>
SQL>
SQL> set autotrace off
SQL>
SQL> drop table t;

Table dropped.