All MIBs › ORADB-MIB › oraDbSysSortsMemory
oraDbSysSortsMemory
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbSysSortsMemory
OID (numeric): 1.3.6.1.4.1.111.4.1.1.1.14
Node type: OBJECT-TYPE
Type: Counter
Access: read-only
Description: the 'sorts (memory)' parameter from v$sysstat
What is oraDbSysSortsMemory?
This counter reports the 'sorts (memory)' statistic from v$sysstat, the number of sort operations completed entirely within the session's sort area in memory. Comparing this against oraDbSysSortsDisk tells an admin how well the current sort area sizing is meeting demand.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.1.1.14 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbSysSortsMemory
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.1.1.14.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbSysSortsMemory.1
SNMPv3 example:
snmpget -v3 -l authPriv -u snmpv3-user -a SHA -A "AuthPassword1" -x AES -X "PrivPassword1" <target> oraDbSysSortsMemory.1
Start monitoring Oracle database server/RDBMS instance (performance counters) with a free 30-day trial of IPNetwork Monitor. Create custom SNMP monitor using the ORADB-MIB::oraDbSysSortsMemory OID value, configure state conditions and alerts, and monitor any Oracle database server/RDBMS instance (performance counters) from a single console.
OID Breakdown
Upper-level ancestors (7 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.111 | oracle | ORACLE-AGENT-MIB |
| Numeric OID | Name | Module |
|---|---|---|
| 1.3.6.1.4.1.111.4 | oraDbMIB | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1 | oraDbObjects | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1 | oraDbSysTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1.1 | oraDbSysEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.1.1.14 | oraDbSysSortsMemory | ORADB-MIB |