All MIBs › BEA-WEBLOGIC-MIB › jdbcDataSourceRuntimePrepStmtCacheHitCount
jdbcDataSourceRuntimePrepStmtCacheHitCount
Module: BEA-WEBLOGIC-MIB
OID (symbolic): BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheHitCount
OID (numeric): 1.3.6.1.4.1.140.625.191.1.70
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Returns the cumulative, running count of the number of times that statements from the cache were used.
What is jdbcDataSourceRuntimePrepStmtCacheHitCount?
This is the cumulative count of cache hits, where a statement request found a matching cached statement and reused it. High hit rates improve performance. Example: if cache hits are 90,000 out of 100,000 accesses, a 90% hit rate is very healthy.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.140.625.191.1.70 snmpwalk -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheHitCount
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.140.625.191.1.70.1 snmpget -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcDataSourceRuntimePrepStmtCacheHitCount.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::jdbcDataSourceRuntimePrepStmtCacheHitCount 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.70 | jdbcDataSourceRuntimePrepStmtCacheHitCount | BEA-WEBLOGIC-MIB |