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
What is a table index in oracle?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is recovery manager in Oracle?
What is backup in Oracle?
Explain oracle’s server parameter file.
How to check the oracle tns settings?
Explain about the analyze command in oracle?
What happens to the data files if a tablespace is dropped?
How to define an anonymous block?
master table and child table performances and comparisons in Oracle ?
State some uses of redo log files?
How to assign a tablespace to a users in oracle?
Explain the use of log option in exp command.
How to convert characters to times in oracle?
What is a schema in oracle?
