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.
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
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.
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.