Database links remain open until the client session closes them or until the client session exits. You can use: Alter session close database link 'link_name'; You must commit or rollback before closing the link. Otherwise you cannot close it. -----Original Message----- From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Subbiah, Nagarajan Sent: Wednesday, February 09, 2005 12:29 AM To: 'oracle-l@xxxxxxxxxxxxx' 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. =20 Raja Ph: (212) 210 1461 =20 -- //www.freelists.org/webpage/oracle-l -- //www.freelists.org/webpage/oracle-l