RE: Run out of connections

From: Keith Shum <kshum_at_ilux.com>
Date: Sun, 7 Jan 2001 18:08:18 -0800
Message-Id: <10734.125946@fatcity.com>

Hello, Harvest,

	If you are on Windows, you can check Task Manager for Thread column.
	If you are on Unix, you can run "ps -A | grep oracle".
	You will see how many Oracle processes are running since Oracle
treats one connection as one process if you are in Dedicated Server mode.
	Good luck!

Yours,

Keith Shum

kshum_at_iLux.com

iLux Corporation
Phone (510) 226-5600 x 643
Fax (510) 226-8182
Cellular Phone (510) 435-0286
5600 Mowry School Road, Newark, CA 94560 http://www.iLux.com

-----Original Message-----
From: CC Harvest [mailto:ccharvest_at_yahoo.com] Sent: Friday, January 05, 2001 2:46 PM
To: Multiple recipients of list ORACLE-L Subject: Run out of connections

Hi, Gurus:

I have an application to push/pull data from a database to a datamart(Oracle8i). But somehow, everytime when push, I got the "run out of connection" error. I already have processes=200 in initSID.ora file.

So what can I do? How do I check what causes the error? Which process, and why?

Any advice will be highly appreciated. TIA. Nice weekend.

Chris

Do You Yahoo!?
Yahoo! Photos - Share your holiday photos online! http://photos.yahoo.com/
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: CC Harvest
INET: ccharvest_at_yahoo.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 Sun Jan 07 2001 - 20:08:18 CST