Architecture and Administration Q007

Which component of the SGA contains the parsed SQL code?


1. Buffer Cache.
2. Dictionary Cache.
3. Library Cache.
4. Parse Cache.


Answer 3 - The library cache contains the parsed SQL code. If a query is executed again before it is aged out of the library cache, Oracle will re-use the parsed code and execution plan from the library cache. The buffer cache has data blocks that are cached. The dictionary cache caches data dictionary information. There is no structre called Parse cache.