<div>
Hi Experts<br />
<br />
Even if I can identify the &nbsp;most timecausing Nested Loop<br />
other than CBO Cost. would be fine.<br />
<br />
Regards,<br />
Ganta
</div>


Hi Experts

Even if I can identify the  most timecausing Nested Loop
other than CBO Cost. would be fine.

Regards,
Ganta

<div>
<div class="content wysiwyg-content">
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.<br />
<br />
Is there any possible way of getting the information even in detail level at Nested loops.<br />
<br />
Eg: Nested Loop1 takes ... this much time..<br />
<br />
&nbsp;Nested Loop2 takes .. this much of time.<br />
<br />
Thanks in advance<br />
Ganta<br />

</div>
</div>


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
Ganta


Question related to TKPROF/EXPLAIN PLAN

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.