SQLNET.EXPIRE_TIME and CPU load
Date: Thu, 24 Jul 2008 12:46:19 +0200
Message-ID: <48885D7B.6090504@nordea.com>
Hi!
db: 9.2.0.6
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Jul 24 2008 - 05:46:19 CDT