Performance Tuning - Question 101

Where can you find the nondefault parameters when the instance is started?

A. Alert log

B. Online redo log

C. Archiver redo log

D. SYSTEM user’s trace file

Answer: A

Explanation:

Alert log file shows the nondefault parameters when the instance is started.

Incorrect Answers

B: Online redo log is not used to store this information.

C: Archive redo log is just archived copy of online redo log. It does not have any information about nondefault parameters.

D: SYSTEM’s user’s trace file is not used to provide this information.

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

Chapter 2: Sources of Tuning Information