Re: Inactive JDBC sessions in Oracle 8.1.7 remain in Linux process list

From: Jasper Scholten <Turfkade.nospam_at_xs4all.nl>
Date: Sat, 11 Oct 2003 19:54:29 +0200
Message-ID: <3f8843d1$0$58711$e4fe514c@news.xs4all.nl>

Bill,

If oracle lists your session as inactive, this means that you still have a connection to the database and means that your userprocess is still there.

If this is what you are talking about, this is normal behaviour. The only way to get rid of this process is to terminate the session. This means that you have to do a close on the connection.

It looks to me that you do not close the connection at all.

Regards,

Jasper

"Bill" <lilhepcat_at_yahoo.com> schreef in bericht news:vod7oi10st0602_at_corp.supernews.com...
> As the subject line notes, I'm having issues where the jdbc
> sessions to our database remain as a process on our linux 6.2 box
> long after oracle lists the session as inactive. kill immediately
> from the OEM doesn't get rid of them from the OS side. The only
> way to do so is to perform a whole buch of kill -9's to empty them
> out. Anyone else see this on a linux db server before? and if so,
> how did you fix it?
>
> Thanks for any help!
>
> ______________________________
> Posted with NewsLeecher
> http://www.newsleecher.com/
>
Received on Sat Oct 11 2003 - 12:54:29 CDT