Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Inactive sessions

Re: Inactive sessions

From: Howard J. Rogers <howardjr2000_at_yahoo.com.au>
Date: Tue, 24 Dec 2002 16:11:50 +1100
Message-ID: <6TRN9.9152$jM5.26231@newsfeeds.bigpond.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US