Re: Too many oracle connections by using MS Data Access layer DAL
Tech-Archive recommends: Fix windows errors by optimizing your registry
Date: Fri, 20 Feb 2004 16:39:13 -0600
Try calling Dispose on you dbCommand/Reader objects.
If you have them in a tight loop they don't get GC quick enough.
This worked for me.
Schneider
"Bahl" <anonymous@discussions.microsoft.com> wrote in message
news:CD8C8E5D-8DEC-49F9-B89C-C52349C357A8@microsoft.com...
> I am using Microsoft Application Data Application layer for Oracle to
build multi tier web application.
> I am running into this problem of too many oracle connections opened by
this DAL layer. I know DAL uses connection pooling but still there are too
many connections open and application is being kicked out of oracle.
>
> Any suggestions ?
>
> Bahl
Relevant Pages
- Re: Effect of listener on existing connections?
... Oracle support is not giving us satisfactory results. ... and attempts to create new connections are ... We also see these messages appearing with regularity in our listener ... how does a blocked listener explain the fact that apps with existing ...
(comp.databases.oracle.server) - Re: Multiple Oracle clients in same code - no usernames needed
... You might get away with this with an 9 client and if memory serves me ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
(perl.dbi.users) - Re: Multiple Oracle clients in same code - no usernames needed
... You might get away with this with an 9 client and if memory serves me correctly it can connect both wallet and the old 8 way ... In all cases the connections have to 'external' - No name or password ... The mechanism changed to the Oracle wallet in 10 for external ... the 2 oracle client libs will export a lot of the same ...
(perl.dbi.users) - Re: Effect of listener on existing connections?
... Solaris 10 inside a ZFS zone (our previous system was Oracle ... and attempts to create new connections are ... issue of the listener locking up if you're not using ONS. ... how does a blocked listener explain the fact that apps with existing ...
(comp.databases.oracle.server) - Connection delays causing problems.
... ORACLE connections sometimes take tens of seconds to come ... This is true whether the connection is via sqlplus, ACCELL ... Over 150 clients running ACCELL applications. ...
(comp.databases.oracle.server) |
|
