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?()
- Aexamine the trace file and kill the session that caused the deadlock
- Bexamine the trace file and kill both the sessions responsible for the deadlock
- Cexamine the trace file for details and ask the user who caused the deadlock to roll back the transaction
- Dexamine the trace file for details and remember that deadlocks are resolved automatically by Oracle database
- Eexamine the trace file for details and use the Undo Advisor to rollback the transaction that caused the deadlock