1Z0-083 practice question 25 of 35

Choose the best. Which should be tuned first when doing a performance tuning exercise for an Oracle Database environment?

Full set: 286 questions
Answer options
A:

A. log writer performance

B:

B. database writer performance

C:

C. general operating system health

Correct answer
D:

D. SQL statements

E:

E. database instance memory management and sizes

Correct Answer:
C. C. general operating system health
Explanation

According to Oracle's standard performance tuning methodology, the first step after defining the problem is to establish a performance baseline and examine the host system. This involves checking the general operating system health for issues like CPU starvation, memory swapping, or I/O bottlenecks. Tuning SQL statements or the database instance is ineffective if the underlying operating system is unstable or improperly configured. A healthy OS is the foundation upon which database performance is built, making it the logical starting point for any tuning exercise.

Why Incorrect

A. Log writer performance is a component of instance tuning, which should be addressed after higher-level application and SQL tuning.
B. Database writer performance is part of instance tuning and is typically addressed after confirming the OS and application are tuned.
D. While SQL tuning often yields the largest performance gains, it should be performed after verifying the underlying OS is healthy.
E. Database instance memory management is a form of instance tuning, which follows application/SQL tuning in the standard methodology.

References

1. Oracle® Database Performance Tuning Guide 19c, Chapter 3, "Performance Tuning Methodology". The guide outlines a reactive methodology that includes "Step 2: Examine the Host System" as a crucial early step. This involves using OS utilities to check for hardware resource exhaustion before analyzing the database itself.

Scroll to Top