Oracle SNMP Support Reference Guide
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 F, "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 E - 4 lists each of the rdbmsDbInfoTable variables that Oracle is implementing, together with its corresponding object ID.
| 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
|
| rdbmsSrvInfoMaxInboundAssoc-iations
| 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.
Table E - 4. rdbmsDbSrvInfoTable Variables and Corresponding Object IDs
Oracle is not implementing the following rdbmsDbInfoTable variables:
- rdbmsSrvInfoLogicalWrites
- rdbmsSrvInfoDiskOutOfSpaces
| 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
|
rdbmsSrvInfoLogicalWrites
| 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 "wreite-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. |
| | rdbmsSrvInfoRequestsHandled is intended to encapsulate high level semantic operations between clients and servers, or between peers. For example, one request might correspond to a SELECT or an INSERT statement. In contrast to rdbmsSrvInfoDiskReads or rdbmsSrvInfoDiskWrites, this variable is not intended to capture disk I/O operations. |
| | 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
|