Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

oraSIDTable

The oraSIDTable contains information about the status of connections to a current database instance. This information is important to monitor in order to ensure that clients seeking access to a database have that opportunity.

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
Table B - 2. oraSIDTable Variables and Corresponding Object IDs

A description of each of these variables follows.

oraSIDListenerIndex

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

oraSIDName

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

oraSIDCurrentConnectedClients

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

oraSIDReservedConnections

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

Contents Glossary Index Home Previous Next