All MIBs › ORADB-MIB › oraDbLibraryCacheReloads
oraDbLibraryCacheReloads
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbLibraryCacheReloads
OID (numeric): 1.3.6.1.4.1.111.4.1.4.1.7
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: Number of times the library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated
What is oraDbLibraryCacheReloads?
This counter reports how many times an object in this library cache namespace had to be reloaded from the data dictionary because it was aged out of memory or invalidated. Frequent reloads point to a shared pool that's too small or too fragmented to hold the working set of SQL and PL/SQL.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.4.1.7 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbLibraryCacheReloads
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.4.1.7.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbLibraryCacheReloads.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::oraDbLibraryCacheReloads 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.7 | oraDbLibraryCacheReloads | ORADB-MIB |