Oracle SNMP Support Reference Guide

Contents Glossary Index Home Previous Next

rdbmsDbInfoTable

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 E - 2 lists each rdbmsDbInfoTable variable that Oracle is implementing, together with its corresponding object ID.

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.

Table E - 2. rdbmsDbInfoTable Variables and Corresponding Object IDs

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.

rdbmsDbInfoProductName

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

rdbmsDbInfoVersion

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

rdbmsDbInfoSizeUnits

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

rdbmsDbInfoSizeAllocated

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

rdbmsDbInfoSizeUsed

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

Contents Glossary Index Home Previous Next