Connecting Tech Pros Worldwide Forums | Help | Site Map

Schema level session idle time out in oracle

Newbie
 
Join Date: Mar 2007
Posts: 8
#1: Jul 29 '09
Hi,

I am using Oracle 10g as a database server. I have two schema suppose s1 and s2. Suppose, I login to the s1 schema and as well as s2 schema. These two connection is active in two different session. Now, I want that, If I keep idle for more than 2 minutes in the session for s1 schema, then the session for s1 schema should disconnected from the DB, but the session for s2 schema should remain connected to the DB.

Is that possible in Oracle 10g database.
Please provide some solution.

Thanks & Regards
Debabrata Jana

debasisdas's Avatar
Moderator
 
Join Date: Dec 2006
Location: Bangalore ,India
Posts: 7,509
#2: Jul 29 '09

re: Schema level session idle time out in oracle


That logic can easily be implemented from any front end application.
Reply