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’;