Inactive sessions
From: zh <snajeeb_at_emirates.net.ae>
Date: Thu, 14 Feb 2002 10:39:56 +0400
Message-ID: <a4flvu$8tq9_at_news-dxb.emirates.net.ae>
Date: Thu, 14 Feb 2002 10:39:56 +0400
Message-ID: <a4flvu$8tq9_at_news-dxb.emirates.net.ae>
Database = oracle 8i
OS novell = netware 4.2
--------- -------- ---------- ---------- ------------ 11-FEB-02 INACTIVE 8 1333 KALPESH 11-FEB-02 INACTIVE 36 1680 KALPESH 11-FEB-02 INACTIVE 17 4932 KALPESH 12-FEB-02 INACTIVE 30 2386 REMOTE2 12-FEB-02 INACTIVE 37 3753 KALPESH 14-FEB-02 ACTIVE 25 8094 KALPESH
from above data we can see that kalpesh started another session on 14 feb but server still shows session of 11 feb and 12 feb.
Because of this if we keep working, after few days my oracle server get very slow. It means these inactive session is occuping some of resources or RAM.
I appericate to help me to fine tune in this case. How I can get rid of
these inactive session. killing these session manually is not much helpful.
Thanks
zubair
Received on Thu Feb 14 2002 - 07:39:56 CET