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

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Thu, 13 Sep 2012 10:16:57 +0200
Message-ID: <50519679.20808_at_nordea.com>

we had similar issue - a workaround was to purge such cursor every 2 minutes with
exec sys.dbms_shared_pool.purge('address,hash_value','c')

On 13.09.2012 10:03, Николаев Андрей Серапионович 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?

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

-- 
Pole na kazi

----------------------------------------------------------------------
Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
pos   : Senior DBA at DIiUSI
addr  : Nordea Bank Polska SA, Luzycka 6A st, 81-537 Gdynia, Poland
phone : +48 58 667 17 43
mobile: +48 602 42 42 77
Nordea Bank Polska S.A. z siedzibą w Gdyni, ul. Kielecka 2, 81-303 Gdynia, 
wpisaną do Rejestru Przedsiębiorców Krajowego Rejestru Sądowego pod numerem: 0000021828, 
dla której dokumentację przechowuje Sąd Rejonowy Gdańsk - Północ w Gdańsku, 
VIII Wydział Gospodarczy Krajowego Rejestru Sądowego, 
o kapitale zakładowym i wpłaconym w wysokości: 277.493.500,00 złotych, 
NIP: 586-000-78-20, REGON: 190024711--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 13 2012 - 03:16:57 CDT