Each entry in the oraDbLibraryCacheTable represents a given library cache within a current database instance on the node. Each entry is indexed first by rdbmsDbIndex, and then by oraDbLibraryCacheIndex; thus, there will normally be a one-to-many relationship between an rdbmsDbTable entry and corresponding oraDbLibraryCacheTable entries. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbLibraryCacheTable variable is retrieved directly from a corresponding field in the V$LIBRARYCACHE table for that library cache within that database instance.
Table A - 4 lists each variable of the oraDbLibraryCacheTable and its corresponding object ID.
Variable Name | Object ID |
oraDbLibraryCacheIndex | 1.3.6.1.4.1.111.4.1.4.1.1 |
oraDbLibraryCacheNameSpace | 1.3.6.1.4.1.111.4.1.4.1.2 |
oraDbLibraryCacheGets | 1.3.6.1.4.1.111.4.1.4.1.3 |
oraDbLibraryCacheGetHits | 1.3.6.1.4.1.111.4.1.4.1.4 |
oraDbLibraryCachePins | 1.3.6.1.4.1.111.4.1.4.1.5 |
oraDbLibraryCachePinHits | 1.3.6.1.4.1.111.4.1.4.1.6 |
oraDbLibraryCacheReloads | 1.3.6.1.4.1.111.4.1.4.1.7 |
oraDbLibraryCacheInvalidations | 1.3.6.1.4.1.111.4.1.4.1.8 |
Syntax | INTEGER (1..2147483647) |
Max-Access | read-only |
Explanation | A unique integer for each row of the oraDbLibraryCacheTable. |
Typical Range | 8 (only) |
Significance | very important |
Related Variables | oraDbLibraryCacheNameSpace |
Suggested Presentation | not applicable |
Syntax | DisplayString |
Max-Access | read-only |
Explanation | Indicates the namespace of the V$LIBRARYCACHE table to which this row is related. The value is retrieved from the value of NAMESPACE in V$LIBRARYCACHE. |
Typical Range | 0 - 30 characters |
Significance | important |
Related Variables | oraDbLibraryCacheIndex |
Suggested Presentation | simple string |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that the system requests handles to library objects in this namespace. The value of oraDbLibraryCacheGets is retrieved from the value of GETS in V$LIBRARYCACHE. |
Typical Range | 0 - 500,00 per day |
Significance | important |
Related Variables | oraDbLibraryCacheGetHits |
Suggested Presentation | counter |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that the handles are already allocated in the cache. The value of oraDbLibraryCacheGetHits is retrieved from the value of GETHITS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | oraDbLibraryCacheGets |
Suggested Presentation | counter |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that the system issues pin requests in order to access objects in the cache. The value of oraDbLibraryCachePins is retrieved from the value of PINS in V$LIBRARYCACHE. |
oraDbLibraryCachePins is used to calculate the following database instance performance ratio: library cache miss ratio. | |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | oraDbLibraryPinHits, oraDbLibraryCacheReloads |
Suggested Presentation | counter |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that the objects the system is pinning are already allocated and initialized in the cache. The value of oraDbLibraryCachePinHits is retrieved from the value of PINHITS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | important |
Related Variables | oraDbLibraryCachePins |
Suggested Presentation | counter |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated. The value of oraDbLibraryCacheReloads is retrieved from the value of RELOADS in V$LIBRARYCACHE. |
oraDbLibraryCacheReloads is used to calculate the following database instance performance ratio: library cache miss ratio. | |
Typical Range | 0 - 4294967295 |
Significance | important |
Related Variables | oraDbLibraryCachePins |
Suggested Presentation | counter |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the number of times, since database instance startup, that non-persistent library objects (like shared SQL areas) have been invalidated. The value of oraDbLibraryCacheInvalidations is retrieved from the value of INVALIDATIONS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | none |
Suggested Presentation | counter |