Each entry in the oraPumpTable represents a Pump. Each entry is indexed first by applIndex, and then by oraPumpIndex; thus, there can be a one-to-many relationship between a Connection Manager and the pumps it manages. (For details about applIndex, see Appendix F, "Interpreting Implemented Variables of the Network Services MIB.") Current values of most oraPumpTable variables are retrieved directly or from calculations of buffers internal to the pump.
Table C - 9 lists the variables included in the oraPumpTable.
| Variable Name | Object ID |
| oraPumpIndex | 1.3.6.1.4.1.111.7.1.9.1.1 |
| oraPumpActiveTime | 1.3.6.1.4.1.111.7.1.9.1.2 |
| oraPumpTraceLevel | 1.3.6.1.4.1.111.7.1.9.1.3 |
| oraPumpTraceFile | 1.3.6.1.4.1.111.7.1.9.1.4 |
| oraPumpActiveConnections | 1.3.6.1.4.1.111.7.1.9.1.5 |
| oraPumpSuccessfulConnections | 1.3.6.1.4.1.111.7.1.9.1.6 |
| oraPumpFailedConnections | 1.3.6.1.4.1.111.7.1.9.1.7 |
| oraPumpAccumulatedBytesSent | 1.3.6.1.4.1.111.7.1.9.1.8 |
| oraPumpCurrentBytesPerSecond | 1.3.6.1.4.1.111.7.1.9.1.9 |
| oraPumpMaximumAverageBytes | 1.3.6.1.4.1.111.7.1.9.1.10 |
| oraPumpImmediateAverageBytes | 1.3.6.1.4.1.111.7.1.9.1.11 |
| oraPumpMaximumConnectTime | 1.3.6.1.4.1.111.7.1.9.1.12 |
| oraPumpMinimumConnectTime | 1.3.6.1.4.1.111.7.1.9.1.13 |
| oraPumpAverageConnectTime | 1.3.6.1.4.1.111.7.1.9.1.14 |
| oraPumpMaximumConnectDuration | 1.3.6.1.4.1.111.7.1.9.1.15 |
| oraPumpMaximumBuffers | 1.3.6.1.4.1.111.7.1.9.1.16 |
| oraPumpBufferUtilization | 1.3.6.1.4.1.111.7.1.9.1.17 |
| oraPumpErrors | 1.3.6.1.4.1.111.7.1.9.1.18 |
| oraPumpErrorMessage | 1.3.6.1.4.1.111.7.1.9.1.19 |
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 pumps a Connection Manager can start. |
| Typical Range | 1 - 100 or more |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | not applicable |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the time (in minutes) a Pump remains active after the last connection disconnects. This parameter is defined in the INTCHG.ORA file. The default is 5. |
| Typical Range | 1..2147483647 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (1 - 17) |
| Max-Access | read-write |
| Explanation | Indicates the level at which a Pump should be traced. A value of 4 means that tracing at the USER level is turned on; and 6 means that tracing at the ADMIN level is turned on. A value of 17 means that tracing is turned off. |
| Typical Range | enumerated 1 - 17 |
| Significance | important |
| Related Variables | oraPumpTraceFile |
| Suggested Presentation | as an icon, or as a simple string, OFF, USER or ADMIN |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the name of the trace file the Pump created. The default trace file name is specific to the operating system; on a UNIX platform, it is $ORACLE_HOME/network/trace/pmp_pid.trc, where pid is the process ID of the Pump. |
| Typical Range | 1 - 255 characters |
| Significance | important |
| Related Variables | oraPumpTraceLevel |
| Suggested Presentation | simple string |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | Indicates the number of connections that are currently active in a pump. |
| Typical Range | 0 - 100, or more |
| Significance | important |
| Related Variables | oraCmanagerMaximumConnectionsPerPump |
| Suggested Presentation | gauge |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates the total number of successful connections through a pump. This value resets to 0 if the Connection Manager restarts the pump at a later time. |
| Typical Range | 0 - 4294967295 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | counter |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates the total number of unsuccessful connections through a pump. This value resets to 0 when the Connection Manager restarts the pump at a later time. |
| Typical Range | 0 - 4294967295 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | counter |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates the total number of bytes sent through a pump. This value resets to 0 when the Connection Manger restarts the pump at a later time. |
| Typical Range | 0 - 4294967295 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | counter |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the current number of bytes sent (per second) through a pump. |
| Typical Range | 1..10,000 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the maximum average number of bytes sent through a pump. |
| Typical Range | 1..10,000 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the immediate average number of bytes sent through a pump. |
| Typical Range | 1..10,000 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the maximum time (in centiseconds) to establish a connection through a pump. |
| Typical Range | 1 - 1,000 or more, depending on network load |
| Significance | less important |
| Related Variables | oraPumpAverageConnectTime, oraPumpMinimumConnectTime |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the minimum time (in centiseconds) to establish a connection through a pump. |
| Typical Range | 1..1,000, depending on network load |
| Significance | less important |
| Related Variables | oraPumpAverageConnectTime, oraPumpMaximumConnectTime |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the average time (in centiseconds) to establish a connection through a pump. |
| Typical Range | 1 - 1,000, depending on network load |
| Significance | less important |
| Related Variables | oraPumpMinimumConnectTime, oraPumpMaximumConnectTime |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the maximum connection duration time (in centiseconds). This value is the elapsed time from when a connection is established through a pump until the time it is terminated. |
| Typical Range | varies, depending on network load |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | clock or gauge |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-write |
| Explanation | Indicates the maximum number of buffers available for use by the connections in a pump. |
| Typical Range | 1 - 100 |
| Significance | less important |
| Related Variables | oraPumpBufferUtilization |
| Suggested Presentation | gauge |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | Indicates the pump buffer utilization in percentage. |
| Typical Range | 1 - 100 |
| Significance | less important |
| Related Variables | oraPumpMaximumBuffers |
| Suggested Presentation | gauge |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the error stack of a Pump when it fails. This error stack contains the error codes reported in the NS and NT layers. |
| Typical Range | 1 - 255 characters |
| Significance | important |
| Related Variables | oraPumpErrorMessage |
| Suggested Presentation | simple string |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the error message generated when a Pump fails. |
| Typical Range | 1 - 255 characters |
| Significance | important |
| Related Variables | oraPumpErrors |
| Suggested Presentation | simple string |