Re: SQL High version count because of too many varchar2 columns

You may look at the MOS note:
"High Version Count Due To BIND_MISMATCH [ID 336268.1]"

and discuss setting the event 10503 with Oracle Support.

Best Regards
Andrey Nikolaev
http://andreynikolaev.wordpress.com/

> 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?

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