Why and how the deadlock situation arises.

Why and how the deadlock situation arises?

- A deadlock situation arises when two or more users wait for the same resource locked by one anther or two or more processes wait to update rows which are locked by other processes.

- If Oracle detects a deadlock, rolls back the session chosen by the deadlock victim.

- The deadlocks are usually resolved by RDBMS.

- Some of the common types of deadlock are ORA-00060 (enqueue deadlock) and ORA-04020 (library cache deadlock).

- It can also be resolved manually by the oracle interface.

- IBM DB2 runs a background process called the deadlock detector.

- Another way can be by the LOCK_TIMEOUT for the session.

- It can even be done by setting the DEADLOCK_PRIORITY within the session:
SET DEADLOCK_PRIORITY LOW
50 Oracle 11g dba Interview Questions and Answers - Freshers, Experienced
Oracle 11g dba interview questions and answers for both freshers and experienced - DBMS Introduction, ORACLE ARCHITECTURE, ORACLE Installation, Oracle Environment Variables, Managing physical structures (control files, data files, redo log files), Backup and Recovery, RMAN, Performance Tuning, Data Guard.
What is large object in oracle? Explain its purposes
Large objects (LOB’s) are exclusively used to hold large amounts of data. It can hold data in tetra bytes.......
Types of large objects in oracle
BLOBs, CLOBs, and NCLOBs are Internal LOBs stored inside database tablespaces to optimize space and efficient access......
Post your comment