A deadlock is a condition where two or more users are waiting for data locked by each other. Oracle automatically detects a deadlock and resolves them by rolling back one of the statements involved in
Latest Answer : Deadlock occurs when two or more users are waiting for data locked by each other. When this happens, these users are stuck (deadly embraced) and cannot continue processing. Oracle automatically detects deadlocks and resolves them by rolling back ...
Two processes wating to update the rows of a table which are locked by the other process then deadlock arises. In a database environment this will often happen
Latest Answer : Oracle automatically detect deadlock , but not occar ...
Describe four properties of database isolation. In which situation lock contention will happen. What is transaction lock?
If one user is already updating the table and it has a lock, the other user cannot access the table to update. then why and how the deadlock situation arises ?please explain with example.
In which situation whether peak time or off peak time you will execute the ANALYZE TABLE command. Why?
Latest Answer : Gathering statistics can be very resource intensive for the server so avoid peak workload times to gather stale stats or Analyze Table . ...
