Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraDbLibraryCacheTable

The oraDbLibraryCacheTable contains variables measuring library cache activity since the most recent database instance startup. A library cache is a memory structure containing shared SQL and PL/SQL areas. Monitoring the library cache is important to determine whether it is necessary to resize Oracle's shared pool.

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

oraDbLibraryCacheIndex

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

oraDbLibraryCacheNameSpace

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

oraDbLibraryCacheGets

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

oraDbLibraryCacheGetHits

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

oraDbLibraryCachePins

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

oraDbLibraryCachePinHits

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

oraDbLibraryCacheReloads

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

oraDbLibraryCacheInvalidations

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

Contents Glossary Index Home Previous Next