DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 13

Thread: Processes parameter on initSID.ora

  1. #1
    Join Date
    Jun 2002
    Posts
    10

    Processes parameter on initSID.ora

    Hi all,
    Couple of questions need to ask.
    1. what does it means when I set processes = 100 on initSID.ora file?
    Does it means that I can have up to 100 concurrent processes running in database?
    2. If I have 2 users, user1 and user2. I want to limit user1 can have max. 20 processes under this login ID and up to 10 processes for user2. Is there a parameter to set (limit) sessions (or processes) per indevidule user.

    The reason I need to set a limited processes per user is to prevend too many processes spawed and caused Unix (HP-UX 11i) returned a message: can't fork process error. Last week, we had an application tried to connect to Oracle (8174), but for some reasons, it created hundreds of processes which caused Unix panic to report " fork..." message. I would like to prevend this happens again. How to accomplish this task.

    Thanks,

    Eric

  2. #2
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    you use profiles to limit number of sessions per user

    gee nowdays everyone call themselves DBAs

  3. #3
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    It sounds like you are trying to fix the wrong thing. The application sounds like it is at fault here, not the database.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  4. #4
    Join Date
    Jun 2002
    Posts
    10
    Hi,

    Thanks for your input. How do I limit session per user in profile?
    Sorry, we don't have a dba at our company at this moment so I will have to ask some "stupid" questions, but please help.

    Could anyone provide step by step procedure to hand-hold me ?
    Thanks,

  5. #5
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    certainly not gonna guide you step by step!

    you can go to tahiti.oracle.com and read the adminitrator guide, there is a whole chapter tell you how to use profiles

  6. #6
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Originally posted by apmdba
    Hi,
    Could anyone provide step by step procedure to hand-hold me ?
    Thanks,

    I'll do that if you buy me a ticket to MADRID, i need to hug PANDO
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  7. #7
    Join Date
    Jan 2001
    Posts
    2,828
    Originally posted by apmdba
    Hi,

    Thanks for your input. How do I limit session per user in profile?
    Sorry, we don't have a dba at our company at this moment so I will have to ask some "stupid" questions, but please help.

    Could anyone provide step by step procedure to hand-hold me ?
    Thanks,
    I am lookin for a job .You can hire me

  8. #8
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    If you use OEM it's a pretty simple process, first you create a profile and then alter the user to use the profile..

    You must also set the init.ora parameter to

    RESOURCE_LIMIT=TRUE

    But to create manually, perform the following. Actually even when using OEM, you can only limit the profile's SESSION_PER_USER to set values. You'll need to alter the profile to adjust the limit manually after creation.

    If performing the whole process manually...

    CREATE PROFILE TEST LIMIT SESSIONS_PER_USER 3;

    ALTER USER FRED PROFILE TEST;


    Cheer,
    OCP 8i, 9i DBA
    Brisbane Australia

  9. #9
    Join Date
    Nov 2002
    Location
    New Delhi, INDIA
    Posts
    1,796
    Grjohnson you don't want me to hug PANDO right ... Your answer prevents me from getting a free ticket to Madrid.
    Amar
    "There is a difference between knowing the path and walking the path."

    Amar's Blog  Get Firefox!

  10. #10
    Join Date
    Jun 2002
    Posts
    10
    Hi All

    Thanks for all your input.
    Good resource site - Pando.
    adewri- ticket is on the way
    grjohnson- I will test it, thanks
    hrishy- I guess the position will be open some time next decade. But if it become available, I certainly will let everyone know.

    Thanks,

    You are good.

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