Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 3180 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 |
difference between oracle8i and oracle9i
What is an oracle transaction?
Why oracle is used?
How do I limit the number of rows returned by an oracle query after ordering?
How to get execution statistics reports on query statements?
What is the difference between Outer join and Full outer join?
What is system tablespace?
How to lock and unlock a user account in oracle?
How do I reset a sequence in oracle?
What do the 9i dbms_standard.sql_txt() and dbms_standard.sql_text() procedures do?
Can we store pictures in the database and if so, how it can be done?
What is where clause in oracle?
Oracle General 
