Oracle Performance Tuning Mock Interview
Master 30 Oracle Performance Tuning interview questions covering SQL optimization, indexing strategies, and execution plans.
Question 30 of 30
The ESTAT events report indicates that you are getting busy buffer waits. What method can you use to find out what is causing this?
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.
The interviewer begins this question by making a statement about an event and what it indicates. They then ask a question related to the statement. Describing an issue followed by asking a question is a common format used by interviewers. Normally it is pretty straightforward, but they can also use this format to mislead you. If the scenario is incorrect or not related to the question, they usually expect you to correct them and then provide the appropriate information.
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.
While it is sometimes intimidating to correct the interviewer, it is okay to do this if you are sure that they have made an error, either intentionally or by mistake. If you elect to correct their statement, try to do so in a diplomatic manner to avoid insulting them in case the misstatement was made in error. Indicating that you know something is wrong and how to correct it will demonstrate your qualifications for this position.
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 the ESTAT events report shows that you are getting buffer busy waits, it normally indicates that there is contention in redo, rollback, or data blocks. When this occurs, I check the vwaitstat view to see what may be causing the problem. I look at the value of the 'count' column to see where the problem is and the 'class' column to see what may be causing it. UNDO indicates the issue is related to the rollback segments, and DATA tells me it is in the database buffers.
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 All 30 Oracle Performance Tuning Questions
Unlock expert responses to complex tuning scenarios that database architects evaluate.
Get StartedJump to Question