Oracle® Enterprise Manager SNMP Support Reference Guide 10g Release 2 Part Number B16244-02 |
|
|
View PDF |
This appendix provides information to help you interpret individual variables in the Oracle implementation of the public RDBMS MIB. Note that this appendix emphasizes Oracle's implementation. For information concerning other implementation alternatives for these variables, refer to MIB itself.
This appendix includes sections covering public RDBMS MIB variables that Oracle implements in the following tables
Note that Oracle does not implement the following tables of the public RDBMS MIB:
rdbmsDbParamTable
rdbmsDbLimitedResourceTable
rdbmsSrvLimitedResourceTable
Attempts to access any of the variables that Oracle is not implementing results in noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned.
The rdbmsDbTable contains general information on each database installed on the managed node. Any installed database that has been configured for SNMP support, whether or not it is actively opened, is represented by a row in the rdbmsDbTable.
Each entry in the rdbmsDbTable represents a given database installed on the node. Each entry is indexed by rdbmsDbIndex. The current values of the rdbmsDbTable variables are retrieved from a variety of sources on the managed node.
Oracle implements all rdbmsDbTable variables; Table D-1 lists each of them, together with its corresponding object ID.
Syntax
INTEGER (1 - 2147483647)
Max-Access
not-accessible
Explanation
A numeric index, unique among all of the vendors' databases installed on this managed node. This value is a surrogate for the conceptually unique key, which is {vendorOID, databasename}. In the Oracle implementation, the value of this variable when not running Oracle Real Application Clusters is the value of rdbmsSrvIndex for this installed database server.
Typical Range
1 - 10
Significance
very important
Related Variables
rdbmsSrvIndex
Suggested Presentation
not applicable
Syntax
OBJECT IDENTIFIER
Max-Access
read-only
Explanation
Displays the authoritative identification for the private MIB of this installed database. In the Oracle implementation, the value of rdbmsDbVendorOID is hardcoded as the root of Oracle's OID subtree (1.3.6.1.4.1.111).
Typical Range
1.3.6.1.4.1.111 (only)
Significance
very important
Related Variables
rdbmsSrvVendorOID
Suggested Presentation
simple string
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the name of the vendor whose RDBMS manages this installed database, for informational purposes. In the Oracle implementation, the value of this variable is hardcoded in the subagent as ÒOracle.Ó
Typical Range
6 characters (only)
Significance
important
Related Variables
rdbmsSrvVendorName
Suggested Presentation
icon or simple string
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the name of this installed database, in product-specific format. In the Oracle implementation, the value of rdbmsDbName is retrieved from snmp.visibleservices parameter of the SNMP_RO.ORA configuration file. This name is globally unique and includes domain information.
Typical Range
5 - 25 characters
Significance
important
Related Variables
rdbmsSrvName
Suggested Presentation
icon or simple string
Syntax
DisplayString
Max-Access
read/write
Explanation
Displays the name of the contact person for this installed database, together with information indicating how to contact this person. In the Oracle implementation, the value of this variable is retrieved from the SNMP_RW.ORA configuration file
Typical Range
2 - 255 characters
Significance
important
Related Variables
rdbmsSrvContact
Suggested Presentation
simple string
The rdbmsDbInfoTable contains additional general information about actively opened database instances on the managed node. If an installed database has been configured for SNMP support but is not actively opened, then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1), or noSuchInstance (SNMPv2). ÒActively openedÓ is determined by the values of all the rdbmsRelState entries for this database in the rdbmsRelTable.
Each entry in the rdbmsDbInfoTable represents a particular actively opened database instance on the node. Each entry is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each database installed on that node, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. The current value of the rdbmsDbInfoTable variable are retrieved from a variety of sources on the managed node.
Table D-2 lists each rdbmsDbInfoTable variable that Oracle is implementing, together with its corresponding object ID.
Table D-2 rdbmsDbInfoTable Variables and Corresponding Object IDs
Variable Name | Object ID |
---|---|
rdbmsDbInfoProductName |
1.3.6.1.2.1.39.1.2.1.1 |
rdbmsDbInfoVersion |
1.3.6.1.2.1.39.1.2.1.2 |
rdbmsDbInfoSizeUnits |
1.3.6.1.2.1.39.1.2.1.3 |
rdbmsDbInfoSizeAllocated |
1.3.6.1.2.1.39.1.2.1.4 |
rdbmsDbInfoSizeUsed |
1.3.6.1.2.1.39.1.2.1.5 |
rdbmsDbInfoLastBackup* |
1.3.6.1.2.1.39.1.2.1.6 |
* Variables marked with an asterisk are not supported.
Attempts to access these variables may result in errors.
Note that Oracle is not implementing rdbmsDbInfoLastBackup because Oracle allows individual tablespaces to be backed up; thus, the time of the last full database backup is not meaningful.
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the textual product name of the server that created or last restructured this database instance. In the Oracle implementation, the value of this variable is retrieved from the BANNER field in V$VERSION.
Typical Range
253 characters
Significance
important
Related Variables
rdbmsSrvProductName
Suggested Presentation
icon or simple string
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the version number of the server that created or last restructured this database instance. The format is specific to the product. In the Oracle implementation, the value of this variable is derived internally.
Typical Range
not applicable
Significance
important (depending on the application)
Related Variables
applVersion
Suggested Presentation
simple string
Syntax
INTEGER (1) bytes, (2) kbytes, (3) mbytes, (4) gbytes, or (5) tbytes.
Max-Access
read/write
Explanation
Displays the units used to measure the size of this database instance, as indicated by the values for rdbmsDbInfoSizeAllocated and rdbmsDbInfoSizeUsed. In the Oracle implementation, the value of rdbmsDbInfoSizeUnits is the least that allows rdbmsDbInfoSizeAllocated to be expressed as a 32-bit integer.
(1) bytes, indicates size measured in bytes; (2) kbytes, indicates units of kilobytes; (3) mbytes, indicates units of megabytes; (4) gbytes, indicates units of gigabytes; or (5) tbytes, indicates units of terabytes. Each of these unit measurements are binary multiples (1K = 1024).
Typical Range
enumerated 1 - 5
Significance
very important
Related Variables
rdbmsDbInfoSizeAllocated, rdbmsDbInfoSizeUsed
Suggested Presentation
simple string
Syntax
INTEGER (1 - 2147483647)
Max-Access
read/write
Explanation
Displays the estimated size of this database instance (in rdbmsDbInfoSizeUnits), which is the disk space that has been allocated to it and is no longer available to users on this host. The rdbmsDbInfoSizeAllocated variable does not necessarily indicate the amount of space actually in use for database data; rdbmsDbInfoSizeUsed retrieves this value instead. In the Oracle implementation, the value of this variable is the sum of the BYTES field for the rows of the DBA_DATA_FILES tables.
Typical Range
1 - 2147483647
Significance
very important
Related Variables
rdbmsDbInfoSizeUnits, rdbmsDbInfoSizeUsed
Suggested Presentation
simple string or gauge
Syntax
INTEGER (1 - 2147483647)
Max-Access
read-only
Explanation
Displays the estimated size of this database instance (in rdbmsDbInfoSizeUnits), actually in use for database data. In the Oracle implementation, the value of rdbmsDbInfoSizeUsed is the sum of values in the BYTES field of DBA_DATA_FILES minus the sum of values in the BYTES field of DBA_FREE_SPACE. rdbmsDbInfoSizeUsed should always be less than or equal to rdbmsDbInfoSizeAllocated.
Typical Range
1 - 2147483647
Significance
very important
Related Variables
rdbmsDbInfoSizeAllocated, rdbmsDbInfoSizeUnits
Suggested Presentation
gauge
The rdbmsSrvTable contains generic information on each database server installed on the managed node. In the standard Oracle configuration, one server supports one database. Thus, while the content of rdbmsSrvTable essentially mirrors the content of rdbmsDbTable, Oracle has chosen to implement both tables in order to fully adhere to one of the central precepts of the public RDBMS MIB standard. This precept is that a distinction between the database and its server must be made, in order to account for other vendors' architectures.
Any installed database that has been configured for SNMP support, whether or not it is actively opened, is represented by a row in the rdbmsDbTable. Each entry in the rdbmsSrvTable represents a given database server on the node. Each entry is indexed by applIndex. The current value of each rdbmsSrvTable variable is retrieved directly from a variety of sources on the managed node.
Oracle implements all rdbmsSrvTable variables. Table D-3 lists each of them, together with its corresponding object ID.
Syntax
OBJECT IDENTIFIER
Max-Access
read-only
Explanation
Displays the authoritative identification for the private MIB for this server. In the Oracle implementation, the value of this variable is hardcoded as the root of Oracle's OID subtree (1.3.6.1.4.1.111). If no OBJECT IDENTIFIER exists for the private MIB, attempts to access this object will return noSuchName (SNMPv1) or noSuchInstance (SNMPv2).
Typical Range
1.3.6.1.4.1.111 (only)
Significance
very important
Related Variables
rdbmsDbVendorOID
Suggested Presentation
simple string
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the name of the vendor of this installed database server. In the Oracle implementation, the value of this variable is hardcoded in the subagent as ÒOracle.Ó
Typical Range
6 characters (only)
Significance
important
Related Variables
rdbmsDbVendorName
Suggested Presentation
icon or simple string
Syntax
DisplayString
Max-Access
read-only
Explanation
Displays the product name of this server. In the Oracle implementation, the value of this variable is hardcoded as ÒOracle7 server.Ó
Typical Range
14 characters (only)
Significance
important
Related Variables
rdbmsDbInfoProductName
Suggested Presentation
icon or simple string
Syntax
DisplayString
Max-Access
read/write
Explanation
Displays the textual identification of the contact person for this managed server, together with information indicating how to contact this person. In the Oracle implementation, the value of this variable is retrieved from the SNMP_RW.ORA configuration file
Typical Range
0 - 255 characters
Significance
important
Related Variables
rdbmsDbContact
Suggested Presentation
simple string
The rdbmsSrvInfoTable contains additional information about each database server instance actively running on the managed node. The visibility of a database server instance in rdbmsSrvInfoTable is determined by the value of the corresponding applOperStatus object for that database server. (For details about applOperStatus, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB") Monitoring these variables is important for tuning server functions such as I/O, access and activity.
Each entry in the rdbmsDbSrvInfoTable represents a given actively opened database server instance on the node. Each entry is indexed by applIndex. The current value of each rdbmsSrvInfoTable variable is retrieved directly from various V$ dynamic performance tables of this database server instance.
Table D-4 lists each of the rdbmsDbInfoTable variables that Oracle is implementing, together with its corresponding object ID.
Table D-4 rdbmsDbSrvInfoTable Variables and Corresponding Object IDs
Variable Name | Object ID |
---|---|
rdbmsSrvInfoStartupTime |
1.3.6.1.2.1.39.1.6.1.1 |
rdbmsSrvInfoFinishedTransactions |
1.3.6.1.2.1.39.1.6.1.2 |
rdbmsSrvInfoDiskReads |
1.3.6.1.2.1.39.1.6.1.3 |
rdbmsSrvInfoLogicalReads |
1.3.6.1.2.1.39.1.6.1.4 |
rdbmsSrvInfoDiskWrites |
1.3.6.1.2.1.39.1.6.1.5 |
rdbmsSrvInfoLogicalWrites |
1.3.6.1.2.1.39.1.6.1.6 |
rdbmsSrvInfoPageReads |
1.3.6.1.2.1.39.1.6.1.7 |
rdbmsSrvInfoPageWrites |
1.3.6.1.2.1.39.1.6.1.8 |
rdbmsSrvInfoDiskOutOfSpaces* |
1.3.6.1.2.1.39.1.6.1.9 |
rdbmsSrvInfoRequestsHandled |
1.3.6.1.2.1.39.1.6.1.10 |
rdbmsSrvInfoRequestsRecvs* |
1.3.6.1.2.1.39.1.6.1.11 |
rdbmsSrvInfoRequestSends* |
1.3.6.1.2.1.39.1.6.1.12 |
rdbmsSrvInfoHighwaterIn-boundAssociations |
1.3.6.1.2.1.39.1.6.1.13 |
rdbmsSrvInfoMaxInboundAssociations |
1.3.6.1.2.1.39.1.6.1.14 |
* Variables marked with an asterisk are not supported. Attempts to access these variables may result in errors.
Oracle is not implementing the following rdbmsDbInfoTable variables:
rdbmsSrvInfoDiskOutOfSpaces
rdbmsSrvInfoRequestRecvs
rdbmsSrvInfoRequestSends
Syntax
DateAndTime
Max-Access
read-only
Explanation
Displays the date and time at which this server was last started. In the Oracle implementation, the value of this variable is computed from the STARTUP TIME-JULIAN and STARTUP TIME-SECONDS fields in V$INSTANCE.
Typical Range
not applicable
Significance
important
Related Variables
applUpTime
Suggested Presentation
simple string
Syntax
Gauge32
Max-Access
read-only
Explanation
Displays the number of transactions (visible to this server) upon which either COMMIT or ABORT operations have been completed since startup of this database server instance. Some database operations, such as read-only queries, may not result in the creation of a transaction. In the Oracle implementation, the value of this variable is the sum of USER ROLLBACKS and USER COMMITS from V$SYSSTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
none
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of reads of database files this server has issued to the operating system since startup of this database server instance. In the Oracle implementation, the value of this variable is retrieved from PHYSICAL READS in V$SYSSTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoLogicalReads, rdbmsSrvInfoPageReads
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of logical reads of database files that this server has made internally since startup. This value and the value of rdbmsSrvInfoDiskReads reveal the effect of caching on read operations. In the Oracle implementation, the value of this variable is the sum of CONSISTENT GETS and DB BLOCK GETS in V$SYSSTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoDiskReads
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of writes to database files this server has issued to the operating system since startup. In the Oracle implementation, the value of this variable is retrieved from PHYSICAL WRITES in V$SYSSTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoPageWrites, rdbmsSrvInfoLogicalWrites
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
The total number of times parts of the database files have been marked ÒdirtyÓ and in need of writing to the disk. This value and rdbmsSrvInfoDiskWrites give some indication of the effect of Òwrite-behindÓ strategies in reducing the number of disk writes compared to database operations. Because the writes may be done by servers other than those marking the parts of the database files dirty, these values may only be meaningful when aggregated across all servers sharing a common cache. Numbers are not comparable between products. In the Oracle implementation, the value of this variable is retrieved from DB BLOCK CHANGES in V$SYSSTAT.
Typical Range
0..4294967295
Significance
very important
Related Variables
rdbmsSrvInfoDiskWrites
Suggested Presentation
counter32
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of pages in database files this server has read since startup of this database server instance. ÒPagesÓ are product-specific units of disk I/O operations. This value, together with the value of rdbmsSrvInfoDisksReads, reveals the effect of any grouping read-ahead that may be used to enhance performance of some queries, such as scans. In the Oracle implementation, the value of this variable is the sum of all PHYBLKRD entries in V$FILESTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoDiskReads
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of pages in database files this server has written since this startup of this database server instance. Pages are product-specific units of disk I/O. This value, together with the value of rdbmsSrvInfoDiskWrites, shows the effect of write strategies that collapse logical writes of continuous pages into single calls to the operating system. In the Oracle implementation, the value of this variable is the sum of all PHYBLKWRT entries in V$FILESTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoDiskWrites
Suggested Presentation
counter
Syntax
Counter32
Max-Access
read-only
Explanation
Displays the total number of requests made to the server on inbound associations since this startup of this database server instance.
In the Oracle implementation, the value of this variable is retrieved from Òuser callsÓ in V$SYSSTAT.
Typical Range
0 - 4294967295
Significance
very important
Related Variables
rdbmsSrvInfoRequestRecvs, rdbmsSrvInfoRequestSends
Suggested Presentation
counter
Syntax
Gauge32
Max-Access
read-only
Explanation
Displays the greatest number of inbound associations that have been simultaneously open to this server since this startup of this database server instance. In the Oracle implementation, the value of this variable is retrieved from SESSION_HIGHWATER in V$LICENSE.
Typical Range
0 - value of rdbmsSrvInfoMaxInboundAssociations
Significance
important
Related Variables
rdbmsSrvInfoMaxInboundAssociations
Suggested Presentation
gauge
Syntax
INTEGER (1..2147483647)
Max-Access
read/write
Explanation
Displays the greatest number of inbound associations that can be simultaneously open with this server. If there is no limit, then the value should be zero. In the Oracle implementation, the value of this variable is retrieved from SESSIONS_MAX in V$LICENSE.
Typical Range
1 - 2147483647
Significance
important
Related Variables
applInboundAssociations, rdbmsSrvInfoHighwaterInboundAssociations
Suggested Presentation
simple string
The rdbmsSrvParamTable contains configuration parameters for a database server installed on this managed node. This table roughly corresponds to the oraDbConfigTable of the private Oracle Database MIB, covered in Appendix B, "Interpreting Variables of the Oracle Database MIB". If you are developing an Oracle-specific application, you not need to concern yourself with this table; instead, you should focus your attention on oraDbConfigTable, which has been designed for more convenient use.
Each entry in the rdbmsSrvParamTable represents a particular configuration parameter for a database server on the node. Each entry is indexed first by applIndex, then by rdbmsSrvParamName, and finally by rdbmsSrvParamSubIndex; thus, there normally is a one-to-many relationship between a database server and its configuration parameters, and a one-to-many relationship between a configuration parameter and its multiple values. (For details about applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB") However, in the Oracle implementation, multiple values for a configuration parameter are concatenated into a single entry for that parameter. The current value of each rdbmsSrvInfoTable variable is retrieved directly from a corresponding variable in the INIT.ORA configuration file for this database server.
Entries for a server must be present if the value of the corresponding applOperStatus object is up (1). (See Appendix E, "Interpreting Implemented Variables of the Network Services MIB" for more information on the applOperStatus object.) If an instance of applOperStatus is not up (not 1), then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned by the agent.
Table D-5 lists each rdbmsSrvParamTable variable that Oracle is implementing, together with its corresponding object ID.
Table D-5 rdbmsDbSrvParamTable Variables and Corresponding Object IDs
Variable Name | Object ID |
---|---|
rdbmsSrvParamName |
1.3.6.1.2.1.39.1.7.1.1 |
rdbmsSrvParamSubIndex |
1.3.6.1.2.1.39.1.7.1.2 |
rdbmsSrvParamID* |
1.3.6.1.2.1.39.1.7.1.3 |
rdbmsSrvParamCurrValue |
1.3.6.1.2.1.39.1.7.1.4 |
rdbmsSrvComment* |
1.3.6.1.2.1.39.1.7.1.5 |
* Variables marked with an asterisk are not supported. Attempts to access these variables may result in errors.
Oracle is not implementing the following rdbmsSrvParamTable variables:
rdbmsSrvParamComment
rdbmsSrvParamID
Syntax
DisplayString (1..64)
Max-Access
not-accessible
Explanation
Displays the name of a configuration parameter for a server. This name is product- specific. The length is limited to 64 characters to minimize traffic of keys and to fit on one line. In the Oracle implementation, the value of this variable is the name of a parameter in the INIT.ORA file.
Typical Range
1 - 45 characters
Significance
less important
Related Variables
each oraDbConfigTable variable
Suggested Presentation
simple string
Syntax
INTEGER (1 - 2147483647)
Max-Access
not-accessible
Explanation
The subindex value for this parameter. In this Oracle implementation, the value of this variable is always 1.
Typical Range
1 (only)
Significance
less important
Related Variables
none
Suggested Presentation
not applicable
Syntax
DisplayString
Max-Access
read/write
Explanation
Displays the current value for this configuration parameter, as retrieved from the INIT.ORA file in the Oracle implementation.
Typical Range
0 - 255 characters
Significance
less important
Related Variables
oraDbConfigTable variables
Suggested Presentation
simple string
The rdbmsRelTable indicates how databases and servers on this managed node are related. In the standard Oracle implementation, one server supports one database; nevertheless, this table has been implemented in order to fully adhere to the public RDBMS MIB standard.
Each entry in the rdbmsDbRelTable represents a mapping between a database server and a database on the node. Each entry is indexed first by rdbmsDbIndex, and then by applIndex; thus, for the standard Oracle configuration of one server per database, these two indexes are the same. (For details on applIndex, see Appendix E, "Interpreting Implemented Variables of the Network Services MIB")
Table D-6 lists the rdbmsRelTable variable that Oracle is implementing, together with its corresponding object ID.
Syntax
INTEGER (2) active or (5) unavailable.
Max-Access
read/write
Explanation
Displays the state of this server's access to this database. Oracle implements (2) active and unavailable (5) only. Active (2) means the server is actively using the database. Unavailable (5) means the database is not available through this server.
Typical Range
2 or 5
Significance
very important
Related Variables
appleOperStatus, rdbmsStateChange
Suggested Presentation
icon or alarm
Unlike other SNMP variables, a trap variable is not an agent's response to a management station's request for information. Rather, it is a message that an agent can send unsolicited to a management station when that agent notices that some condition has occurred (a threshold has been reached, for example).
Table D-7 lists each rdbmsTraps variable and its corresponding object ID.
Objects
{rdbmsRelState}
Explanation
An rdbmsStateChange trap signifies that one of the database servers this on this node has changed its rdbmsRelState in a way that makes it less accessible for use. In the Oracle implementation, active (2) is considered fully accessible. The state sent with the trap is the new, less accessible state ((5) unavailable).
Typical Range
5 (only)
Significance
very important
Related Variables
rdbmsRelState
Suggested Presentation
alarm