SQL High version count because of too many varchar2 columns
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 Sep 2012 14:25:04 +0800
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
