Re: Oracle 10g Express Connection Limitations?
Date: Tue, 06 May 2008 15:34:58 +0200
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