Variable Name | Object ID |
oraDbLibraryCacheSumGets | 1.3.6.1.4.1.111.4.1.5.1.1 |
oraDbLibraryCacheSumGetHits | 1.3.6.1.4.1.111.4.1.5.1.2 |
oraDbLibraryCacheSumPins | 1.3.6.1.4.1.111.4.1.5.1.3 |
oraDbLibraryCacheSumPinHits | 1.3.6.1.4.1.111.4.1.5.1.4 |
oraDbLibraryCacheSumReloads | 1.3.6.1.4.1.111.4.1.5.1.5 |
oraDbLibraryCacheSumInvalidations | 1.3.6.1.4.1.111.4.1.5.1.6 |
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 oraDbLibraryCacheSumGets is derived from the value of GETS in V$LIBRARYCACHE. |
Typical Range | 0 - 500,00 per day |
Significance | important |
Related Variables | oraDbLibraryCacheSumGetHits |
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 oraDbLibraryCacheSumGetHits is derived from the value of GETHITS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | oraDbLibraryCacheSumGets |
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 oraDbLibraryCacheSumPins is derived from the value of PINS in V$LIBRARYCACHE. |
oraDbLibraryCacheSumPins is used to calculate the following database instance performance ratio: library cache miss ratio. | |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | oraDbLibraryPinHits, oraDbLibraryCacheSumReloads |
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 oraDbLibraryCacheSumPinHits is derived from the value of PINHITS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | important |
Related Variables | oraDbLibraryCacheSumPins |
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 oraDbLibraryCacheSumReloads is derived from the value of RELOADS in V$LIBRARYCACHE. |
oraDbLibraryCacheSumReloads is used to calculate the following database instance performance ratio: library cache miss ratio. | |
Typical Range | 0 - 4294967295 |
Significance | important |
Related Variables | oraDbLibraryCacheSumPins |
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 oraDbLibraryCacheSumInvalidations is derived from the value of INVALIDATIONS in V$LIBRARYCACHE. |
Typical Range | 0 - 4294967295 |
Significance | less important |
Related Variables | none |
Suggested Presentation | counter |