RE: Max DB connections Oracle XE

From: Sweetser, Joe <JSweetser_at_icat.com>
Date: Thu, 31 Jan 2008 11:18:34 -0700
Message-ID: <E323160E08E560459CD05A883546C3CE0B68C765@earthquake.ICAT.COM>

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Zakai Kinan Sent: Thursday, January 31, 2008 11:14 AM To: oracle-l_at_freelists.org
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_at_gmail.com> 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_at_yahoo.com>:
> > 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

Received on Thu Jan 31 2008 - 12:18:34 CST