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

Will queries run slower in a smaller Oracle buffer cache?

Oracle expert Brian Peasland explains why Oracle queries run slower in a smaller buffer cache.

What happens if the database buffer cache is not big enough to hold the data from a query (like a big table scan)?
Oracle will read in parts of what it needs into the buffer cache to satisfy the query, then clear out those buffers to read in more of what it needs. The process may repeat until the query is done processing. The smaller the buffer cache, the more this has to happen, and your queries may run noticeably slower.

Dig Deeper on Oracle database design and architecture

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.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close