All MIBs › BEA-WEBLOGIC-MIB › jdbcConnectionPoolRuntimeStatementProfileCount
jdbcConnectionPoolRuntimeStatementProfileCount
Module: BEA-WEBLOGIC-MIB
OID (symbolic): BEA-WEBLOGIC-MIB::jdbcConnectionPoolRuntimeStatementProfileCount
OID (numeric): 1.3.6.1.4.1.140.625.190.1.71
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Number of the SQL statement profiles in profile storage.
What is jdbcConnectionPoolRuntimeStatementProfileCount?
This is the current count of unique SQL statement profiles stored in the pool's statement cache. Each profile represents a distinct prepared statement pattern. Example: a profile count of 1,250 indicates the cache is tracking 1,250 different SQL statements, which helps identify statement caching effectiveness.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.140.625.190.1.71 snmpwalk -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcConnectionPoolRuntimeStatementProfileCount
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.140.625.190.1.71.1 snmpget -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcConnectionPoolRuntimeStatementProfileCount.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::jdbcConnectionPoolRuntimeStatementProfileCount 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.190 | jdbcConnectionPoolRuntimeTable | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.190.1 | jdbcConnectionPoolRuntimeEntry | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.190.1.71 | jdbcConnectionPoolRuntimeStatementProfileCount | BEA-WEBLOGIC-MIB |