Re: Run out of connections

Connect to the database before the push and when you start the push periodically query the v$session view (you can also put an "insert ... select ... from v$session" in a PL/SQL loop). That way you should be able to see where those sessions are coming from and if you query the v$sqlarea you may see what they are running as well.

HTH Djordje

• Original Message ----- From: CC Harvest <ccharvest_at_yahoo.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Friday, January 05, 2001 5:46 PM 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 - 00:46:50 CST