Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Inactive sessions
I agree they should be. But have you implemented MTS (which will mean that
you couldn't care?)
Regards
HJR
"Jayaraman Ashok" <ashok_jayaraman_at_yahoo.com> wrote in message
news:7ca2852.0212232059.5a60b3a1_at_posting.google.com...
> Hi
> The setup is Oracle 8.1.6.3.0 on Aix 4.3.3 running 11i applications.
> The application server is another rs/6000 running Aix 4.3.3 , where
> all the forms and reports are installed.
> Now the client connections are made either through the browser
> directly
> (self service modules like HR) and through the forms. The former type
> is the JDBC thin client connection.
> Now numerous sessions keep running on the database server even after
> the client has disconnected. There are many sessions with 'INACTIVE'
> status. I have set sqlnet.expire_time=10 in my sqlnet.ora. But i feel
> that the resources held by such sessions are not released. How to
> tackle this situation? If the client closes his browser or forms
> session abnormally, the shadow process on the server side should be
> killed.
>
> Cheers,
> Ashok
Received on Mon Dec 23 2002 - 23:11:50 CST