RE: ORA-02020: too many database links in use
From: Powell, Mark <mark.powell2_at_hp.com>
Date: Mon, 25 Jan 2010 17:27:25 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415933A5F9B4DC3_at_GVW1337EXC.americas.hpqcorp.net>
Please see the following:
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: Friday, January 22, 2010 5:01 PM
To: oracle-l_at_freelists.org
Subject: ORA-02020: too many database links in use
Date: Mon, 25 Jan 2010 17:27:25 +0000
Message-ID: <7C4BF3B32B80CC44AE37D31B172415933A5F9B4DC3_at_GVW1337EXC.americas.hpqcorp.net>
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_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Roger Xu Sent: Friday, January 22, 2010 5:01 PM
To: oracle-l_at_freelists.org
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
-- http://www.freelists.org/webpage/oracle-lReceived on Mon Jan 25 2010 - 11:27:25 CST