My PROCESSES parameter is set at 150.

so in theory, it should allow around 145 connections at any given time right
?....

then why doesn't the database allow more connections after reaching 15-20
connections ?...

any idea ?..

Thanks






>From: Regis Biassala <Regis.[Email Address Removed] Ron Krockett <[Email Address Removed] RE: DB connections
>Date: Mon, 30 Dec 2002 16:18:46 -0000
>
>parameter PROCESSES is the one to modify:
>if you set the value 100 then 95 connections are allowed.
>
>Regis
>
>-----Original Message-----
>From: Ron Krockett [mailto:[Email Address Removed] Monday, December 30, 2002 4:07 PM
>To: LazyDBA.com Discussion
>Subject: DB connections
>
>
>Hi gurus..
>
>Some of my developers are saying that it is not allowing more than 15 to 20
>connections at any given time...
>
>How to increase this number ?...
>
>Oracle9.2/Sun 5.8
>
>thanks to all gurus.
>Ron
>
>
>
>
>
>_________________________________________________________________
>MSN 8 helps eliminate e-mail viruses. Get 3 months FREE*.
>http://join.msn.com/?page=features/virus&xAPID=42&PS=47575&PI=7324&DI=7474&S
>U=
>http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_virusprotec
>tion_3mf
>
>
>--------
>Oracle documentation is here:
>http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
>To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
>Tell yer mates about http://www.farAwayJobs.com
>By using this list you agree to these
>terms:http://www.lazydba.com/legal.html
>*********************************************************************
>This electronic transmission is strictly confidential and intended solely
>for the addressee. It may contain information which is covered by legal,
>professional or other privilege. If you are not the intended addressee,
>you must not disclose, copy or take any action in reliance of this
>transmission. If you have received this transmission in error,
>please notify the sender as soon as possible.
>
>This footnote also confirms that this message has been swept
>for computer viruses.
>**********************************************************************


_________________________________________________________________
The new MSN 8: smart spam protection and 3 months FREE*.
http://join.msn.com/?page=features/junkmail&xAPID=42&PS=47575&PI=7324&DI=7474&SU=
http://www.hotmail.msn.com/cgi-bin/getmsg&HL=1216hotmailtaglines_smartspamprotection_3mf

Oracle LazyDBA home page