SQLNET.EXPIRE_TIME and CPU load
- From: "Remigiusz Sokolowski" <remigiusz.sokolowski@xxxxxxxxxx>
- To: "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 24 Jul 2008 12:46:19 +0200
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
-----------------------------------------------------------------------------------------
begin:vcard
fn:Remigiusz Sokolowski
n:Sokolowski;Remigiusz
org;quoted-printable:Nordea Bank Polska S.A.;Departament Utrzymania
Serwis=C3=B3w Bankowych
adr;quoted-printable:;;=C5=81u=C5=BCycka 6A;Gdynia;pomorskie;81-537;Poland
email;internet:remigiusz.sokolowski@xxxxxxxxxx
title:administrator baz danych
tel;work:+48 58 667 1743
x-mozilla-html:FALSE
url:www.nordea.pl
version:2.1
end:vcard
Other related posts:
