Re: Oracle 10g Express Connection Limitations?

From: yossarian <yossarian99_at_operamail.com>
Date: Tue, 06 May 2008 15:34:58 +0200
Message-ID: <48205e82$0$29985$5fc30a8@news.tiscali.it>


Jason D. wrote:

> I used Oracle 10g XE a lot last summer and will likely be using it
> again this summer. My database is essentially for experiment purposes
> and most connections to it are VIA ODBC. I noticed last year after so
> many (like 20 perhaps? I'm not sure an exact number) sequential ODBC
> connections (that is connect and disconnect, the connections were
> *not* concurrent) XE would suddenly refuse more anymore connections
> until I restarted the service (running Windows XP). I thought this
> might be a limitation of XE but I can't find any documentation on it
> as a limitation, so that's making me think it might have been a
> problem with my setup. Are there any suggestions on what might be
> causing this?

Keep the V$SESSION dictionary table monitored and you will find out that the ODBC app doesn't really close the database session.

Y. Received on Tue May 06 2008 - 08:34:58 CDT

Original text of this message