Blocked dblink sessions
I'm running a web-site backend database with oracle XE and many other remote db's (all of them are
10gR2 Standard or Enterprise) are syncronizing their schemas on this machine via dblink via
bi-directional insert/select statements.
The syncronize procedure is run every 5 minutes on the "remote" databases without any problem.
When a network error happens during a syncronization, sometimes the remote session remains busy
with the event "SQL*Net message from dblink" (for days...) and even killing it no other session is
able to use the (network-restored) dblink until a shutdown.
Is there a way or special syntax to make the session expire/timeout to avoid the shutdown?
10gR2 Standard or Enterprise) are syncronizing their schemas on this machine via dblink via
bi-directional insert/select statements.
The syncronize procedure is run every 5 minutes on the "remote" databases without any problem.
When a network error happens during a syncronization, sometimes the remote session remains busy
with the event "SQL*Net message from dblink" (for days...) and even killing it no other session is
able to use the (network-restored) dblink until a shutdown.
Is there a way or special syntax to make the session expire/timeout to avoid the shutdown?
0