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.