by yossarian <yossarian99@[EMAIL PROTECTED]
>
May 6, 2008 at 03:34 PM
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 do***entation 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.
