All MIBs › ORADB-MIB › oraDbLibraryCachePinHits
oraDbLibraryCachePinHits
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbLibraryCachePinHits
OID (numeric): 1.3.6.1.4.1.111.4.1.4.1.6
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: Number of times the objects the system is pinning are already allocated and initialized in the cache.
What is oraDbLibraryCachePinHits?
This counter reports how many of those pin requests found the object already fully loaded and initialized in the cache, avoiding a reload. Sysadmins compare this against oraDbLibraryCachePins when troubleshooting shared pool contention or fragmentation.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.4.1.6 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbLibraryCachePinHits
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.4.1.6.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbLibraryCachePinHits.1
Start monitoring Oracle database server/RDBMS instance (performance counters) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the ORADB-MIB::oraDbLibraryCachePinHits OID value, configure state conditions and alerts, and monitor any Oracle database server/RDBMS instance (performance counters) from a single console.
OID Breakdown
Upper-level ancestors (7 from the standard OID tree / other modules)
| Numeric OID | Name | Module |
|---|---|---|
| 1 | iso | LANART-AGENT |
| 1.3 | org | AirPair-MIB |
| 1.3.6 | dod | AirPair-MIB |
| 1.3.6.1 | internet | AirPair-MIB |
| 1.3.6.1.4 | private | AirPair-MIB |
| 1.3.6.1.4.1 | enterprises | AirPair-MIB |
| 1.3.6.1.4.1.111 | oracle | ORACLE-AGENT-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.111.4 | oraDbMIB | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1 | oraDbObjects | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.4 | oraDbLibraryCacheTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.4.1 | oraDbLibraryCacheEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.4.1.6 | oraDbLibraryCachePinHits | ORADB-MIB |