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:confused:

you use profiles to limit number of sessions per user

gee nowdays everyone call themselves DBAs :D

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

Quote:

---

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 :D

Quote:

---

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,

Grjohnson you don't want me to hug PANDO right ... Your answer prevents me from getting a free ticket to Madrid.

Hi All

Thanks for all your input.
Good resource site - Pando.
adewri- ticket is on the way :D
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.

Quote:

---

Originally posted by apmdba
adewri- ticket is on the way :D

---

A free ticket to Madrid. Cooooooooool :cool:. Pando here i come. I better start packing :D

Quote:

---

Originally posted by adewri
Grjohnson you don't want me to hug PANDO right ... Your answer prevents me from getting a free ticket to Madrid.

---

Now I can't get that damn image out of my head... :(

Quote:

---

Originally posted by adewri
A free ticket to Madrid.

---

Last year they finished building a medieval war galley on Lac Leman (Lake of Geneva). Looks like they are now doing sheduled voyages. Amar, the rowing benches look awful HARD.