Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / sawant
Two processes wating to update the rows of a table which
are locked by the other process then deadlock arises.
In a database environment this will often happen because
of not issuing proper row lock commands. Poor design of
front-end application may cause this situation and the
performance of server will reduce drastically.
These locks will be released automatically when a
commit/rollback operation performed or any one of this
processes being killed externally.
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
How to increment dates by 1 in oracle?
What is an oracle transaction?
What is proxy method?
How to login to the server without an instance?
Does oracle database need java?
How to use an explicit cursor without open statements?
How to start instance with a minimal initialization parameter file?
various types of hints and their usage
What are the different windows events activated at runtime ?
What is the relation of a user account and a schema in oracle?
What privilege is needed for a user to query tables in another schema?
what are steps for interface? where is exchange rate defined in which table?
How to retrieve data from an cursor to a record?
What is the parameter mode that can be passed to a procedure?
What is an oracle and why it is used?
