Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to display row numbers with the records?
What is a nested table?
How to grant create session privilege to a user in oracle?
What happens if you set the sga too low in oracle?
How to join two tables in a single query using oracle?
How can I create database in oracle?
what happened to the global index when I truncate the data in one of the partition?
i wrote a pl/sql procedure. it must run every sunday 4.40 How can i schedule it with the help of dbms_jobs (or another other procedure with out creating bat file,exe file)
What are transaction isolation levels supported by oracle?
How to connect to oracle using service name instead of sid?
What is a system tablespace and when it is created?
Explain the use of analyse option in exp command.
How to define an oracle cursor variable?
What is a proxy class?
How to resolve the ORA-39133 error in Oracle?
