How to generate explain plan for query in Oracle ?

 Generate explain plan for query

SQL> explain plan for select * from test;

Explained.

SQL> explain plan set statement_id ='anurag' for select * from test;

Explained.

SQL>

SQL> select * from table(dbms_xplan.display());

PLAN_TABLE_OUTPUT

--------------------------------------------------------------------------------

Plan hash value: 1357081020

--------------------------------------------------------------------------

| Id  | Operation         | Name | Rows  | Bytes | Cost (%CPU)| Time     |

--------------------------------------------------------------------------

|   0 | SELECT STATEMENT  |      |     1 |    40 |     2   (0)| 00:00:01 |

|   1 |  TABLE ACCESS FULL| TEST |     1 |    40 |     2   (0)| 00:00:01 |

--------------------------------------------------------------------------

Note

-----

PLAN_TABLE_OUTPUT

--------------------------------------------------------------------------------

   - dynamic statistics used: dynamic sampling (level=2)

12 rows selected.

SQL>