are these INACTIVE session hogging the DBLINK ?

[maxzsim]

Hi ,

I am using PL/SQL Deverloper ver 7.0

From Tools --> sessions , i could see many INACTIVE sessions

let's say if i have been executing SQLs via DBLinks , once i close the Windows , it seems to become INACTIVE but does it still consider as one dblink ? as i have "too many dblinks" issue

how can i elegantly prevent the INACTIVE sessions from surfacing after running a procedure/SQLs ?

pls advise

 

[Marco van der Linden]

Have you tried issueing commit or rollback after running the SQL? As long as you haven't, Oracle considers the transaction to be 'Open' since it doesn't know what has happened 'on the other side' of the DB Link.

 

[ed10k]

You can try:
1. ALTER SESSION CLOSE DATABASE LINK ;
2. Or at PL/SQL Deverloper menu-session-kill

 

[maxzsim]

tk you ppl