Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 7: Parsing and Optimizing

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 examined what Oracle does with a previously unseen piece of text, we’ll examine the different ways in which we can re-execute a given piece of text, and see how, and understand why, Oracle’s workload varies with the method we choose


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint