oraDbLibraryCacheIndex

ORADB-MIB · .1.3.6.1.4.1.111.4.1.4.1.1
MIB view Table view

Object

column mandatory Integer32 
A unique integer for each row of the table.

Context

MIB
ORADB-MIB
OID
.1.3.6.1.4.1.111.4.1.4.1.1
Type
column
Access
readonly
Status
mandatory
Parent
oraDbLibraryCacheEntry
Table
oraDbLibraryCacheTable
Siblings
7

Syntax

Integer32
Source
COPS-PR-SPPIInteger32
Base type
Integer32

Values & Constraints

Type Constraints
range: -2147483648..2147483647

Related Objects

Sibling Objects
ObjectTypeSyntaxOID
oraDbLibraryCacheNameSpace mandatory
The namespace of the v$librarycache table that this row relates to.
columnRFC1213-MIBDisplayString.1.3.6.1.4.1.111.4.1.4.1.2
oraDbLibraryCacheGets mandatory
Number of times the system requests handles to library objects in this namespace.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.3
oraDbLibraryCacheGetHits mandatory
Number of times the handles are already allocated in the cache.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.4
oraDbLibraryCachePins mandatory
Number of times the system issues pin requests for objects in the cache in order to access them.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.5
oraDbLibraryCachePinHits mandatory
Number of times the objects the system is pinning are already allocated and initialized in the cache.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.6
oraDbLibraryCacheReloads mandatory
Number of times the library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.7
oraDbLibraryCacheInvalidations mandatory
Number of times that non-persistent library objects (like shared SQL areas) have been invalidated.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.4.1.8