Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 2502 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 |
State and explain about oracle instance?
What are the restrictions in a oracle read only transaction?
How to do a full database export?
Who i will insert 1 lacks record in a Database table
how to find the second highest salary in a given table????
What are temporal data types in oracle?
Suppose U install the oracle DB either enterprise edition or express edition in ur personal PC, Is there the Database has been created after ur installation if not then where the oracle's all objects with data be stored?
If youre unsure in which script a sys or system-owned object is created, but you know its in a script from a specific directory, what UNIX command from that directory structure can you run to find your answer?
How can Oracle users be audited?
How to install oracle database 10g xe?
What is a recycle bin in oracle?
can u send the sql dumps to sivakumarr1987@gmail.com plz help me
Oracle General 
