30 minutes Idle time - disconnect connection

[Nando]

Hey All

can someone assist in how to configure an auto disconnect from a database connection if connection is idle for 30 minutes.

 

[Marco Kalter]

You can use an Oracle profile for this purpose. For example:

create profile max_idle_profile limit idle_time 30;

This profile can then be assigned to database users where this is appropriate:

alter user scott profile max_idle_profile;