<div>
you can use <br />
<br />
ALTER SESSION CLOSE DATABASE LINK &lt;name&gt;;<br />
<br />
or <br />
<br />
DBMS_SESSION.CLOSE_DATABAS<wbr />E_LINK ( dblink VARCHAR2);<br />
<br />
Refer to the url below :<br />
<br />
<a href="http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_sessi2.htm#1002316" rel="ugc nofollow">http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_sessi2.htm#1002316</a><br />
<br />
in this url , search for 'This procedure closes an open database' and read the information given there.<br />
<br />
Thanks<br />
<br />

</div>


you can use

ALTER SESSION CLOSE DATABASE LINK <name>;

or

DBMS_SESSION.CLOSE_DATABASE_LINK ( dblink VARCHAR2);

Refer to the url below :

http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_sessi2.htm#1002316 [http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/d_sessi2.htm#1002316]

in this url , search for 'This procedure closes an open database' and read the information given there.

Thanks



<div>
Hi will Dead Connection detection would be helpful?<br />
<br />
Try setting sqlnet.expire_time ( in sqlnet.ora) and try
</div>


Hi will Dead Connection detection would be helpful?

Try setting sqlnet.expire_time ( in sqlnet.ora) and try

<div>
i think i have given the correct solution but no response.
</div>


i think i have given the correct solution but no response.

<div>
<div class="content wysiwyg-content">
SAP &nbsp;program(DB: ORACLE 9.2.0.7) using DBLINK to access remote ORACLE DB(10.2.0.1).<br />
After SAP progarm end, the dblink session (in remote db) is still alive.<br />
Why? How to correct it ?<br />
Please help ,thanks a lot!<br />

</div>
</div>


SAP  program(DB: ORACLE 9.2.0.7) using DBLINK to access remote ORACLE DB(10.2.0.1).
After SAP progarm end, the dblink session (in remote db) is still alive.
Why? How to correct it ?
Please help ,thanks a lot!


DBLINK session can't be automatically closed ?

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.