SQL High version count because of too many varchar2 columns

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Wed, 12 Sep 2012 14:25:04 +0800
Message-ID: <CANHUaOrELhoRFFYeOLD7_fD19=GuqmAzbJrsGcTF+GU3-HNgBg_at_mail.gmail.com>



Hi:
We have a table which has 17 varchar2 columns. Each varchar2 column has different bind variable ranges.

for example varchar2(4000) has 4 ranges: 0-32,33-128,129-2000,2001-4001. if the bind variables' length is in different ranges, it will create a new version!

With 17 varchar2 columns, we have more than 3000 versions!

We are using java code, if there any method to make oracle bind all different variables with the max length?

Thanks.

--

Eagle Fan (www.dbafan.com)

--

http://www.freelists.org/webpage/oracle-l Received on Wed Sep 12 2012 - 01:25:04 CDT

Original text of this message