Friday, March 18, 2011

Profile and Resource Limit

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 :

Issue :

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

No comments:

Post a Comment