What is a deadlock ? Explain .
- 1 Answers
- 5318 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
Tell me New Feature of Oracle 10g?
Explain index?
What are the roles of dba?
How to handle a single quote in oracle sql?
How do I spool in oracle?
What is meant by recursive hints ?
Which dictionary tables and/or views would you look at to diagnose a locking issue?
What are the components of physical database structure in the Oracle database?
Explain the relationship among Database, Tablespace and Data file?
What are dml statements in oracle?
what is the use of composite key constraint?
How to start your 10g xe server?
Oracle General 
