Below are the few methods of generating explain plan .

 

1.Generating explain plan for a sql query:

We will generate the explain plan for the query ‘SELECT COUNT(*) FROM DBACLASS;’

2. Explain plan for a sql_id from cursor

 

 

3. Explain plan of a sql_id from AWR:

Above will display the explain plan for all the plan_hash_value in AWR. If you wish to see the plan for a particular plan_hash_value.

4. Explain plan of sql baseline:

If you wish the see the plan for a sql_handle,then

5. Explain plan for sql id from sql tuning set: