RE: Max DB connections Oracle XE

You are probably using an spfile.  Try something like this in sqlplus:

Shutdown immediate;
Create spfile from pfile='c:\full\path\to\init.ora\file';
Startup;

And then check the value....

 

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zakai Kinan
Sent: Thursday, January 31, 2008 11:14 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: Re: Max DB connections Oracle XE

Does the init params set in stone in XE?  I changed them and a show
param processes does not show any changes.

Thanks for any help;

ZK


--- Gints Plivna <gints.plivna@xxxxxxxxx> wrote:

> By default XE have initialization parameter processes set to 40.
> Oracle internally need some ~20 processes so only ~20 are left to user

> initially and it seems one cannot do more :)
> 
> However just change processes to something bigger and restart db.
> 
> Of course sooner or later you'll stop on allowable memory errors.
> 
> Gints Plivna
> http://www.gplivna.eu
> 
> 2008/1/30, Zakai Kinan <titanyen2000@xxxxxxxxx>:
> > I am a newbie to Oracle. I am looking to find out
> the
> > max number of concurrent connections from a java
> app
> > that Oracle XE will support and I can't find that info.  Does XE 
> > have a restriction?
> >
> >
> > TIA,
> >
> >
> > ZK
> >
> >
> >     
>
________________________________________________________________________
____________
> > Looking for last minute shopping deals?
> > Find them fast with Yahoo! Search. 
>
http://tools.search.yahoo.com/newsearch/category.php?category=shopping
> > --
> > http://www.freelists.org/webpage/oracle-l
> >
> >
> >
> 



 
________________________________________________________________________
____________
Be a better friend, newshound, and
know-it-all with Yahoo! Mobile.  Try it now.
http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ 

--
http://www.freelists.org/webpage/oracle-l



 
Confidentiality Note: This message contains information that may be 
confidential and/or privileged. If you are not the intended recipient, you 
should not use, copy, disclose, distribute or take any action based on this 
message. If you have received this message in error, please advise the sender 
immediately by reply email and delete this message. Although ICAT Managers, LLC 
scans e-mail and attachments for viruses, it does not guarantee that either are 
virus-free and accepts no liability for any damage sustained as a result of 
viruses.  Thank you.

--
http://www.freelists.org/webpage/oracle-l

Other related posts: