Re: Good news: you can have lots of bind variables.
From: Jared Still <jkstill_at_gmail.com>
Date: Thu, 9 May 2013 08:57:21 -0700
Message-ID: <CAORjz=PP8jy9BkWbE-b5j8Q7aLwHpmezVcWmWkqJYueryEhaDw_at_mail.gmail.com>
On Thu, May 2, 2013 at 12:54 PM, <DEEDSD_at_nationwide.com> wrote:
> Only 17,819 binds
Date: Thu, 9 May 2013 08:57:21 -0700
Message-ID: <CAORjz=PP8jy9BkWbE-b5j8Q7aLwHpmezVcWmWkqJYueryEhaDw_at_mail.gmail.com>
On Thu, May 2, 2013 at 12:54 PM, <DEEDSD_at_nationwide.com> 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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu May 09 2013 - 17:57:21 CEST