Each entry in the oraConnectionTable represents a connection. Each entry is indexed first by applIndex, then by oraPumpIndex, and finally by oraConnectionIndex; thus, there is a one-to-many relationship between a Connection Manager and the Pumps it manages, and a one-to-many relationship between a Pump and the connections it controls. (For details about applIndex, see Appendix F, "Interpreting Implemented Variables of the Network Services MIB.") The current value of each oraConnectionTable variable is retrieved from an internal pump table.
Table C - 13 lists the variables included in the oraConnectionTable.
| Variable Name | Object ID |
| oraConnectionIndex | 1.3.6.1.4.1.111.7.1.12.1.1 |
| oraConnectionPumpID | 1.3.6.1.4.1.111.7.1.12.1.2 |
| oraConnectionIdleTime | 1.3.6.1.4.1.111.7.1.12.1.3 |
| oraConnectionDuration | 1.3.6.1.4.1.111.7.1.12.1.4 |
| oraConnectionSourceAddress | 1.3.6.1.4.1.111.7.1.12.1.5 |
| oraConnectionDestinationAddress | 1.3.6.1.4.1.111.7.1.12.1.6 |
A description of each of these variables follows.
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | A numeric index, unique among all of the connections a pump can start. |
| Typical Range | 1 - 100, or more |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | not applicable |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the pump ID of a connection. |
| Typical Range | 1 - 100, or more |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | simple integer value |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-write |
| Explanation | The time (in minutes) a connection can remain idle before a Connection Manager will terminate it. A value of 0 (the default) means that there is no automatic timeout. |
| Typical Range | 1 - 5 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the time (in centiseconds) elapsed after a connection is established and before the connection is terminated. |
| Typical Range | varies, depending on network load |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | clock or gauge |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the source address of a connect request. |
| Typical Range | 1 - 255 characters |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | simple string |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the destination address of a connect request. |
| Typical Range | 1 - 255 characters |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | simple string |