All MIBs › ORADB-MIB › oraDbConfigSessions
oraDbConfigSessions
Module: ORADB-MIB
OID (symbolic): ORADB-MIB::oraDbConfigSessions
OID (numeric): 1.3.6.1.4.1.111.4.1.7.1.24
Node type: OBJECT-TYPE
Type: INTEGER
Access: read-only
Description: The SESSIONS parameter from the init.ora file
What is oraDbConfigSessions?
This reports the SESSIONS setting from init.ora, the maximum number of concurrent user and system sessions the instance allows, generally derived from the PROCESSES setting. Reaching this ceiling produces an 'ORA-00018: maximum number of sessions exceeded' error for new connections.
Examples
Walk all instances (SNMPv2c):
snmpwalk -v2c -c public <target> 1.3.6.1.4.1.111.4.1.7.1.24 snmpwalk -v2c -c public <target> ORADB-MIB::oraDbConfigSessions
Get a specific instance (index 1):
snmpget -v2c -c public <target> 1.3.6.1.4.1.111.4.1.7.1.24.1 snmpget -v2c -c public <target> ORADB-MIB::oraDbConfigSessions.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::oraDbConfigSessions 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.7 | oraDbConfigTable | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.7.1 | oraDbConfigEntry | ORADB-MIB |
| 1.3.6.1.4.1.111.4.1.7.1.24 | oraDbConfigSessions | ORADB-MIB |