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: Maximum number of connections

Re: Maximum number of connections

From: NetComrade <andreyNSPAM_at_bookexchange.net>
Date: Mon, 21 Jun 2004 21:27:15 GMT
Message-ID: <40d7521e.6788741@localhost>

  1. don't use it, can't comment 2) Check your java clients logs! If they don't say ORA-xxxxx Maximum number of connections reached, it's not a problem. This error is also logged in alert.log (but not sure if always). Check if there are any other ORA- errors.

The max # depends on the processes parameter I believe. However, it's not a 1 to 1 relationship (but fairly close).

On Mon, 21 Jun 2004 22:50:25 +0200, "SV" <nono_at_nowhere.com> wrote:

>Ora9i R2 Standard Ed on Windows 2000 S
>
>1) Connection Manager is all the time on 22% of CPU usage.
> Is this normal? We have just a couple of Java clients
> connected through JDBC. Most of the time, they just
> sit idly there, doing nothing.
>
>2) sometimes our Java clients return "I/O error". This
> happens when a fair number of clients connect. I
> suspect this has something to do with the maximum
> number of simultaneuos connections to our
> server. (Dedicated server mode.) Where can I find
> and modify this parameter?
>
>Thanks in advance.
>
>

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Mon Jun 21 2004 - 16:27:15 CDT

Original text of this message

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