What do you mean by a deadlock?
Answer / Narander Singh
A deadlock is a situation that occurs in concurrent programming, including databases like Oracle, where two or more processes are blocked and waiting for each other to release resources required for progress. This usually happens when one process holds a resource needed by another process, while the second process holds a resource needed by the first. As both processes wait for the other to release resources, they remain in an infinite loop, leading to a deadlock.
| Is This Answer Correct ? | 0 Yes | 0 No |
How to calculate date and time differences in oracle?
Why use resource manager in Oracle?
Explain a private synonyms?
How to display First 4 rows From Database Table?
Can we store pictures in the database and if so, how it can be done?
Does oracle partitioning improve performance?
How to recover a dropped index?
What is a Synonym ?
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 are the advantages of running a database in archive log mode?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
What is sequence?