O'Reilly logo

Oracle Core: Essential Internals for DBAs and Developers by Jonathan Lewis

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Finding Data

So far we’ve been looking at the mechanics of copying a block from disc into memory. Now, working round and round in circles as you have to when learning Oracle, we have to address the question, “How did you know that you needed to read that block from disc, and how did you decide, quickly and efficiently, that it wasn’t already in memory?”

We’ve been looking at the replacement list, which lets us decide which buffer to reuse for new data, but we don’t want to search through the replacement list one buffer at a time to see which one (if any) holds the block we’re interested in. We now need a different way of viewing those buffers so that we can find the one we want as quickly as possible.

We’ve already seen the answer to this problem, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required