Problem solve Get help with specific problems with your technologies, process and projects.

Too many buffer reads

What is the root cause of high buffer gets if there is no table full scan?

I have Oracle version 9.2 with cost-based optimizer. Statistics are collected frequently. The query is tuned perfectly. My problem is that performance is slow and shows too many buffer reads in statspack. What is the root cause of high buffer gets if there is no table full scan? Please help.
Your statspack report will show you the SQL statement associated with a high number of buffer gets. Examine the optimizer plan for this query to understand the reasons for them. It may be that the query is not "perfectly tuned"; your goal should be to reduce logical I/Os. Tracing the SQL in question can also help you identify the source of excessive buffer gets.
This was last published in September 2005

Dig Deeper on Oracle and SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Please create a username to comment.