Oracle Core pp 159-197 | Cite as

Parsing and Optimizing

  • Jonathan Lewis


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.


Execution Plan Trace File Data Dictionary Free List Hash Chain 


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Jonathan Lewis 2011

Authors and Affiliations

  • Jonathan Lewis

There are no affiliations available

Personalised recommendations