OS novell = netware 4.2
I have notice that when my users end session from workstation still oracle
server shows their session infromation as inactive. Though those
workstations (clients) are off.
LOGON_TIM STATUS SID SERIAL# MACHINE
--------- -------- ---------- ---------- ------------
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