-
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
-
you use profiles to limit number of sessions per user
gee nowdays everyone call themselves DBAs
-
It sounds like you are trying to fix the wrong thing. The application sounds like it is at fault here, not the database.
-
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,
-
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
-
-
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
-
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
-
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."
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|