C H A P T E R  7

Parsing and Optimizing

Do You Come Here Often?

After spending time with the data cache in Chapters 5 and 6, we can come back to the code cache—more specifically the library cache although we’ll also spend time looking at the dictionary cache. Both these caches are part of the shared pool (or SGA heap to give a more appropriate name) so, inevitably, we will have to look at some of the generic mechanisms that affect the shared pool at the same time.

Since the library cache is the place where your SQL (or PL/SQL) text ends up in a form that can be executed we’re going to start our journey to the library cache at the point where an end-user program sends Oracle a piece of text and expects something to be done with it.

Once we’ve ...

Get Oracle Core: Essential Internals for DBAs and Developers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.