A.9.10. Oracle::Library Cache
init.ora. It collects the following metrics:
- Library Cache Miss Ratio - The rate at which a library cache pin miss occurs. This happens when a session executes a statement that it has already parsed but finds that the statement is no longer in the shared pool.
- Executions - The number of times a pin was requested for objects of this namespace.
- Cache Misses - The number of pins that must now retrieve the object of the disk. These pins are made up of objects with previous pins from the time the object handle was created.
Table A.57. Oracle::Library Cache settings
|Critical Maximum Library Cache Miss Ratio|
|Warning Maximum Library Cache Miss Ratio|