RE: ORA-02020: too many database links in use
- From: "Powell, Mark" <mark.powell2@xxxxxx>
- To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 25 Jan 2010 17:27:25 +0000
Please see the following:
How do I find distributed queries / transactions (either issued from or
connecting to this instance)? http://www.jlcomp.demon.co.uk/faq/find_dist.html
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Roger Xu
Sent: Friday, January 22, 2010 5:01 PM
To: oracle-l@xxxxxxxxxxxxx
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
Other related posts:
