All MIBs › EMPIRE-ORAMOD › oramodMetricsTBLSCANROWS
oramodMetricsTBLSCANROWS
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodMetricsTBLSCANROWS
OID (numeric): 1.3.6.1.4.1.546.16.4.11.2.1.1.39
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: The number of rows retrieved through table scans since instance startup.
What is oramodMetricsTBLSCANROWS?
The number of rows retrieved via full table scans since instance startup. A growing share of rows coming from scans rather than indexed fetches (oramodMetricsTBLFTCHROWID) often means a missing or unused index.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.39 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsTBLSCANROWS
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.39.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsTBLSCANROWS.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> oramodMetricsTBLSCANROWS.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::oramodMetricsTBLSCANROWS 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.2 | oramodMetrics | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.2.1 | oramodMetricsTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.2.1.1 | oramodMetricsEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.2.1.1.39 | oramodMetricsTBLSCANROWS | EMPIRE-ORAMOD |