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
IDLE_TIME 3 ;
Step 2. Assign the new profile to the users which need to be automatically expired.
SQL> alter user scott profile test;