Way to find out In which phase exactly the Query is running on database??

[malay_biswal]

BTW i guess you are interested in how long all these steps took for a particular query. Is not it?
If so, trace that session and do a tkprof that will tell you.