Recently i decided to set an idle_time limit for some of my production database users, beacause all the time left their sessions connected to the database after finishing their work consuming resources.
I create a profile limiting idle time to 2 hours , but i found out that its not working.
In order a profile to limit a resource you must set the RESOURCE_LIMIT initialization parameter to TRUE. Fortunately this parameter is dynamic so :
For RAC DBs:
alter system set resource_limit = TRUE scope=both SID='*';
create profile tst_profile limit idle_time 120;
alter user my user profile tst_profile;
For non RAC DBs omit the sid='*'
For more info check the
Oracle® Database Security Guide 10g Release 2 (10.2)
Part Number B14266-06