10046 and modplsql timings don't add up
All,
I'm trying to tune an html page created by Oracle's modplsql front end. When looking through the 10046 trace file I can see that the modplsql wrapper accounted for 1.45 seconds of the 1.49 total database seconds. What I'm confused about is that I've always understood the wrapper to encompass or roll up all the timings for the subordinate sql yet I the sql statement timings in the file don't come close to adding up. I've included the plsql wrapper and the tkprof timing output.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
I'm trying to tune an html page created by Oracle's modplsql front end. When looking through the 10046 trace file I can see that the modplsql wrapper accounted for 1.45 seconds of the 1.49 total database seconds. What I'm confused about is that I've always understood the wrapper to encompass or roll up all the timings for the subordinate sql yet I the sql statement timings in the file don't come close to adding up. I've included the plsql wrapper and the tkprof timing output.
call count cpu elapsed disk query current rows
------- ------ -------- ---------- ---------- ---------- ---------- ----------
Parse 1 0.00 0.00 0 0 0 0
0