Set idle_time value to 15 for a profile

Posted on 2006-04-20
Last Modified: 2013-12-11
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?
Question by:sikyala
    LVL 4

    Accepted Solution

    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..

    Author Comment

    I actually found something on the Internet and when I issued the following statement it worked.

    alter profile PROFILE_X limit idle_time 15 ;

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Suggested Solutions

    Subquery in Oracle: Sub queries are one of advance queries in oracle. Types of advance queries: •      Sub Queries •      Hierarchical Queries •      Set Operators Sub queries are know as the query called from another query or another subquery. It can …
    Background In several of the companies I have worked for, I noticed that corporate reporting is off loaded from the production database and done mainly on a clone database which needs to be kept up to date daily by various means, be it a logical…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video shows how to Export data from an Oracle database using the Original Export Utility.  The corresponding Import utility, which works the same way is referenced, but not demonstrated.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    9 Experts available now in Live!

    Get 1:1 Help Now