All MIBs › EMPIRE-ORAMOD › oramodLatchSPINGETS
oramodLatchSPINGETS
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodLatchSPINGETS
OID (numeric): 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: Latch Spin Gets. Some latch types will lock into a tight loop testing the latch and trying to get it. Spinning uses significant CPU resources. The number of spins depends on the spincount set it the init.ora file. Once the number of spincounts has been reached the prcess will back off and sleep.
What is oramodLatchSPINGETS?
The number of times this latch was acquired via spinning - repeatedly testing the latch in a tight loop - since instance startup, per the description. Spinning consumes significant CPU and is governed by the init.ora spincount setting, so a high spin-get count for a hot latch directly translates into CPU overhead.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodLatchSPINGETS
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodLatchSPINGETS.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::oramodLatchSPINGETS 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.9 | oramodLocks | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.9.2 | oramodLatch | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.9.2.1 | oramodLatchTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1 | oramodLatchEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.11.9.2.1.1.11 | oramodLatchSPINGETS | EMPIRE-ORAMOD |