Each entry in the oraPrespawnedSrvTable represents a prespawned server associated with a current database instance. Each entry is indexed first by oraSIDName, and then by oraPrespawnedSrvIndex; thus, there can be a one-to-many relationship between a database instance and the prespawned servers serving it. Using this indexing method, all prespawned servers associated with a given SID can be found by SNMP traversal operations (get-next and get-bulk). The current value of most oraPrespawnedSrvTable variables is retrieved from internal listener buffers.
Table B - 5 lists the variables included in the oraPrespawnedSrvTable.
| Variable Name | Object ID |
| oraPrespawnedSrvIndex | 1.3.6.1.4.1.111.5.1.4.1.1 |
| oraPrespawnedSrvEstablishedConnections | 1.3.6.1.4.1.111.5.1.4.1.2 |
| oraPrespawnedSrvRejectedConnections | 1.3.6.1.4.1.111.5.1.4.1.3 |
| oraPrespawnedSrvCurrentConnections | 1.3.6.1.4.1.111.5.1.4.1.4 |
| oraPrespawnedSrvMaximumConnections | 1.3.6.1.4.1.111.5.1.4.1.5 |
| oraPrespawnedSrvState | 1.3.6.1.4.1.111.5.1.4.1.6 |
| oraPrespawnedSrvProtocolInfo | 1.3.6.1.4.1.111.5.1.4.1.7 |
| oraPrespawnedSrvProcessorID | 1.3.6.1.4.1.111.5.1.4.1.8 |
A description of each of these variables follows.
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | A numeric index, unique among the prespawned servers configured for this managed listener, as retrieved from an internal listener table. |
| Typical Range | 1 - 1,000, depending on the number of prespawned shadows configured |
| Significance | very important |
| Related Variables | none |
| Suggested Presentation | not applicable |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates how many incoming connection requests have been accepted by the prespawned server since its startup, as retrieved from an internal listener table. |
| Typical Range | 0 - 4249467295 |
| Significance | very important |
| Related Variables | none |
| Suggested Presentation | counter |
| Syntax | Counter32 |
| Max-Access | read-only |
| Explanation | Indicates the number of connection requests this prespawned server has rejected since its startup, as retrieved from an internal listener table. If the value of oraPrespawnedSrvRejectedConnections is creeping up, oraPrespawnedState should be monitored. |
| Typical Range | 0 - 4249467295 |
| Significance | very important |
| Related Variables | oraDedicatedSrvEstablishedConnections, oraPrespawnedSrvEstablishedConnections, oraPrespawnedSrvState |
| Suggested Presentation | counter |
| Syntax | Gauge32 |
| Max-Access | read-only |
| Explanation | Indicates how many incoming connection requests currently being redirected by the prespawned server since startup of this managed listener, as retrieved from an internal listener table. |
| Typical Range | 0 - 4249467295 |
| Significance | very important |
| Related Variables | oraPrespawnedSrvMaximumConnections |
| Suggested Presentation | gauge |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | Indicates the greatest number of connection requests that this prespawned server can accept. The Listener updates this value in real time. |
| Typical Range | 0 - 1,000, depending on the configuration |
| Significance | very important |
| Related Variables | oraPrespawnedSrvCurrentConnections |
| Suggested Presentation | gauge |
| Syntax | INTEGER (1) blocked, or (2) ready. |
| Max-Access | read-only |
| Explanation | Indicates the current state of the prespawned server, as retrieved from an internal listener table. The BLOCKED value (1) indicates that the prespawned server is temporarily not accepting redirected connection requests. The READY option (2) indicates that the prespawned server is ready to accept any redirected connection requests. |
| Typical Range | enumerated 1 or 2 |
| Significance | very important |
| Related Variables | oraPrespawnedSrvRejectedConnection |
| Suggested Presentation | alarm or icon |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the protocol on which this prespawned server listens, as well as protocol-specific information. This information is retrieved from an internal Listener table. |
| Typical Range | 1 - 255 characters |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | simple string or icon |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | Indicates the process ID of the prespawned server, as retrieved from an internal listener table. |
| Typical Range | 1 - 10, depending on the O/S (physical limit is 255 characters) |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | simple string |