Answer Posted / hr@tgksolutions.com
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 |
Post New Answer View All Answers
Does oracle charge for java?
What is a user account in oracle?
How to create a testing table in oracle?
Respected sir, Please send me technical questions related to oracle apps..
How do I manually create a database in oracle?
What is hash cluster in oracle?
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
hello friends Im doing my final year engineering in B.Tech.. one of uncle said he can provide job in his company if im good in database management. but i have only basic knowledge about database, so like to join database management course in good intuition. so friends kindly help me to get good intuition because its my future.
How many anonymous blocks can be defined?
hey friends, What are the steps I can do to transfer the database from Microsoft Access 2003 to oracle10g (or SQL) Best regards
What are the arithmetic operations?
Difference between pre-select and pre-query
What privilege is needed for a user to create views in oracle?
Explain user account with reference to oracle.
How to turn on or off recycle bin for the instance?