Re: Max DB connections Oracle XE
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-lReceived on Wed Jan 30 2008 - 12:09:02 CST