Oracle user PROFILE limits
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Oracle user PROFILE limits

  1. #1
    Join Date
    Jul 2003
    Posts
    135

    Exclamation Oracle user PROFILE limits

    Environment: Windows 2003, Oracle 10g

    What numbers are going to b reasonable for me to use to create a profile so as to assign it to my regular users and report users in order to restrict them to not eat all the resources like CPU and memory.

    The default profile used by users is 'DEFAULT' which has 'unlimited' limits. I am mainly looking good numbers for

    sessions_per_user
    cpu_per_session
    cpu_per_call
    connect_time
    logical_reads_per_session unlimited
    logical_reads_per_call unlimited
    composite_limit unlimited
    private_sga unlimited

    Currently I have create one like this:
    ----------------------------------
    create profile ABC limit
    sessions_per_user unlimited
    cpu_per_session 720000
    cpu_per_call unlimited
    connect_time unlimited
    idle_time 60
    logical_reads_per_session unlimited
    logical_reads_per_call unlimited
    composite_limit unlimited
    private_sga unlimited
    failed_login_attempts 10
    password_life_time unlimited
    password_reuse_time unlimited
    password_reuse_max unlimited
    password_lock_time unlimited
    password_grace_time unlimited;

    -D

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    totally depends on what queries they are going to run

  3. #3
    Join Date
    Mar 2007
    Location
    Ft. Lauderdale, FL
    Posts
    3,554
    Run explain plan for what you consider the more expensive queries your users might run and start by setting limits twice the larger values you have found.

    Over time you might have to fine tune limit values to accomodate real world situations.

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