RE: Remote Sequence is not releasing the connection

This issue is resolved. Thanks.

A select over the dblink is opening cursors in the remote db.. But they are not being closed even after a COMMIT or a ROLLBACK.

THe cursors are closed only when the dblink is closed explicitly using

ALTER SESSION CLOSE DATABASE LINK dblink_name;

or Exec DBMS_SESSION.CLOSE_DATABASE_LINK('dblink');

Raja

-----Original Message-----

From: Subbiah, Nagarajan [mailto:Nagarajan.Subbiah_at_aetn.com] Sent: Tuesday, February 08, 2005 5:29 PM To: 'oracle-l_at_freelists.org'
Subject: Remote Sequence is not releasing the connection

We have a synonym in local database for a sequence, which is in remote database. After selecting the nextval from the local database, there is a session opened in the remote database but not closing the session after the 'select' is completed. . We are at HP11.11 and Oracle 9.2.0.5. Over the period of time, it gives the "ORA-01000 number of open cursors exceeded" error. Open cursors value was increased to triple the value but still the problem persists. Any idea is this a bug or missing any configuration. If the synonym is dropped and actual sequence is created in the local database, then there are no issues.  

Raja
Ph: (212) 210 1461  

--

http://www.freelists.org/webpage/oracle-l
--

http://www.freelists.org/webpage/oracle-l Received on Thu Feb 10 2005 - 12:56:35 CST