Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Performance, bind variables and TKPROF results

Performance, bind variables and TKPROF results

From: Sergei <spohilko_at_yahoo.com>
Date: 28 Feb 2003 15:52:58 -0800
Message-ID: <b50f7e10.0302281552.c5f3a8e@posting.google.com>


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.00
Execute 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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US