📄 rfc1697.txt
字号:
local and remote conversations (usually SQL connects). applOutboundAssociations is not provided by this MIB. applAccumulatedInboundAssociations is the total number of local and remote conversations started since the server came up. applAccumulatedOutbound associations is not provided by this MIB. applLastInboundActivity is the time the most recent local orBrower, Purvy, Daniel, Sinykin & Smith [Page 19]RFC 1697 RDBMS-MIB August 1994 remote conversation was attempted or disconnected. applLastOutboundActivity is not provided by this MIB. applRejectedInboundAssociations is the number of local or remote conversations rejected by the server for administrative reasons or because of resource limitations. applFailedOutboundAssociations is not provided by this MIB." ::= { rdbmsObjects 6 } rdbmsSrvInfoEntry OBJECT-TYPE SYNTAX RdbmsSrvInfoEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "Information that must be present for a single 'up' database server, with visibility determined by the value of the corresponding applOperStatus object. If an instance of applOperStatus is not up(1), then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned by the agent." INDEX { applIndex } ::= { rdbmsSrvInfoTable 1 } RdbmsSrvInfoEntry ::= SEQUENCE { rdbmsSrvInfoStartupTime DateAndTime, rdbmsSrvInfoFinishedTransactions Gauge32, rdbmsSrvInfoDiskReads Counter32, rdbmsSrvInfoDiskWrites Counter32, rdbmsSrvInfoLogicalReads Counter32, rdbmsSrvInfoLogicalWrites Counter32, rdbmsSrvInfoPageWrites Counter32, rdbmsSrvInfoPageReads Counter32, rdbmsSrvInfoDiskOutOfSpaces Counter32, rdbmsSrvInfoHandledRequests Counter32, rdbmsSrvInfoRequestRecvs Counter32, rdbmsSrvInfoRequestSends Counter32, rdbmsSrvInfoHighwaterInboundAssociations Gauge32, rdbmsSrvInfoMaxInboundAssociations Gauge32 } rdbmsSrvInfoStartupTime OBJECT-TYPE SYNTAX DateAndTime MAX-ACCESS read-onlyBrower, Purvy, Daniel, Sinykin & Smith [Page 20]RFC 1697 RDBMS-MIB August 1994 STATUS current DESCRIPTION "The date and time at which this server was last started." ::= { rdbmsSrvInfoEntry 1 } rdbmsSrvInfoFinishedTransactions OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of transactions visible to this server that have been completed by either commit or abort. Some database operations, such as read-only queries, may not result in the creation of a transaction." ::= { rdbmsSrvInfoEntry 2 } rdbmsSrvInfoDiskReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of reads of database files issued to the operating system by this server since startup. Numbers are not comparable between products. What constitutes a readand how it is accounted is product-specific." ::= { rdbmsSrvInfoEntry 3 } rdbmsSrvInfoLogicalReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of logical reads of database files made internally by this server since startup. The values of this object and those of rdbmsSrvInfoDiskReads reveal the effect of caching on read operation. Numbers are not comparable between products, and may only be meaningful when aggregated across all servers sharing a common cache." ::= { rdbmsSrvInfoEntry 4 } rdbmsSrvInfoDiskWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of writes to database files issued to the operating system by this server since startup. Numbers are not comparable between products."Brower, Purvy, Daniel, Sinykin & Smith [Page 21]RFC 1697 RDBMS-MIB August 1994 ::= { rdbmsSrvInfoEntry 5 } rdbmsSrvInfoLogicalWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "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." ::= { rdbmsSrvInfoEntry 6 } rdbmsSrvInfoPageReads OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of pages in database files read by this server since startup. 'Pages' are product specific units of disk i/o operations. This value, along with rdbmsSrvInfoDiskReads, reveals the effect of any grouping read-ahead that may be used to enhance performance of some queries, such as scans." ::= { rdbmsSrvInfoEntry 7} rdbmsSrvInfoPageWrites OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of pages in database files written by this server since startup. Pages are product-specific units of disk I/O. This value, with rdbmsSrvInfoDiskWrites, shows the effect of write strategies that collapse logical writes of contiguous pages into single calls to the operating system." ::= { rdbmsSrvInfoEntry 8 } rdbmsSrvInfoDiskOutOfSpaces OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTIONBrower, Purvy, Daniel, Sinykin & Smith [Page 22]RFC 1697 RDBMS-MIB August 1994 "The total number of times the server has been unable to obtain disk space that it wanted, since server startup. This would be inspected by an agent on receipt of an rdbmsOutOfSpace trap." ::= { rdbmsSrvInfoEntry 9 } rdbmsSrvInfoHandledRequests OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The total number of requests made to the server on inbound associations. The meaning of 'requests' is product specific, and is not comparable between products. This is intended to encapsulate high level semantic operations between clients and servers, or between peers. For instance, one request might correspond to a 'select' or an 'insert' statement. It is not intended to capture disk i/o described in rdbmsSrvInfoDiskReads and rdbmsSrvInfoDiskWrites." ::= { rdbmsSrvInfoEntry 10 } rdbmsSrvInfoRequestRecvs OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of receive operations made processing any requests on inbound associations. The meaning of operations is product specific, and is not comparable between products. This is intended to capture lower-level i/o operations than shown by HandledRequests, between clients and servers, or between peers. For instance, it might roughly correspond to the amount of data given with an 'insert' statement. It is not intended to capture disk i/o described in rdbmsSrvInfoDiskReads and rdbmsSrvInfoDiskWrites." ::= { rdbmsSrvInfoEntry 11 } rdbmsSrvInfoRequestSends OBJECT-TYPE SYNTAX Counter32 MAX-ACCESS read-only STATUS current DESCRIPTION "The number of send operations made processing requests handled on inbound associations. The meaning of operations is product specific, and is not comparable between products.Brower, Purvy, Daniel, Sinykin & Smith [Page 23]RFC 1697 RDBMS-MIB August 1994 This is intended to capture lower-level i/o operations than shown by HandledRequests, between between clients and servers, or between peers. It might roughly correspond to the number of rows returned by a 'select' statement. It is not intended to capture disk i/o described in DiskReads." ::= { rdbmsSrvInfoEntry 12 } rdbmsSrvInfoHighwaterInboundAssociations OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-only STATUS current DESCRIPTION "The greatest number of inbound associations that have been simultaneously open to this server since startup." ::= { rdbmsSrvInfoEntry 13 } rdbmsSrvInfoMaxInboundAssociations OBJECT-TYPE SYNTAX Gauge32 MAX-ACCESS read-write STATUS current DESCRIPTION "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. Note that a compliant agent does not need to allow write access to this object." ::= { rdbmsSrvInfoEntry 14 } ---------------------------------------------------------------- rdbmsSrvParamTable OBJECT-TYPE SYNTAX SEQUENCE OF RdbmsSrvParamEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "The table of configuration parameters for a server. Entries should be populated according to the following guidelines: (1) The value should be specified through administrative (human) intervention. (2) It should be configured on a per-server or a more global basis, with duplicate entries for each server sharing use of the parameter. (3) One of the following is true: (a) The parameter has a non-numeric value; (b) The current value is numeric, but it only changes due to human intervention;Brower, Purvy, Daniel, Sinykin & Smith [Page 24]RFC 1697 RDBMS-MIB August 1994 (c) The current value is numeric and dynamic, but the RDBMS does not track access/allocation failures related to the parameter; (d) The current value is numeric and dynamic, the RDBMS tracks changes in access/allocation failures related to the parameter, but the failure has no significant impact on RDBMS performance or availability. (e) The current value is numeric and dynamic, the RDBMS tracks changes in access/allocation failures related to the parameter, the failure has significant impact on RDBMS performance or availability, and is shown in the rdbmsSrvLimitedResource table." ::= { rdbmsObjects 7 } rdbmsSrvParamEntry OBJECT-TYPE SYNTAX RdbmsSrvParamEntry MAX-ACCESS not-accessible STATUS current DESCRIPTION "An entry for a single configuration parameter for a server. Parameters with single values have a subindex value of one. If the parameter is naturally considered to contain a variable number of members of a class, e.g. members of the DBA user group, or tracepoints active in the server, then it must be presented as a set of rows. If, on the other hand, the parameter represents a set of choices from a class, e.g. the permissions on a file or the options chosen out of the set of all options allowed, AND is guaranteed to always fit in the 255 character length of a DisplayString, then it may be presented as a comma separated list with a subindex value of one. Zero may not be used as a subindex value. Entries for a server must be present if the value of the corresponding applOperStatus object is up(1). If an instance of applOperStatus is not up(1), then attempts to access corresponding instances in this table may result in either noSuchName (SNMPv1) or noSuchInstance (SNMPv2) being returned by the agent." INDEX { applIndex, rdbmsSrvParamName, rdbmsSrvParamSubIndex } ::= { rdbmsSrvParamTable 1 } RdbmsSrvParamEntry ::= SEQUENCE { rdbmsSrvParamName DisplayString, rdbmsSrvParamSubIndex INTEGER, rdbmsSrvParamID AutonomousType,
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -