First page Back Continue Last page Graphics

Continuation of Notes


Notes:

Update table B from session 2:
session2> update b set c1 = 'x';

1 row updated.

Attempt to update table A from session 2. The session should wait:
session2> update a set c1 = 'x' ;
-- This session is now blocked by session 1

Attempt to update table B from session 1. A deadlock will occur and one of the sessions will receive a ORA-00600 error.
session1> update b set c1 = 'x';
update b set c1 = 'x'
*
ERROR at line 1:
ORA-00060: deadlock detected while waiting for resource

session2> update a set c1 = 'x' ;
Q. What happened to the session that did not receive the error?
Execute a ROLLBACK from the session that received the ORA-00600.
session1> rollback;

Rollback complete.
Q. What happen to the blocked session?
Q. What action should you perform on the session that just freed?