Categories:
.NET (357)
C (330)
C++ (183)
CSS (84)
DBA (2)
General (7)
HTML (4)
Java (574)
JavaScript (106)
JSP (66)
Oracle (114)
Perl (46)
Perl (1)
PHP (1)
PL/SQL (1)
RSS (51)
Software QA (13)
SQL Server (1)
Windows (1)
XHTML (173)
Other Resources:
How Oracle Handles Dead Locks
How Oracle Handles Dead Locks? - Oracle DBA FAQ - Understanding SQL Transaction Management
✍: FYIcenter.com
Oracle server automatically detects dead locks. When a dead lock is detected, Oracle server will select a victim transaction, and fail its statement that is blocked in the dead lock to break the dead lock. The tutorial exercise below shows you an example of statements failed by Oracle server because of dead locks:
(session 1) SQL> connect HR/fyicenter SQL> UPDATE fyi_links SET notes='Session 1' WHERE id=101; 1 row updated. (session 2) SQL> connect HR/fyicenter SQL> UPDATE fyi_links SET notes='Session 2' WHERE id=110; 1 row updated. SQL> UPDATE fyi_links SET notes='Session 2' WHERE id=101; (blocked by lock id=101) SQL> UPDATE fyi_links SET notes='Session 1' WHERE id=110; (blocked by lock on row id=110) ORA-00060: deadlock detected while waiting for resource (statement failed)
2007-04-17, 6514👍, 0💬
Popular Posts:
How To Increment Dates by 1? - MySQL FAQs - Introduction to SQL Date and Time Handling If you have a...
If locking is not implemented what issues can occur? IFollowing are the problems that occur if you d...
How can you enable automatic paging in DataGrid ? Following are the points to be done in order to en...
What is a delegate ? Delegate is a class that can hold a reference to a method or a function. Delega...
What is difference between ADPATCH and OPATCH ? # ADPATCH is utility to apply ORACLE application Pat...