Red Hat Training
A Red Hat training course is available for Red Hat Satellite
A.9.10. Oracle::Library Cache
The Oracle::Library Cache probe computes the Library Cache Miss Ratio so as to optimize the SHARED_POOL_SIZE in
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
| Field | Value |
|---|---|
| Oracle SID* | |
| Oracle Username* | |
| Oracle Password* | |
| Oracle Port* | 1521 |
| Timeout* | 30 |
| Critical Maximum Library Cache Miss Ratio | |
| Warning Maximum Library Cache Miss Ratio |
