Set idle_time value to 15 for a profile

I need to set an idle_time limit for a profile. What is the syntax for doing that? The profile is Profile_X and the resource_name is idle_time and I need to give the field Limit the value of 15 (which is I guess 15 minutes). Could someone help me?
sikyalaSenior Database AdministratorAsked:
Who is Participating?
 
meluhkCommented:
First make sure that you have resource_limits set to true:

sql>  alter system set resouirce_limits=true;

Then you can use resource limits in profiles.  The syntax for setting idle_time for a profile is:

sql>  create profile profile_name limit idle_time 15;

This limits idle_time for that profile to 15 minutes.

To give this to a users:

sql>  alter user username profile profile_name;

Hope that helps..
0
 
sikyalaSenior Database AdministratorAuthor Commented:
I actually found something on the Internet and when I issued the following statement it worked.

alter profile PROFILE_X limit idle_time 15 ;
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.