Re: Max DB connections Oracle XE

From: Zakai Kinan <titanyen2000_at_yahoo.com>
Date: Thu, 31 Jan 2008 10:14:01 -0800 (PST)
Message-ID: <753852.8897.qm@web32612.mail.mud.yahoo.com>

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

Received on Thu Jan 31 2008 - 12:14:01 CST