All MIBs › BEA-WEBLOGIC-MIB › jdbcDataSourceRuntimePrepStmtCacheMissCount
jdbcDataSourceRuntimePrepStmtCacheMissCount
Module: BEA-WEBLOGIC-MIB
OID (symbolic): BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheMissCount
OID (numeric): 1.3.6.1.4.1.140.625.191.1.75
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Returns the number of times that a statement request could not be satisfied with a statement from the cache.
What is jdbcDataSourceRuntimePrepStmtCacheMissCount?
This is the cumulative count of cache misses, where a requested statement was not found and had to be compiled fresh. Example: if miss count equals 10,000 and hit count equals 100,000, the 10% miss rate indicates some statements aren't being cached or reused effectively.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.140.625.191.1.75 snmpwalk -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheMissCount
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.140.625.191.1.75.1 snmpget -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheMissCount.1
Start monitoring BEA/Oracle WebLogic Server (Java EE application server) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheMissCount OID value, configure state conditions and alerts, and monitor any BEA/Oracle WebLogic Server (Java EE application server) from a single console.
OID Breakdown
Upper-level ancestors (6 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 |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.140 | bea | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625 | wls | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.191 | jdbcDataSourceRuntimeTable | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.191.1 | jdbcDataSourceRuntimeEntry | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.191.1.75 | jdbcDataSourceRuntimePrepStmtCacheMissCount | BEA-WEBLOGIC-MIB |