Com the power of knowing 1z0 024 to prevent the

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: m and determine how Actualtests.com - The Power of Knowing 1Z0-024 to prevent the deadlock from occurring again? A. Performance manager. B. ORA 000600 error message. C. The resulting trace file. Answer: C Explanation: The resulting trace file should be used to diagnose the problem and determine how to prevent the deadlock from occurring again in the future. When Oracle's deadlock detection mechanisms discover a deadlocking situation on the database, they write a message to the ALERT lo for the Oracle instance. The DBA should take note of the "deadlock detected while waiting for a resource" error messages, and any included process information from the ALERT log sent to assist the DBA in determining the cause of the deadlock. Incorrect Answers: A: Performance manager will not help to diagnose deadlock situation in the Oracle database. B: ORA 00600 error message may be related with deadlock, but not in all cases, so this indicator cannot be used for deadlock diagnose. Oracle 8, DBA Certification Exam Guide, Jason S. Couchman, p. 942-945. Chapter 20: Tuning Other Areas of the Oracle Database QUESTION 53: When the archive process encounters an error, which parameter determines the directory where trace files are written? A. UTL_FILE_DIR B. CORE_DUMP_DEST C. LOG_ARCHIVE_DEST D. BACKGROUUND_DUMP_DEST Answer: D Explanation: BACKGROUND_DUMP_DEST parameter determines the directory where trace file will be written when the archive process encounters an error. The location of your ALERT log and background trace files depends on the directory specified for the BACKGROUND_DUMP_DEST parameter for your instance. Both the background process trace files and the ALERT log will be found in this directory. Incorrect Answers: A: UTL_FILE_DIR parameter represents directory for different purpose, not for background processes trace files. B: CORE_DUMP_DEST parameter shows directory for core files, not for trace files. C: LOG_ARCHIVE_DESC directory is used for archived redo log files. Actualtests.com - The Power of Knowing 1Z0-024 Oracle 8,...
View Full Document

This document was uploaded on 03/08/2014.

Ask a homework question - tutors are online