All MIBs › EMPIRE-ORAMOD › oramodExpSqlEXECUTION
oramodExpSqlEXECUTION
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodExpSqlEXECUTION
OID (numeric): 1.3.6.1.4.1.546.16.4.11.7.1.1.3
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: Number of Executions.
What is oramodExpSqlEXECUTION?
The number of times this specific SQL statement has been executed. The header comment for this section notes that bad application SQL does more to hurt overall system performance than anything else, so this table is meant to surface statements worth tuning.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.3 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlEXECUTION
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.3.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlEXECUTION.1
Start monitoring Server running Oracle database, monitored by CA/Empire SystemEDGE agent with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the EMPIRE-ORAMOD::oramodExpSqlEXECUTION OID value, configure state conditions and alerts, and monitor any Server running Oracle database, monitored by CA/Empire SystemEDGE agent from a single console.
OID Breakdown
Upper-level ancestors (8 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.546 | empire | CAHYPERV-AIM-MIB |
| 1.3.6.1.4.1.546.16 | applications | CAHYPERV-AIM-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.546.16.4 | oracledb | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11 | oramodPerf | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7 | oramodExpSql | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1 | oramodExpSqlTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1.1 | oramodExpSqlEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.7.1.1.3 | oramodExpSqlEXECUTION | EMPIRE-ORAMOD |