All MIBs › EMPIRE-ORAMOD › oramodMetricsCRR
oramodMetricsCRR
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodMetricsCRR
OID (numeric): 1.3.6.1.4.1.546.16.4.11.2.1.1.10
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: Continued Row Ratio scaled by 100. Measures the space useage of data blocks. Should be close to zero, except in applications handling long LONG columns. If this ratio increases over time, usually PCTFREE has been set too low on one or more tables.
What is oramodMetricsCRR?
Continued Row Ratio, scaled by 100, measuring wasted space usage from chained/migrated rows; it should stay close to zero except for applications with long LONG columns. A rising value usually means PCTFREE was set too low on one or more tables, per the description.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.10 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsCRR
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.10.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsCRR.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::oramodMetricsCRR 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.10 | oramodMetricsCRR | EMPIRE-ORAMOD |