Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How parameter "processes" in initXXXX.ora affect Oracle

Re: How parameter "processes" in initXXXX.ora affect Oracle

From: Yong Huang <yong321_at_yahoo.com>
Date: 5 Oct 2001 20:43:51 -0700
Message-ID: <b3cb12d6.0110051943.5c801f77@posting.google.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US