1. using AUTOTRACE SQL> SET AUTOTRACE ON TRACEONLY SELECT * FROM emp WHERE emp_name = 'ABC';
2. Using EXPLAIN PLAN SQL> EXPLAIN PLAN for SELECT * FROM emp WHERE emp_name = 'ABC';
The advantage of using EXPLAIN PLAN over the AUTOTRACE is that former does not require the query to be actually run. The TRACEONLY option in AUTOTRACE just supress the query ouput but the query still runs before the explain plan is displayed.