Re: Bind Variable performance test script

From: Wolfgang Breitling <breitliw_at_centrexcc.com>
Date: Tue, 3 Sep 2013 11:19:46 -0600
Message-Id: <1DF845F7-F5D7-481F-9B12-87F548D4EC2D_at_centrexcc.com>

If you know Java you can use Swingbench by Dominic Giles and just write your own database transactions, once with and once without binds

Sent from my iPhone. Typing errors may have occurred.

On 2013-09-03, at 10:16, Dba DBA <oracledbaquestions_at_gmail.com> wrote:

> I saw this on the web a while back. I think either Tom Kyte or Connor
> McDonald write it. It was a simple test where multiple sessions are opened
> with an without bind variables. Starts with 1 session, then increases the
> concurrency to show response time differences. I have been hunting around
> but I can't find it.
> does anyone remember who wrote this? I can write it myself, but when I
> build a case for a team, I like to provide examples from Oak Table members
> if possible. It adds credibility to my argument.
>
> I believe it was like this,but tested with 1 session, then multiple, and
> compared response time.
>
> http://www.oracle-base.com/articles/misc/literals-substitution-variables-and-bind-variables.php
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>

--
http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 03 2013 - 19:19:46 CEST