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 many types of synonyms in Oracle?
Can multiple cursors being opened at the same time?
What is the difference between "as" and "is" in an oracle stored procedure?
There are n numbers of flatfile of exactly same format are placed in a folder.Can we load these flatfile's data one by one to a single relational table by a single session??
How do I uninstall oracle client from windows?
How to count groups returned with the group by clause in oracle?
How to work with data objects interactively?
Which is better Oracle or MS SQL? Why?
How to do paging with oracle?
How many file formats are supported to export data?
what are actual and formal parameters?
How to get a list of all user accounts in the database?
How to resolve name conflicts between variables and columns?
What is the difference between sharding and partitioning?
What is the difference between a user and a schema in oracle?
