Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 3560 Views
- I also Faced
- E-Mail Answers
A deadlock occurs when two or more transactions hold locks that the other needs, causing them to wait indefinitely.
Ways to prevent deadlocks:
• Use consistent lock ordering.
• Keep transactions short and fast.
• Use lower isolation levels when possible.
• Implement deadlock detection mechanisms.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is Database Link ?
What is a schema in oracle?
How to select all columns of all rows from a table in oracle?
How do you recover a datafile that has not been physically been backed up since its creation and has been deleted. Provide syntax example.
What is Data Block ?
I'm doing my final year and i ve planned to do an oracle certification , is this the rit tim nd wat's the future scope??
What is define in oracle?
Who i will insert 1 lacks record in a Database table
how to clone 9i Database on to 10g Database.
What is logical backup in oracle?
What is the difference between an Oracle Schema and an Oracle Instance?
What is an oracle wallet?
Oracle General 
