Each entry in the oraSIDTable represents a current database instance for whom the listener listens. Each entry is indexed by oraSIDName.
Table B - 2 lists the variables included in the oraSIDTable.
Variable Name | Object ID |
oraSIDListenerIndex | 1.3.6.1.4.1.111.5.1.5.1.1 |
oraSIDName | 1.3.6.1.4.1.111.5.1.5.1.2 |
oraSIDCurrentConnectedClients | 1.3.6.1.4.1.111.5.1.5.1.3 |
oraSIDReservedConnections | 1.3.6.1.4.1.111.5.1.5.1.4 |
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 generic listeners on the managed node, that associates a listener with a database it listens on. This value is retrieved from the snmp.index.listener_name parameter of the SNMP.ORA configuration file. |
Typical Range | varies, depending on the value set in the snmp.index.listener-name field of the SNMP.ORA configuration file |
Significance | very important |
Related Variables | oraListenerIndex |
Suggested Presentation | not applicable |
Syntax | DisplayString |
Max-Access | read-only |
Explanation | A unique name identifying a database instance. This SID is in the definition of the listener, as retrieved from the SID_NAME parameter of the LISTENER.ORA configuration file. oraSIDName serves as the primary index in the oraDedicatedSrvTable, oraDispatcherTable, and oraPrespawnedSrvTable; thus, an entry for any dispatcher, dedicated server or prespawned server which listens for the database instance identified by oraSIDName can be found. |
Typical Range | 1 - 25 characters (physical limit is 255 characters) |
Significance | very important |
Related Variables | oraDedicatedSrvIndex, oraDispatcherIndex, oraPrespawnedSrvIndex |
Suggested Presentation | simple string or icon |
Syntax | Gauge32 |
Max-Access | read-only |
Explanation | Indicates the total number of clients currently connected through prespawned shadows and dispatchers to this database instance, as retrieved from an internal Listener table. When the value of oraSIDCurrentConnectedClients is approaching the value of oraSIDReservedConnections, the number of connection requests to this database instance is reaching the threshold (the reserved number of connections for clients on this database instance). |
When the value of oraSIDCurrentConnectedClients equals the value of oraSIDReservedConnections, the incoming connection requests are redirected to dedicated servers. This may not be desirable, as a dedicated server requires more system resources than does a dispatcher or prespawned shadow. | |
Typical Range | 0 - value of oraSIDReservedConnections |
Significance | very important |
Related Variables | oraDispatcherCurrentConnections, oraPrespawnedSrvCurrentConnections |
Suggested Presentation | gauge |
Syntax | Counter32 |
Max-Access | read-only |
Explanation | Indicates the total number of reserved connections for clients through prespawned shadows and dispatchers to this database instance. |
Typical Range | 0 - 1,000, depending on the number of dispatcher and prespawned shadow processes for the database |
Significance | very important |
Related Variables | oraDispatcherMaximumConnections, oraSIDCurrentConnectedClients |
Suggested Presentation | gauge |