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
Where are the settings stored for each instance in oracle?
What is PL/SQL ?
What happens to the indexes if a table is recovered?
I have a parent program and a child program. I want to write a statement in Exception Block of the parent program so that when the statement in the exception block is executed, the control goes to the next statement in the parent block bypassing the child block.How do i do that?
How many types of segments in Oracle?
What are oracle functions?
What do you mean by merge in oracle and how can you merge two tables?
What is meant by joins?
How to load data from external tables to regular tables?
How many categories of data types in oracle?
How much memory your 10g xe server is using?
What is a table in oracle?
Please explain oracle left join with an example?
If any one has information regarding interview of NIC (National Informatics Centre),it would be of great help...
Please explain joins in oracle?
