| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: maximum number of processes exceeded
Donna,
thanks for the thought.
no web connections, just Citrix for a middle tier.
everything else is dedicated server connections.
It appears that the count(*) for v$process is increasing, while the count for v$session is remaining stable.
thread count is at 175 ... I guess when it gets to 250 it will sell.
it was fine at count(*) from v$process = 248 - hit it at 250. this is a bug - but I don't want to create a case - I just want to fix it.
just going to:
unload user accounts
export
wipe the binaries
wipe the database
install binaries
patch
build new database
import
recreate user accounts.
monitor heavily tomorrow.
thanks,
Paul
Paul,
Don't know if this is applicable, but thought I'd let you know what we found.
Sun UE6500
Solaris 2.6
Oracle RDBMS 7.3.4 & 8.1.7.0.0
We set a limit on our web accesses. What we found is that if more attempt to
connect than we have set to allow, a process will show up in v$process but
not
v$session. It appears that Oracle opens a process for the user, then
validates
the connection (i.e. number of processes, password, etc) before opening a
session. We would hit max processes because of this even though we had not
come
close to max sessions. We ended up talking to the developers to help
estimate
the number of valid sessions needed and increased the number of sessions for
this id.
Hope this helps.
donita
:Date: Thu, 30 Aug 2001 09:15:46 -0800
:To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
:X-Comment: Oracle RDBMS Community Forum
:X-Sender: Paul Drake <paled_at_home.com>
:From: Paul Drake <paled_at_home.com>
:Subject: maximum number of processes exceeded
:X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman
:
:Hi.
:
:Filing an iTAR - though I'd see if anyone had a similar experience.
:
:NT Server 4.0 Enterprise Edition - SP6a
:Dell PowerEdge 4400 - 4 CPUs
:Oracle Server Standard Edition 8.1.7.1.2
: (will be applying 81715 soon, after current problems resolved)
:
:started with
:processes = 150
:increased to
:processes = 250
:
:hiked transactions, max_rollback_segments, etc in init.ora
:
:the 2nd NIC was changed from a DMZ address to an internal address.
:no changes were made to the 1st NIC which had an internal address.
:
:Site reports that they're getting error:
:
: "ORA-01034: maximum number of processes exceeded"
:
:at login.
:
:only 10 connections viewable via a netstat -n
:
:I cannot get in with svrmgrl - get an ORA-00020 error.
:Will have to get in after shutting down the instance.
:
:I disabled the OracleSNMP Master Agent.
:
:No third party monitoring tools are in use (HP Openview, etc.)
:
:gonna break out a packet sniffer when I can get access.
:
:thanks for any help.
:
:Paul
:--
:Please see the official ORACLE-L FAQ: http://www.orafaq.com
:--
:Author: Paul Drake
: INET: paled_at_home.com
:
:Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
:San Diego, California -- Public Internet access / Mailing Lists
:--------------------------------------------------------------------
:To REMOVE yourself from this mailing list, send an E-Mail message
:to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
:the message BODY, include a line containing: UNSUB ORACLE-L
:(or the name of mailing list you want to be removed from). You may
:also send the HELP command for other information (like subscribing).
|\ _,,,---,,_
ZZZzz /,`.-'`' -. ;-;;,_
_________________|,4- ) )-,_. ,\ (____-'___________________
'---''(_/--' `-'\_)
Donita Hilfinger donita.hilfinger_at_gwl.com
ISIS Oracle Database Administrator Ph:(303)737-4179
Great-West Life Assurance Co. Fax:(303)737-4850
8515 E. Orchard Rd, m/s 5T2
"The promise is remembered long after the conditions attached to it are
forgotten"
-- author unknown
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Drake INET: drake_at_psscorp.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).Received on Thu Aug 30 2001 - 16:26:25 CDT
 |
 |