Interested to Buy Any Domain ? << Click Here >> for more details...
What is a deadlock in SQL? How can you prevent it?
- 1 Answers
- 2503 Views
- I also Faced
- E-Mail Answers
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 |
I have table-A(1,2,3,4,4,5,6,6,6,7). how to get all duplicate values?what is sql query?
How would you best determine why your MVIEW couldnt FAST REFRESH?
How to define a specific record type?
what are indexes..how many types of index's are there and what are they?
7 Answers Green Info Solutions, TCS,
How to create a table interactively?
Name the three major set of files on disk that compose a database in Oracle?
What is a parameter file in oracle?
How to connect to the server with user account: sys?
I have my backup RMAN script called backup_rman.sh. I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the O/S such that it would run as a background process?
How to create a new view in oracle?
what's query optimization and without use of IN AND Exist can we get another way data from query
How to run queries on external tables?
Oracle General 
