Master 30 Oracle Performance Tuning interview questions covering SQL optimization, indexing strategies, and execution plans.
Question 28 of 30
Why the Interviewer Asks This Question
How to Answer
Example Answer
Community Answers

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
This is another two-part question. The first part asks you what information the hit ratio provides in a specific context. The second is an operational question asking how you go about tuning the database based on the hit ratio information. The interviewer is testing both your knowledge of the technology and your ability to complete the operation needed to optimize the database.

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
When asked a two-part question, you should respond similarly. Start by answering the first part, then answer the second part of the question. As with any technical or operational question, your answer should be brief and to the point. You should also anticipate follow-up questions from the interviewer.

William Swansen has worked in the employment assistance realm since 2007. He is an author, job search strategist, and career advisor who helps individuals worldwide and in various professions to find their ideal careers.
"In the context of database buffers, the hit ratio provides information about how many times the database could read a value from the buffers instead of how many times it had to re-read a data value from the disks. The higher the percentage of reads from the buffers, the better the database performs. Anything less than 80% buffer reads indicates that there is a problem. A hit ratio of existing parameters is a cumulative value since the database started. It is not as accurate as the instantaneous hit ratio, which compares pairs of readings based on a designated time span. I prefer the instantaneous hit ratio for tuning since it provides more valuable data by indicating what the instance is doing over the time it was generated."

Interview Coach
Jaymie
A real coach, not AI. I read every answer myself and write back with personalized feedback.
Typically responds within 24 hours.
0 - Character Count
Unlock expert responses to complex tuning scenarios that database architects evaluate.
Get StartedJump to Question

Written by William Swansen
30 Questions & Answers • Oracle Performance Tuning

By William

By William