ORA-02020: too many database links in use
From: Roger Xu <wellmetus_at_gmail.com>
Date: Fri, 22 Jan 2010 16:00:47 -0600
Message-ID: <eb64345d1001221400m73654c7dx219a41111c1819f9_at_mail.gmail.com>
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
Date: Fri, 22 Jan 2010 16:00:47 -0600
Message-ID: <eb64345d1001221400m73654c7dx219a41111c1819f9_at_mail.gmail.com>
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 Fri Jan 22 2010 - 16:00:47 CST