I have a sqlstatment which has nested loops and so on. When I do explain plan/TKPROF. I only get the information on sort options CPU Time, Elapsed time, execution time on summary level.
Is there any possible way of getting the information even in detail level at Nested loops.
Eg: Nested Loop1 takes ... this much time..
Nested Loop2 takes .. this much of time.
Thanks in advance