CPU time and Elapsed time in tkprof
Date: 19 Mar 2003 09:28:47 -0800
Message-ID: <e5bc1c27.0303190928.48561d2e_at_posting.google.com>
I'm using 8.1.7.4 and I have the following SQL:
DELETE FROM MY_TAB WHERE id = :b1
There is an Oracle Text index defined on MY_TAB, so when the above
executes it executes a bunch of recursive SQL.
My question is if the tkprof report shows:
DELETE FROM MY_TAB WHERE id = :b1
Does elapsed time and cpu time include the time taken for the
recursive sql? Or do I need to sum this with the elapsed time of each
of the recursive sql to get an accurate measurement of how long this
statement took? Is the behavior different in 8.1.7.4 vs 9.2 regarding
the measurement of how long a SQL took?
Thanks
call count cpu elapsed disk query current
rows
------- ------ -------- ---------- ---------- ---------- ----------
Parse 1 0.02 0.34 9 66 0
0
Execute 4 522.76 619.75 249 30183 72098
9993
Fetch 0 0.00 0.00 0 0 0
0
------- ------ -------- ---------- ---------- ---------- ----------
total 5 522.78 620.09 258 30249 72098
9993
Sam
Received on Wed Mar 19 2003 - 18:28:47 CET