Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraDbLibraryCacheSumTable

The LibraryCacheSum table tracks for all library caches in a database instance as a whole the same information that the LibraryCache table tracks for the caches individually. It is primarily a convenience.

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
Table A - 5. oraDBLibraryCacheSum Table Variables and Corresponding Object IDs

oraDbLibraryCacheSumGets

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

oraDbLibraryCacheSumGetHits

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

oraDbLibraryCacheSumPins

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

oraDbLibraryCacheSumPinHits

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

oraDbLibraryCacheSumReloads

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

oraDbLibraryCacheSumInvalidations

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

Contents Glossary Index Home Previous Next