Re: Good news: you can have lots of bind variables.

  • From: Jared Still <jkstill@xxxxxxxxx>
  • To: DEEDSD@xxxxxxxxxxxxxx
  • Date: Thu, 9 May 2013 08:57:21 -0700

On Thu, May 2, 2013 at 12:54 PM, <DEEDSD@xxxxxxxxxxxxxx> wrote:
> Only 17,819 binds


Highest I have seen in the real world is about 35000.
(client is fixing that :)

I seem to recall doing an experiment some years ago to find the limit.
May have been 64k bind vars.

Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
Oracle Blog: http://jkstill.blogspot.com
Home Page: http://jaredstill.com


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


Other related posts: