Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Profile seems inactive

    I set up a profile like the following:

    Name: expire_profile
    Connect Time (minutes): 30
    Idle Time (minutes): 1

    and then created a user:

    create user test_expire identified by test
    profile expire_profile;
    grant create session to test_expire;

    Neither did the user get kicked off of being idle for up to 10 minutes, but they've been logged into SQL Plus for 50+ minutes now without being terminated - meaning, I can run 'SELECT USER FROM DUAL' and still get results. Does the profile need to be enabled or something?


  2. #2
    Join Date
    Jan 2004
    Croatia, Europe
    Provided Answers: 5
    Did you set RESOURCE_LIMIT=TRUE in your init.ora ?
    Last edited by Littlefoot; 08-19-04 at 04:47.

  3. #3
    Join Date
    Jun 2004
    Provided Answers: 1
    You can set the parameter without having to go into the init.ora file - this saves you having to stop & restart the Db:

    Alter system set resource_limit=true;
    90% of users' problems can be resolved by punching them - the other 10% by switching off their PCs.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts