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.
KeywordsExecution Plan Trace File Data Dictionary Free List Hash Chain
Unable to display preview. Download preview PDF.