Oracle Exam 1Z0-084 Topic 1 Question 5 Discussion

Actual exam question for Oracle's 1Z0-084 exam

Question #: 5
Topic #: 1

[All 1Z0-084 Questions]

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

AWhen the allocated budget for performance tuning has been exhausted

BWhen all the concurrency waits are eliminated from the Top 10

CWhen the buffer cache and library cache hit ratio is above 95%

DWhen the I/O is less than 10% of the DB time

Show Suggested Answer

Suggested Answer: A

The right time to stop tuning an Oracle database is often determined by the point of diminishing returns - when the cost of further tuning (in terms of time, resources, or money) exceeds the performance benefits gained. This is often related to the budget allocated for performance tuning.

A (Correct): When the allocated budget for performance tuning has been exhausted, it may be time to stop tuning unless the benefits of further tuning justify requesting additional budget.

B (Incorrect): Eliminating all concurrency waits from the Top 10 is an unrealistic goal since some waits are inevitable and can occur due to application design, which might not be possible to eliminate completely.

C (Incorrect): The buffer cache and library cache hit ratio being above 95% does not necessarily indicate that the database is fully optimized. Hit ratios are not reliable indicators of database performance and should not be used as sole criteria to end tuning efforts.

D (Incorrect): Having I/O less than 10% of DB time is not a definitive indicator to stop tuning. It is essential to consider the overall performance goals and whether they have been met rather than focusing solely on I/O metrics.

Oracle Database Performance Tuning Guide: Introduction to Performance Tuning

Oracle Database 2 Day + Performance Tuning Guide: Understanding the Tuning Process

by Rhea at Apr 14, 2024, 07:57 PM

Limited Time Offer

25%

7 months ago

What do you guys think is the right time to stop tuning an Oracle database?

upvoted 0 times

Jarod

6 months ago

When the buffer cache and library cache hit ratio is above 95%.

upvoted 0 times

...

Jospeh

6 months ago

When the allocated budget for performance tuning has been exhausted.

upvoted 0 times

...

Una

8 months ago

Yeah, no kidding. At the end of the day, I think it comes down to finding the right balance between performance, cost, and stakeholder expectations. And that's not always an easy thing to do.

upvoted 0 times

...

Kenny

8 months ago

Yeah, I agree. It really depends on the specific goals and requirements of the organization, right? I mean, some might be happy with a 95% hit ratio, while others might want to squeeze every last drop of performance out of the system.

upvoted 0 times

...

Novella

8 months ago

This question is pretty tricky. I mean, how do you define the 'right' time to stop tuning? It's not like there's a one-size-fits-all answer, you know?

upvoted 0 times

...