Databases Reference
In-Depth Information
If we are not successful in convincing the user to finish the transaction, then we'll
have to kill the session. Once the session has been killed the PMON will issue a
rollback action on behalf of the user and the locks held by the oracle server process
will immediately be released.
When talking about users and sessions we regularly think of real users connected
to the database from their applications. The real problem is that most of the modern
applications use a three tiered architecture, and unless there is a means provided by
the application to identify who the real user is and where it is connected from,
the DBA cannot do much to phone the user and kindly ask him/her to finish the
hung transaction.
Search WWH ::
Custom Search