Simpler Navigation coming for Servers and Operating Systems
Coming soon: a much simpler Servers and Operating Systems section of the Community. We will combine many of the older boards, and you won't have to click through so many levels to get at the information you need. If you are looking for an older board and do not find it, check the consolidated boards, as the posts are still there.
General
cancel
Showing results for 
Search instead for 
Did you mean: 

Increase value of Oracle resource limit

BHegarty
Advisor

Increase value of Oracle resource limit

Hi I hope you can help, I need to increase the value of resources Oracle can use. I think its rlimit but I am not sure, and I don't know where to go to increase this value???
Any help appreciated, I am using HPUX 11 on an Lclass system and also using Oracle8i.
Thanks
Babs :)
all things come to those who wait..
6 REPLIES
Roger Baptiste
Honored Contributor

Re: Increase value of Oracle resource limit


I am not sure what is the exact resource you want to increase. Resources are set at two levels . At the system wide level , you increase kernel parms and that is applicable to all the users in the system.
But, you can turn the knob at the shell level too, by
using the limit command.
It's ulimit -a for posixshells(ksh,sh) and limit for cshell.

You would still need to know
what resource you want to change.

HTH
raj
Take it easy.
A. Clay Stephenson
Acclaimed Contributor

Re: Increase value of Oracle resource limit

Hi:

This is very vague. You could be talking about ulimit (in its various forms) or kernel parameters (maxdsiz, shmmax, maxssiz, maxtsiz - with 64bit extensions); you could also be talking about enabling largefiles?

Just a bit more zeroing in, please.

Clay
If it ain't broke, I can fix that.
BHegarty
Advisor

Re: Increase value of Oracle resource limit

Hi sorry about the fuzzy question...
I mean the amount of concurrent processes Oracle can run.
Hope this clarifies
Babs :)
all things come to those who wait..
Volker Borowski
Honored Contributor

Re: Increase value of Oracle resource limit

Assumption: Oracle is running in dedicated server mode!

This would be parameter
processes=
sessions=
in a file called init"SID".ora.

Usally processes should be set to be 10% bigger than the estimated maximum number of users to connect and sessions being some 10-20 bigger than processes.

Hope this helps
Volker
Roger Baptiste
Honored Contributor

Re: Increase value of Oracle resource limit

Max concurrent processes apply
to all users (not just oracle). The kerenl param
which sets this is
maxuprc.

To see your current setting do
#kmtune -q maxuprc

If you need to increase it,
take a downtime and do it through SAM. On a busy system
, i have it as 2048.

-raj
Take it easy.
A. Clay Stephenson
Acclaimed Contributor

Re: Increase value of Oracle resource limit

Hi again:

Okay - that could be some of the kernel paramters above including some of the msg (messages) and sem (semaphore) tunables as well. It could also be nproc and maxupc. In general, the Oracle install manual will give you pretty good values for these. There is also a tuned parameter set for database you can select in SAM and build a new kernel. It's generally a pretty good starting point with one MAJOR exception. Some of those set timeslice to 1 (it should be 10); if you choose to apply a tuned parameter set make sure that you check timeslice and reset it if necessary.

Regards, Clay
If it ain't broke, I can fix that.