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

Thread: RESOURCE SETTING FOR USERS

  1. #1
    Join Date
    Oct 2000
    Posts
    211
    Hi Guys,
    What is the procedure followed to determine the various resources to be allocated to the users?
    I have right now only one user in my db and about 10 persons login as that user(all developers)
    till now, they had 'Unlimited' for all the parameters. I would like to change the settings to the following. It being almost a random setting, i would like from others to confirm is there a better way?
    SESSIONS_PER_USER 2(2sessions per developer, so should it be 2 or 20?)
    CPU_PER_SESSION unlimited
    CPU_PER_CALL 6000
    LOGICAL_READS_PER_SESSION unlimited
    LOGICAL_READS_PER_CALL 100
    IDLE_TIME 30
    CONNECT_TIME 480;
    thanks
    manjunath

  2. #2
    Join Date
    Mar 2000
    Location
    Atlanta, GA,USA
    Posts
    155
    Hi!

    SESSIONS_PER_USER 2 will be 2, not 20! You can have 2 sessions or 2 guys can have 1 session per person.

    Sergey.

  3. #3
    Join Date
    Oct 2000
    Posts
    211
    thanks, sergey
    but i have 10 developers all using the same user name and if all of them need 2 sessions then sessions_per_user should be 20, right?

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