First page Back Continue Last page Graphics
Library Cache Retention
Parsed SQL flushed when
- Ages out with LRU algorithm
- Referenced object is altered
- ALTER SYSTEM FLUSH SHARED_POOL;
- Instance is shut down
Notes:
Parsed SQL (and PL/SQL) remains in the library cache until:
free space in the cache is exhausted and new statements need to be parsed. Oracle looks for the least recently used (LRU) statements and steals the memory from those statements.
an object that a parsed query refers to is altered (e.g. ALTER TABLE x ADD c2 NUMBER).
the shared pool is manually flushed with the ALTER SYSTEM command. This is generally not advisable.
the instance is shut down.