All MIBs › EMPIRE-ORAMOD › oramodMetricsUCPP
oramodMetricsUCPP
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodMetricsUCPP
OID (numeric): 1.3.6.1.4.1.546.16.4.11.2.1.1.18
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: User Calls Per Parse Ratio scaled by 100. The ratio of user calls to parse in the shared SQL area. Indicates how well the application is managing its context area. If it changes, then application change is the most likely explanation, but it may indicate the useage patterns are changing and users are moving from one module to another either more frequently or less frequently. Although the shared SQL area makes the maximizing of this ratio less important than with earlier versions of Oracle, it is still possible to reduce resource usage by raising this ratio.
What is oramodMetricsUCPP?
User Calls Per Parse Ratio, scaled by 100 - how well the application reuses its parsed SQL rather than reparsing. The description notes that even with the shared SQL area reducing the stakes, raising this ratio still reduces resource usage.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.18 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsUCPP
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.18.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsUCPP.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::oramodMetricsUCPP 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.18 | oramodMetricsUCPP | EMPIRE-ORAMOD |