RE: ORA-02020: too many database links in use

From: Powell, Mark <>
Date: Mon, 25 Jan 2010 17:27:25 +0000
Message-ID: <>

Please see the following:

How do I find distributed queries / transactions (either issued from or connecting to this instance)?

From: [] On Behalf Of Roger Xu Sent: Friday, January 22, 2010 5:01 PM
Subject: ORA-02020: too many database links in use

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

Received on Mon Jan 25 2010 - 11:27:25 CST

Original text of this message