All MIBs › ORADB-MIB › oraDbSysUserCommits
oraDbSysUserCommits
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbSysUserCommits
OID (numeric): 1.3.6.1.4.1.111.4.1.1.1.23
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: the 'user commits' parameter from v$sysstat
What is oraDbSysUserCommits?
This counter reports the 'user commits' statistic from v$sysstat, the number of COMMIT statements issued by application sessions. Tracking its rate helps size redo log throughput needs and spot applications that commit too frequently (or too rarely) for good performance.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.1.1.23 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbSysUserCommits
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.1.1.23.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbSysUserCommits.1
Start monitoring Oracle database server/RDBMS instance (performance counters) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the ORADB-MIB::oraDbSysUserCommits OID value, configure state conditions and alerts, and monitor any Oracle database server/RDBMS instance (performance counters) from a single console.
OID Breakdown
Upper-level ancestors (7 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 |
| 1.3.6.1.4.1.111 | oracle | ORACLE-AGENT-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.111.4 | oraDbMIB | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1 | oraDbObjects | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1 | oraDbSysTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1.1 | oraDbSysEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1.1.23 | oraDbSysUserCommits | ORADB-MIB |