How to find the real execution plan and binds used in that explain plan in Oracle 10g??

Step-1 : Find the Query and its SQL_ID to trace from AWR reports.

Step-2 : Execute following query to find real execution plan:

SELECT LPAD(‘ ‘,2*(LEVEL-1))||operation||’ ‘||options ||’ ‘||object_name ||’ ‘|| DECODE(id, 0, ‘Cost = ‘||position)

“Query Plan”

FROM v$sql_plan

START WITH id = 0 and sql_id=’8ska10yfjx4b5′

CONNECT BY PRIOR id = parent_id and sql_id=’8ska10yfjx4b5′;

Step-3 : To find what were the real bind varialbles query the following:

select name, datatype_string, value_string

from v$sql_bind_capture

where sql_id = ‘8ska10yfjx4b5’;