ORA-02020: too many database links in use

From: Roger Xu <wellmetus@xxxxxxxxx>
To: oracle-l@xxxxxxxxxxxxx
Date: Fri, 22 Jan 2010 16:00:47 -0600

We are getting this error and I know I need to increase open_links parameter
which requires recycling the instance. My question is - how to find out all
open dblinks so I can kill some sessions which are holding dblinks?
(V$DBLINK lists all open database links in the current session.) Thanks,
Roger

Follow-Ups:

RE: ORA-02020: too many database links in use
From: Powell, Mark

Re: ORA-02020: too many database links in use
From: Jared Still

Other related posts:

» ORA-02020: too many database links in use - Roger Xu
» RE: ORA-02020: too many database links in use - Powell, Mark
» Re: ORA-02020: too many database links in use - Jared Still
» Re: ORA-02020: too many database links in use - Roger Xu
» Re: ORA-02020: too many database links in use - Jared Still

Browse oracle-l