Remote Sequence is not releasing the connection 2005-02-10 - By Subbiah, Nagarajan
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@(protected)]
Sent: Tuesday, February 08, 2005 5:29 PM
To: 'oracle-l@(protected)'
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 (See ORA-01000.ora-code.com) 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
|
|
