Showing Execution Plan details for a Query

Use these commands one by one the you will get the execution plan for a query:
set auto on;
set autotrace on;
select * from employee;



select * from employee;




       ENO ENAME                                 MID
---------- ------------------------------ ----------
         1 syam                                    2
         2 ram                                     2
         3 raj                                     2
         4 rajgopal                                3
         5 satish                                  3
         6 sundar                                  3


6 rows selected.




Execution Plan
----------------------------------------------------------
Plan hash value: 2119105728


------------------------------------------------------------------------------
| Id  | Operation         | Name     | Rows  | Bytes | Cost (%CPU)| Time     |
------------------------------------------------------------------------------
|   0 | SELECT STATEMENT  |          |     6 |   258 |     3   (0)| 00:00:01 |
|   1 |  TABLE ACCESS FULL| EMPLOYEE |     6 |   258 |     3   (0)| 00:00:01 |
------------------------------------------------------------------------------


Note
-----