Will Oracle notice at any time that that occupied processes do not have a client anymore or will s
Hi All,The problem is
Connecting to a remote database, the amount of ora processes
on the remote system that is running the database server, is increased
by 1.
If the local process, that connected to the remote database,
terminates due to a SIGKILL, the amount of ora processes
on the remote system does not always decrease.
If connecting again, a further ora process is started on the remote DB server.
So the process of the first connection seems to keep running unused.
steps:
- install a pl/sql procedure on the remote DB, that does nothing
else than executing an infinite loop (to simulate a pl/sql procedure
Connecting to a remote database, the amount of ora processes
on the remote system that is running the database server, is increased
by 1.
If the local process, that connected to the remote database,
terminates due to a SIGKILL, the amount of ora processes
on the remote system does not always decrease.
If connecting again, a further ora process is started on the remote DB server.
So the process of the first connection seems to keep running unused.
steps:
- install a pl/sql procedure on the remote DB, that does nothing
else than executing an infinite loop (to simulate a pl/sql procedure
0