| Computers Forum Index » Computer - Databases - Oracle (Misc) » when client disconnect oracle server abnormally... |
|
Page 1 of 1 |
|
| Author |
Message |
| karim... |
 Posted: Thu Oct 22, 2009 4:20 am |
|
|
|
Guest
|
hello to all.
if i am working in a client side and suddenly lost the connection
between me and oracle server, then what the server do to uncommitted
statements? will the server make auto-commit or rollback.
thanks. |
|
|
| Back to top |
|
|
|
| Mark D Powell... |
| Posted: Thu Oct 22, 2009 1:45 pm |
|
|
|
Guest
|
On Oct 22, 12:20 am, karim <k.haraz... at (no spam) gmail.com> wrote:
Quote: hello to all.
if i am working in a client side and suddenly lost the connection
between me and oracle server, then what the server do to uncommitted
statements? will the server make auto-commit or rollback.
thanks.
If the front-end session suddenly loses its connection to Oracle what
happens depends on what caused the connection loss to begin with and
where the problem occurred: on the database side, in the network
transport, either end OS, or in the front-end application itself, and
on if Oracle recongizes that the front-end went away.
If Oracle recognises the abnormal termination then pmon will clean up
the user Oracle background processing releasing locks and other
resources held. If Oracle does not recognize the front-end loss then
the user session Oracle background process becomes what is known as a
runaway or dead session usually showing as waiting on a response/
request from the client.
There have been numerous thread on dead session detection. There are
Oracle parameters that can be used to terminate these sessions
automatically.
HTH -- Mark D Powell -- |
|
|
| Back to top |
|
|
|
|
