单选题Your alert log file has the following information: Tue May 25 17:43: 38 2004 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly?()A
题目
单选题
Your alert log file has the following information: Tue May 25 17:43: 38 2004 ORA-00060: Deadlock detected. More info in file /u01/app/oracle/admin/ORCL/udump/orcl_ora_3173.trc. What would you do to ensure that database is still running correctly?()
A
examine the trace file and kill the session that caused the deadlock
B
examine the trace file and kill both the sessions responsible for the deadlock
C
examine the trace file for details and ask the user who caused the deadlock to rollback the transaction
D
examine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
E
examine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock