oraDbLibraryCacheSumPins

ORADB-MIB · .1.3.6.1.4.1.111.4.1.5.1.3
MIB view Table view

Object

column mandatory RFC1155-SMICounter 
Number of times the system issues pin requests
for objects in a cache in order to access them,
summed over all library caches in the instance.

Context

MIB
ORADB-MIB
OID
.1.3.6.1.4.1.111.4.1.5.1.3
Type
column
Access
readonly
Status
mandatory
Parent
oraDbLibraryCacheSumEntry
Table
oraDbLibraryCacheSumTable
Siblings
5

Syntax

RFC1155-SMICounter
Source
RFC1155-SMICounter
Base type
Unsigned32

Values & Constraints

Type Constraints
range: 0..4294967295

Related Objects

Sibling Objects
ObjectTypeSyntaxOID
oraDbLibraryCacheSumGets mandatory
Number of times the system requests handles to library objects, summed over all library caches in the instance.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.5.1.1
oraDbLibraryCacheSumGetHits mandatory
Number of times the handles are already allocated in the cache, summed over all library caches in the instance.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.5.1.2
oraDbLibraryCacheSumPinHits mandatory
Number of times the objects the system is pinning are already allocated and initialized in a cache, summed over all library caches in the instance.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.5.1.4
oraDbLibraryCacheSumReloads mandatory
Number of times the library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated, summed over all library caches in the instance.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.5.1.5
oraDbLibraryCacheSumInvalidations mandatory
Number of times that non-persistent library objects (like shared SQL areas) have been invalidated, summed over all library caches in the instance.
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.5.1.6