All MIBs › ORADB-MIB › oraDbTablespaceLargestAvailableChunk
oraDbTablespaceLargestAvailableChunk
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbTablespaceLargestAvailableChunk
OID (numeric): 1.3.6.1.4.1.111.4.1.2.1.6
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: The size, in kilobytes, of the largest contiguous set of free data blocks in the tablespace.
What is oraDbTablespaceLargestAvailableChunk?
This reports the size, in kilobytes, of the largest contiguous run of free blocks in a tablespace. Even when total free space looks adequate, a shrinking largest-chunk value warns of fragmentation that could cause a large object extend operation to fail.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.2.1.6 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbTablespaceLargestAvailableChunk
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.2.1.6.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbTablespaceLargestAvailableChunk.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::oraDbTablespaceLargestAvailableChunk 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.2 | oraDbTablespaceTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.2.1 | oraDbTablespaceEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.2.1.6 | oraDbTablespaceLargestAvailableChunk | ORADB-MIB |