Q

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 first published in September 2005

Dig deeper on Oracle and SQL

Pro+

Features

Enjoy the benefits of Pro+ membership, learn more and join.

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.

0 comments

Oldest 

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to:

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide

SearchDataCenter

SearchContentManagement

SearchFinancialApplications

Close