How to Disconnect or Expire the Idle Oracle 10g 11g Sesssions Automatically Using Profile IDLE_TIME Resouce

In many times we wanted to implement the automatic session expiry for the idle session in the databases which are having huge number of user session. Suppose if you wanted to expire the Oracle sessions which are idle more than 3 minutes.

Step 1. Create new profile with IDLE_TIME parameter as 3.


SQL> CREATE PROFILE TEST
LIMIT PASSWORD_REUSE_MAX 10
PASSWORD_REUSE_TIME 30
IDLE_TIME 3 ;
Profile created.

Step 2. Assign the new profile to the users which need to be automatically expired.
SQL> alter user scott profile test;

User altered.
DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google