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

From: Eagle Fan <eagle.f_at_gmail.com>
Date: Fri, 14 Sep 2012 14:55:51 +0800
Message-ID: <CANHUaOosLfAfCJeKxOFAJ_zDaBUaW+9zzcbyTmfgLwvOxKOZ+Q_at_mail.gmail.com>

Hi Andrey:
We have tried 10503 event in QA environment, but it got ORA-01483 errors.

And I searched for this event, seems it's buggy and doesn't work as expected in all versions.

Thank you!

On Thursday, September 13, 2012, îÉËÏÌÁÅ× áÎÄÒÅÊ óÅÒÁÐÉÏÎÏ×ÉÞ wrote:

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

-- 
Eagle Fan (www.dbafan.com)

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

Received on Fri Sep 14 2012 - 01:55:51 CDT