All MIBs › EMPIRE-ORAMOD › oramodSGADLCIGETHITRT
oramodSGADLCIGETHITRT
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodSGADLCIGETHITRT
OID (numeric): 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6
Node type: OBJECT-TYPE
Type: Gauge
Access: read-only
Description: The Get/Hit ratio determines the percentage of parse calls that find a cursor to share. The value is derived from GETHITS divided by GETS. Should be in the high 90s which indicates that most of the handles the system has tried to get are cached.
What is oramodSGADLCIGETHITRT?
The Get/Hit ratio for this namespace - GETHITS divided by GETS - showing what percentage of parse calls found a cursor to share. The description says it should be in the high 90s; a lower value for a namespace like SQL AREA means the shared pool is too small for this workload.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodSGADLCIGETHITRT
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodSGADLCIGETHITRT.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::oramodSGADLCIGETHITRT 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.3 | oramodSGA | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.3.2 | oramodSgaDlci | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.3.2.1 | oramodSgaDlciTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1 | oramodSgaDlciEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.3.2.1.1.6 | oramodSGADLCIGETHITRT | EMPIRE-ORAMOD |