All MIBs › BEA-WEBLOGIC-MIB › jdbcStoreInsertsPerBatchMaximum
jdbcStoreInsertsPerBatchMaximum
Module: BEA-WEBLOGIC-MIB
OID (symbolic): BEA-WEBLOGIC-MIB::jdbcStoreInsertsPerBatchMaximum
OID (numeric): 1.3.6.1.4.1.140.625.950.1.9
Node type: OBJECT-TYPE
Type: Integer32
Access: read-only
Description: The maximum number of table rows that are inserted per database call. When possible, a JDBC store uses JDBC 3.0 batching to batch concurrent client requests. Both the maximum batch size for concurrent inserts and for concurrent writes are configurable. To disable JDBC 3.0 batching, set the maximum batch size to 1. The maximum batch size has no effect on the maximum number of concurrent client requests.
What is jdbcStoreInsertsPerBatchMaximum?
This OID sets the maximum rows inserted per database call when using JDBC 3.0 batching. Example: '200' batches up to 200 INSERT statements, reducing database load.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.140.625.950.1.9 snmpwalk -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcStoreInsertsPerBatchMaximum
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.140.625.950.1.9.1 snmpget -v2c -c public <target> BEA-WEBLOGIC-MIB::jdbcStoreInsertsPerBatchMaximum.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::jdbcStoreInsertsPerBatchMaximum 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.950 | jdbcStoreTable | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.950.1 | jdbcStoreEntry | BEA-WEBLOGIC-MIB |
| 1.3.6.1.4.1.140.625.950.1.9 | jdbcStoreInsertsPerBatchMaximum | BEA-WEBLOGIC-MIB |