Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Performance, bind variables and TKPROF results
Hi!
I reproduced some bind variables tests from Tom Kyte's "Expert One-on-One", and got results that are not completely clear.
There are 3 scenarios:
- no bind variables for 10000 inserts,
From tkprof I've got timing results in OVERALL TOTALS STATEMENTS:
1 scenario : 2 scenario : 3 scenario
count CPU elapsed count CPU elapsed count CPU elapsed Parse 10101 26.99 26.63 10077 2.58 2.52 9 0.00 0.00Execute 10133 6.22 6.21 10121 15.42 15.36 10010 14.49 13.81
The overall performance (parse + exec) is as expected, but
the question is - why with bind variables the execution phase is
slower?
And why elapsed time is lower then CPU?
Environment: 9.2.0.1 on Solaris.
Thanks.
Sergei.
Received on Fri Feb 28 2003 - 17:52:58 CST