Re: Inactive sessions

"zh" <snajeeb_at_emirates.net.ae> wrote in message news:<a4flvu$8tq9_at_news-dxb.emirates.net.ae>...
> Database = oracle 8i
> 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
> zubair

Do your users sign out formally? Received on Thu Feb 14 2002 - 17:21:45 CET