Performance Tuning - Question 112

Which initialization parameter specifies the location of the alert log file?

A. UTL_FILE_DIR

B. USER_DUMP_DEST

C. LOG_ARCHIVE_DEST

D. BACKGROUND_DUMP_DEST

Answer: D

Explanation:

BACKGROUND_DUMP_DEST initialization parameter specifies the location of the alert log file.

Incorrect Answers

A: UTL_FILE_DIR lets you specify one or more directories that Oracle should use for PL/SQL file I/O.

B: USER_DUMP_DEST is used to specify the location of user trace files.

C: LOG_ARCHIVE_DEST shows the directory for the archived redo logs.

OCP: Oracle 9i Performance Tuning Study Guide, Joseph C. Johnson, p. 40-41

Chapter 2: Sources of Tuning Information