Re: Database Link Resources

"Stu" <stuart.weitzman_at_nordstrom.com> a écrit dans le message de news:c6b92c47.0401091220.1903d9ad_at_posting.google.com...
> Hello All,
>
> We're working on a fairly complex situation here and I was hoping for
> a little outside knowlede on Database Links.
>
> We're connecting to one database using WebLogic. Within the
> application, we make a call to a stored procedure that is located
> within another database. This is done via the DBLink.
>
> What's happening is that we are running out of resources in the second
> DB.
>
> The first db (WebLogic) allows up to 130 connections, while the second
> only has the ability to allow up to 20. It seem that once the
> connection is made via the link, it is not released until the
> connection is closed to the MAIN DB. Since connection pooling is on
> there... Well, we're basically losing connectivit on the second pretty
> quickly.
>
> Weblogic, of course, says to access the DB's directly using JDBC, and
> NOT to use the link (not an option for us due to security reasons).
>
> Any other ideas out there??
>
> Thanks,
> Stu

alter session close database link 'dblink';

Hth
Michel Cadot Received on Fri Jan 09 2004 - 15:17:54 CST