From: Remigiusz Sokolowski <remigiusz.sokolowski_at_nordea.com>
Date: Thu, 24 Jul 2008 12:46:19 +0200
Message-ID: <48885D7B.6090504@nordea.com>


os: Windows Sever 2003

few days ago we experienced quite interesting case, which resulted in high CPU usage on the environment described above.

Before this case happened we had set SQLNET.EXPIRE_TIME=10 as a solution for timeout-ing db links. After few days we have got a CPU load not seen before.
At the beginning we did not link it to setting SQLNET.EXPIRE_TIME, but when searching for a solution, a co-worker of mine found a metalink note on *Bug No.* 3325411, which is actually bound to version 8.1.7 of db and to windows Server 2000, but anyway we remove EXPIRE_TIME setting and it seems, this move does a solution.

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.

Best regards
Remigiusz Sokolowski

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

Received on Thu Jul 24 2008 - 05:46:19 CDT

Original text of this message