All MIBs › EMPIRE-ORAMOD › oramodDbCfgSHAREDPOOLSIZE
oramodDbCfgSHAREDPOOLSIZE
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodDbCfgSHAREDPOOLSIZE
OID (numeric): 1.3.6.1.4.1.546.16.4.10.1.1.1.15
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Shared Pool Size Size in Kbytes. Controls the size of the memory area used for parsing and executing SQL statements. The default is 3.5 Mbytes. Typical Range 300 Kbytes. It is O/S dependent.
What is oramodDbCfgSHAREDPOOLSIZE?
The configured Shared Pool size in KBytes (SHARED_POOL_SIZE), which controls memory for parsing and executing SQL statements; the default is about 3.5MB per the description. Undersizing this relative to SQL workload is a classic cause of excessive hard parsing and library cache misses.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.10.1.1.1.15 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodDbCfgSHAREDPOOLSIZE
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.10.1.1.1.15.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodDbCfgSHAREDPOOLSIZE.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::oramodDbCfgSHAREDPOOLSIZE 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.10 | oramodCfg | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.10.1 | oramodDbCfg | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.10.1.1 | oramodDbCfgTable | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.10.1.1.1 | oramodDbCfgEntry | EMPIRE-ORAMOD |
| 1.3.6.1.4.1.546.16.4.10.1.1.1.15 | oramodDbCfgSHAREDPOOLSIZE | EMPIRE-ORAMOD |