What Causes Blocking Sessions in Oracle
Blocking Sessions Occur When a Session Issues an Insert, Update or Delete Command That Changes a Row. When the Change Occurs, the Row Is Locked Until the...
Blocking sessions occur when a session issues an insert, update or delete command that changes a row. When the change occurs, the row is locked until the session either commits the change, rolls the change back or the user logs off the system.
Why session is locked in Oracle?
Oracle enqueue waits indicate that a seesion is waiting for a lock that is held by another user (or sessions). … In Oracle databases, many users may update the same information at roughly the same time. Locking allows one user to update data at a given moment so that another person cannot modify the same data.
Must Read
Can a select statement cause blocking Oracle?
So yes, a SELECT can create a lock that others have to wait for.
Maya is a hardware enthusiast who tests and reviews smart home devices, smartphones, wearables, and audio gear. She focuses on practical consumer value and build quality.
