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 SQL access advisor 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.
How to define an external table with a text file?
What is ADDM Advisor in Oracle?
What is a relational database management system?
How do I uninstall oracle client from windows?
How to use "while" statements in oracle?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
What is a package ? What are the advantages of package ?
What is save point in oracle database?
What are the oracle built-in data types?
What is materialized view in Oracle?
What is oracle datasource?
Who developed oracle & when?
