Oracle Database Administration II — Question 79
Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?
Answer options
- A. SQL statements
- B. log writer performance
- C. general operating system health
- D. database writer performance
- E. database instance memory management and sizes
Correct answer: C
Explanation
The correct answer is C, as ensuring the general health of the operating system is crucial before tuning other components. If the operating system is not performing well, it can significantly impact the database performance, regardless of how well SQL statements or memory management are tuned. Other options like log writer performance or database writer performance are secondary adjustments that depend on the operating system's stability.