Archive for

On Database Deadlock, Foreign Key, and Indexing

This is in 11g database. A database deadlock is a situation in which two user sessions are waiting for data locked by each other. Oracle database automatically detects deadlocks and resolves them by rolling back one statement involved in the deadlock, release one set of the conflicting row locks. The statement rolled back belongs to … Continue reading