DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Sessions_per_user

  1. #1
    Join Date
    Jan 2001
    Posts
    515

    Sessions_per_user

    I have a profile that limits the SESSIONS_PER_USER to 1 but it does not seem to be working

    CREATE PROFILE PROF_USER
    LIMIT SESSIONS_PER_USER 1
    CPU_PER_SESSION DEFAULT
    CPU_PER_CALL DEFAULT
    CONNECT_TIME DEFAULT
    IDLE_TIME DEFAULT
    LOGICAL_READS_PER_SESSION DEFAULT
    LOGICAL_READS_PER_CALL DEFAULT
    COMPOSITE_LIMIT DEFAULT
    PRIVATE_SGA DEFAULT
    FAILED_LOGIN_ATTEMPTS 5
    PASSWORD_LIFE_TIME 90
    PASSWORD_REUSE_TIME 365
    PASSWORD_REUSE_MAX UNLIMITED
    PASSWORD_LOCK_TIME DEFAULT
    PASSWORD_GRACE_TIME 0
    PASSWORD_VERIFY_FUNCTION F_VERIFY_PASSWORD
    /

    The user has this profile for their default.

    Any ideas why it is not working?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    resource_limit set to true?

Posting Permissions

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


Click Here to Expand Forum to Full Width