Author(s): JIANG Wen, LIU Li-kang
Pages: 97-101
Year: 2014 Issue:  3
Journal: Computer Technology and Development
Keyword:  Oracle database; database locks; deadlock;
Abstract: The database is a shared resource of multi-user in network environment,database deadlock phenomenon is likely to occur in multi-threaded process by large amounts of data access. Introduce the Oracle database locking mechanism and the causes the deadlock oc-curs,the Oracle database detects the related views deadlock uses. A detailed description is conducted for the SQL states the deadlock de-tection,the positioning method of deadlock and the resolution of the database deadlock. Compiled the deadlock detection script in the Linux environment,simulate the Oracle database deadlock to test the correctness of the script. Practical application shows that the script can be effective monitoring whether the program's main module is deadlock or not,with simplicity and effectiveness.