All MIBs › ORADB-MIB › oraDbSGAVariableSize
oraDbSGAVariableSize
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbSGAVariableSize
OID (numeric): 1.3.6.1.4.1.111.4.1.6.1.2
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
What is oraDbSGAVariableSize?
This reports the size, in bytes, of the variable portion of the System Global Area, which includes the shared pool and other structures that Oracle can size based on init.ora parameters. It's one of the four SGA component values an admin totals up to verify actual memory usage against the configured SGA size.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.6.1.2 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbSGAVariableSize
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.6.1.2.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbSGAVariableSize.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::oraDbSGAVariableSize 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.6 | oraDbSGATable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.6.1 | oraDbSGAEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.6.1.2 | oraDbSGAVariableSize | ORADB-MIB |