RE: Remote Sequence is not releasing the connection
- From: "Yasin Baskan" <yasbs@xxxxxxxxxxxxxx>
- To: <Nagarajan.Subbiah@xxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 9 Feb 2005 11:36:58 +0200
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
Other related posts:
