Each entry in the oraDispatcherTable represents a dispatcher associated with a current database instance. Each entry is indexed first by oraSIDName, and then by oraDispatcherIndex; thus, there can be a one-to-many relationship between a database instance and the dispatcher processes serving it. Using this indexing method, all dispatchers associated with a given SID can be found by SNMP traversal operations (get-next and get-bulk). The current value of most oraDispatcherTable variables is retrieved from internal listener tables.
Table B - 4 lists the variables included in the oraDispatcherTable.
| Variable Name | Object ID |
| oraDispatcherIndex | 1.3.6.1.4.1.111.5.1.3.1.1 |
| oraDispatcherEstablishedConnections | 1.3.6.1.4.1.111.5.1.3.1.2 |
| oraDispatcherRejectedConnections | 1.3.6.1.4.1.111.5.1.3.1.3 |
| oraDispatcherCurrentConnections | 1.3.6.1.4.1.111.5.1.3.1.4 |
| oraDispatcherMaximumConnections | 1.3.6.1.4.1.111.5.1.3.1.5 |
| oraDispatcherState | 1.3.6.1.4.1.111.5.1.3.1.6 |
| oraDispatcherProtocolInfo | 1.3.6.1.4.1.111.5.1.3.1.7 |
A description of each of these variables follows.
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | A numeric index, unique among all the dispatchers, as retrieved from an internal listener buffer. |
| Typical Range | 1 - 5, depending on the number of dispatchers configured for the database instance |
| Significance | very important |
| Related Variables | none |
| Suggested Presentation | not applicable |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates how many incoming connection requests this dispatcher has accepted since startup of this managed listener, as retrieved from an internal listener buffer. |
| When the value of oraDispatcherEstablishedConnections approaches the value of oraDispatcherMaximumConnections, this dispatcher is reaching the threshold (the greatest number of connection requests that can be accepted). | |
| Typical Range | 0 - value of oraDispatcherMaximumConnections |
| Significance | very important |
| Related Variables | oraDedicatedSrvEstablishedConnections, oraDispatcherMaximumConnections, oraDispatcherRejectedConnections, oraPrespawnedSrvEstablishedConnections |
| Suggested Presentation | counter |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates how many incoming connection requests this dispatcher has rejected since startup of this managed listener, as retrieved from an internal listener table. |
| Typical Range | 0 - 4249467295 |
| Significance | very important |
| Related Variables | oraDedicatedSrvEstablishedConnections, oraDispatcherEstablishedConnections, oraDispatcherState, oraPrespawnedSrvEstablishedConnections |
| Suggested Presentation | counter |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | Indicates the number of connection requests this dispatcher is currently redirecting, as retrieved from an internal listener table. Monitoring oraDispatcherCurrentConnections and oraDispatcherMaximumConnections together indicates the load/activity of the dispatcher. |
| Typical Range | 0 - oraDispatcherMaximumConnections |
| Significance | very important |
| Related Variables | oraSIDCurrentConnectedClients, oraDispatcherMaximumConnections |
| Suggested Presentation | gauge |
| Syntax | INTEGER (1..21474836647) |
| Max-Access | read-only |
| Explanation | Indicates the greatest number of connection requests that this dispatcher can accept, as retrieved from an internal listener table. |
| Typical Range | 0 - value of oraSIDReservedConnections |
| Significance | very important |
| Related Variables | oraDispatcherCurrentConnections, oraSIDReservedConnections |
| Suggested Presentation | gauge |
| Syntax | INTEGER (1) blocked, or (2) ready. |
| Max-Access | read-only |
| Explanation | Indicates the current state of this dispatcher, as retrieved from an internal listener table. The BLOCKED value (1) indicates that the dispatcher is temporarily not accepting redirected connection requests. The READY value (2) indicates that this dispatcher is ready to accept any redirected connection requests. |
| Typical Range | enumerated 1 or 2 |
| Significance | very important |
| Related Variables | oraDispatcherRejectedConnections |
| Suggested Presentation | icon or simple string |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the protocol for which this dispatcher listens, as well as protocol-specific information, as retrieved from the MTS_LISTENER_ADDRESS parameter of the INIT.ORA configuration file. |
| Typical Range | 1 - 255 characters |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | simple string or icon |