Re: SQL High version count because of too many varchar2 columns
- From: Eagle Fan <eagle.f@xxxxxxxxx>
- To: "Andrey.Nikolaev@xxxxxxxx" <Andrey.Nikolaev@xxxxxxxx>
- Date: Fri, 14 Sep 2012 14:55:51 +0800
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)
--
//www.freelists.org/webpage/oracle-l
Other related posts:
