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 - 22:59:09 CST
