All MIBs › EMPIRE-ORAMOD › oramodDbCfgSORTAREASIZE
oramodDbCfgSORTAREASIZE
Module: EMPIRE-ORAMOD
OID (symbolic): EMPIRE-ORAMOD::oramodDbCfgSORTAREASIZE
OID (numeric): 1.3.6.1.4.1.546.16.4.10.1.1.1.24
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: Maximum Sort Area Size. Controls the amount of memory allocated to each process in the Process Global Area for any sorting activity (for multithreaded server this is allocated in the shared pool). When a process needs more memory than is available for a sort, disk space must be allocated in the temporary tablespace. Tuning is based on the transaction mix of the application. The default (O/S dependent) is adequate for most DB operations.
What is oramodDbCfgSORTAREASIZE?
The maximum Sort Area Size, controlling memory each process gets in its Process Global Area for sort operations (or the shared pool, for multithreaded server configurations); when a sort needs more than this, it spills to the temporary tablespace. Admins raise it when oramodMetricsDBSORTDISK shows sorts are overflowing to disk too often.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.546.16.4.10.1.1.1.24 snmpwalk -v2c -c public <target> EMPIRE-ORAMOD::oramodDbCfgSORTAREASIZE
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.546.16.4.10.1.1.1.24.1 snmpget -v2c -c public <target> EMPIRE-ORAMOD::oramodDbCfgSORTAREASIZE.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::oramodDbCfgSORTAREASIZE 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.24 | oramodDbCfgSORTAREASIZE | EMPIRE-ORAMOD |