oraDbLibraryCacheEntry
ORADB-MIB ·
.1.3.6.1.4.1.111.4.1.4.1
Object
row
mandatory
LibraryCache information for each Oracle database.
Context
- MIB
- ORADB-MIB
- OID
.1.3.6.1.4.1.111.4.1.4.1- Type
- row
- Status
- mandatory
- Parent
- oraDbLibraryCacheTable
- Table
- oraDbLibraryCacheTable
- Children
- 8
Syntax
No syntax metadata recorded.
Values & Constraints
No enumerated values or constraints recorded.
Related Objects
Child Objects
| Object | Type | Syntax | OID |
|---|---|---|---|
| oraDbLibraryCacheIndex mandatory A unique integer for each row of the table. | column | Integer32 | .1.3.6.1.4.1.111.4.1.4.1.1 |
| oraDbLibraryCacheNameSpace mandatory The namespace of the v$librarycache table that this
row relates to. | column | RFC1213-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. | column | RFC1155-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. | column | RFC1155-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. | column | RFC1155-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. | column | RFC1155-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 | column | RFC1155-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. | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.4.1.8 |
Indexes
| Object | Type | Syntax | OID |
|---|---|---|---|
| RDBMS-MIBrdbmsDbIndex A numeric index, unique among all the databases from all
products on this host. This value is a surrogate for the
conceptually unique key, which is {PrivateMibOID,
databasename} | column | Integer32 | .1.3.6.1.2.1.39.1.1.1.1 |
| oraDbLibraryCacheIndex mandatory A unique integer for each row of the table. | column | Integer32 | .1.3.6.1.4.1.111.4.1.4.1.1 |