Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: How parameter "processes" in initXXXX.ora affect Oracle
Show us output of
egrep 'set s(hmsys|emsys)' /etc/system
Yong Huang
yong321_at_yahoo.com
"Harry Sheng" <hsheng_at_innovance.com> wrote in message news:<SYpv7.65076$TW.352343_at_tor-nn1.netcom.ca>...
> Hi, group
>
> Could anyone give me some idea on how Oracle instance is affected by
> parameter "processes" in initXXXX.ora?
> I am doing a fresh install of Oracle8.1.7 on Solaris2.7. I consistently get
> an ORA-03113 error. I figured out that
> the parameter "processes" in init.ora causes the problem. The default value
> for "processes" is 50. I have to reduce
> it to 30 to clear the problem.
> My Solaris box is "Enterprise 420r". I believe that I have far more than
> enough resource to support 50 Oracle
> user processes on my box.
Received on Fri Oct 05 2001 - 22:43:51 CDT