What is a deadlock ? Explain .
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 |
What is redo log?
How to increment dates by 1 in oracle?
What are the database administrators utilities available?
Explain the use of grant option in imp command.
what is data independence exactly? give an example
hi friends i completed b.com 2004.i have 3y accounting exp. in manufacturing company.now i have completed oracle finance.pls suggest me how will get job in oracle.can i get job in oracle.
Is oracle an open source?
How to define an explicit cursor in oracle?
What is the difference between alert log file and tarce file ?
If server is in US and client is in india there is timezone is diffrence, How can we display date in indian time when data is displayed from US server timezone?
What is the difference between a hot backup and a cold backup in oracle?
Why do I get unexpected characters from 8-bit character sets in weblogic jdriver for oracle?