Bind Variable performance test script
From: Dba DBA <oracledbaquestions_at_gmail.com>
Date: Tue, 3 Sep 2013 12:16:07 -0400
Message-ID: <CAE-dsOLT6c9XogVpPFTmy28N1JtAFLeQej+Wc=9NqO5iikrJOg_at_mail.gmail.com>
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.
Date: Tue, 3 Sep 2013 12:16:07 -0400
Message-ID: <CAE-dsOLT6c9XogVpPFTmy28N1JtAFLeQej+Wc=9NqO5iikrJOg_at_mail.gmail.com>
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-lReceived on Tue Sep 03 2013 - 18:16:07 CEST