All MIBs › BEA-WEBLOGIC-MIB › jdbcTxDataSourceRowPrefetchEnabled
jdbcTxDataSourceRowPrefetchEnabled
Module: BEA-WEBLOGIC-MIB
OID (symbolic): BEA-WEBLOGIC-MIB::jdbcTxDataSourceRowPrefetchEnabled
OID (numeric): 1.3.6.1.4.1.140.625.590.1.45
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Whether to enable row prefetching between client and WebLogic Server for each ResultSet. The WebLogic Server will ignore this setting and not use row prefetching when the client and WebLogic Server are in the same JVM.
What is jdbcTxDataSourceRowPrefetchEnabled?
Whether to enable row prefetching between client and WebLogic Server for each ResultSet. The WebLogic Server will ignore this setting and not use row prefetching when the client and WebLogic Server are in the same JVM. Row prefetching trades memory for network round-trip latency, beneficial when the client is on a different machine. Example: when a client fetches 10,000 rows, prefetch of 100 rows means 100 requests fetch all 10,000 rows instead of 10,000 individual requests.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.140.625.590.1.45 snmpwalk -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcTxDataSourceRowPrefetchEnabled
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.140.625.590.1.45.1 snmpget -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcTxDataSourceRowPrefetchEnabled.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::jdbcTxDataSourceRowPrefetchEnabled 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.590 | jdbcTxDataSourceTable | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.590.1 | jdbcTxDataSourceEntry | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.590.1.45 | jdbcTxDataSourceRowPrefetchEnabled | BEA-WEBLOGIC-MIB |