Re: Max DB connections Oracle XE

From: Gints Plivna <gints.plivna_at_gmail.com>
Date: Wed, 30 Jan 2008 20:09:02 +0200
Message-ID: <6e49b6d00801301009n13df98bdref9c306bf797e084@mail.gmail.com>


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
>
>
>

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Jan 30 2008 - 12:09:02 CST

Original text of this message