Explain Plan(Transformed Query)

Is it possible to find out the query transformed by optimizer, that generates the best plan.

e.g:- select * from emp
where empno ='E001' or job ='CLERK'

if transformed into
select * from emp where empno='E001'
union all
select * from emp where job='CLERK' and empno <> 'E001'

How to find out transformed query, like is there any view?

Use 10053 trace event.

Tamil

Can you provide me some help, how to use it. or provide me some links regarding the usage.

Thanks in advance.

heard of google?