Oracle Database Administration 2022 Certified Professional — Question 3

What is the right time to stop tuning an Oracle database?

Answer options

• A. When the allocated budget for performance tuning has been exhausted
• B. When all the concurrency waits are eliminated from the Top 10
• C. When the buffer cache and library cache hit ratio is above 95%
• D. When the I/O is less than 10% of the DB time
• E. When the tuning goal has been met

Correct answer: E

Explanation

The correct answer is E because tuning is considered complete when the specific performance goals set at the beginning are met. The other options may indicate improvements or conditions but do not necessarily signify that the overall tuning objectives have been achieved.