Re: oracle processes exceeding 2000

From: Xuequn Xu <xux_at_informa.bio.caltech.edu>
Date: 2000/04/26
Message-ID: <8e7c6a$1us@gap.cco.caltech.edu>#1/1

You may need to set semsys:seminfo_semmsl high enough.

Xuequn Xu

sreedhar (swarsree_at_my-deja.com) wrote:

: we have a sun e4500 machine, with 4gigs RAM. only one instance of
: oracle runs on this machine with no other applications. for some reason
: due to haevy traffic we are running out of sessions. currently the
: processes parameter is set to 1600. but we need more number of oracle
: sessions to cater to the kind of traffic we are getting. but i get the
: the following errors when i increase the processes parameter

: ORA-27145: insufficient resources for requested number of processes
: ORA-27300: OS system dependent operation:semids_per_proc failed with
: status: 0
: ORA-27301: OS failure message: Error 0
: ORA-27302: failure occurred at: sskgpwcr2
: ORA-27303: additional information: semids = 170, maxprocs = 2200

: we have 4GB of RAM.
Received on Wed Apr 26 2000 - 00:00:00 CDT