All MIBs › EMPIRE-ORAMOD › oramodMetricsSGALCE
oramodMetricsSGALCE
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodMetricsSGALCE
OID (numeric): 1.3.6.1.4.1.546.16.4.11.2.1.1.20
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: Library Cache Efficiency Percentage scaled by 100. The percentage that a SQL statement did not need to be reloaded because it was already in the library cache. This percentage should be 100. If not, try resizing the SHAREDPOOLSIZE in the initialization file.
What is oramodMetricsSGALCE?
Library Cache Efficiency Percentage, scaled by 100 - how often a SQL statement was found in the library cache without needing a reload. The description says this should be 100, and if not, try resizing SHAREDPOOLSIZE (oramodDbCfgSHAREDPOOLSIZE).
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.20 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsSGALCE
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.2.1.1.20.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodMetricsSGALCE.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::oramodMetricsSGALCE 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.20 | oramodMetricsSGALCE | EMPIRE-ORAMOD |