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
What is oracle rowcount?
How data locks are respected in oracle?
What is blob data type in oracle?
How to sort the query output in oracle?
What is connection pooling in oracle?
How to use fetch statement in a loop?
you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz
how to handle exceptions in post production
How many file formats are supported to export data?
How to define a variable of a specific record type?
What is rowid and rownum in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
Explain the use of ignore option in imp command.
Explain the use of rows option in imp command.
How to write an inner join with the where clause in oracle?