Re: SQLNET.EXPIRE_TIME and CPU load

From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Fri, 25 Jul 2008 08:39:10 +0200
Message-ID: <4889750E.5020503@nordea.com>

Andreas Piesk pisze:
> Remigiusz Sokolowski schrieb:

>>
>> Anybody meet something similar? In docs it is stated that EXPIRE_TIME
>> eventually can decrease a network performance and in general it is
>> recommended to set it to 10 (in minutes), which we did.
>>

>
> i had problems with DCD too (11g on unix).
> the base bug 2752985 was found in 8.1.7 and was fixed in 10.1 but found
> it's way back in 11g (bug 6918493).
> in 11g the sessions just hang, maybe in your version the sessions only
> slow down because of spinning. then you should have noticed a decrease
> in throughput too.
>
> regards,
> -ap
>
>

for anybody interested
I dig deeper into the Metalink and it seems like a bug 4168407 (patches in versions 9.2.0.7, 10.0.1.5, 10.2.0.1)

Regards
Remigiusz

---

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: 227.593.500,00 z³otych, NIP: 586-000-78-20, REGON: 190024711

---

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

Received on Fri Jul 25 2008 - 01:39:10 CDT