All MIBs › EMPIRE-ORAMOD › oramodExpSqlSQL
oramodExpSqlSQL
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodExpSqlSQL
OID (numeric): 1.3.6.1.4.1.546.16.4.11.7.1.1.8
Node type: OBJECT-TYPE
Type: DisplayString
Access: read-only
Description: Sql Statement truncated.
What is oramodExpSqlSQL?
The (truncated) text of this expensive SQL statement, per the description. It's the field admins actually read to identify and fix the offending query once the surrounding counters flag it as expensive.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.8 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlSQL
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.7.1.1.8.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodExpSqlSQL.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::oramodExpSqlSQL 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.8 | oramodExpSqlSQL | EMPIRE-ORAMOD |