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 |
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.
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 |