Each entry in the oraDbConfigTable is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each installed database, 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. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.")
Table A - 7 lists each variable of the oraDbConfigTable and its corresponding object ID.
| Variable Name | Object ID |
| oraDbConfigDbBlockBuffers | 1.3.6.1.4.1.111.4.1.7.1.1 |
| oraDbConfigDbBlockCkptBatch | 1.3.6.1.4.1.111.4.1.7.1.2 |
| oraDbConfigDbBlockSize | 1.3.6.1.4.1.111.4.1.7.1.3 |
| oraDbConfigDbFileSimWrites | 1.3.6.1.4.1.111.4.1.7.1.4 |
| oraDbConfigDbMultiBlockReadCount | 1.3.6.1.4.1.111.4.1.7.1.5 |
| oraDbConfigDbWriters | 1.3.6.1.4.1.111.4.1.7.1.6 |
| oraDbConfigDistLockTimeout | 1.3.6.1.4.1.111.4.1.7.1.7 |
| oraDbConfigDistRecoveryConnectHold | 1.3.6.1.4.1.111.4.1.7.1.8 |
| oraDbConfigDistTransactions | 1.3.6.1.4.1.111.4.1.7.1.9 |
| oraDbConfigLogArchiveBufferSize | 1.3.6.1.4.1.111.4.1.7.1.10 |
| oraDbConfigLogArchiveBuffers | 1.3.6.1.4.1.111.4.1.7.1.11 |
| oraDbConfigLogBuffer | 1.3.6.1.4.1.111.4.1.7.1.12 |
| oraDbConfigLogCheckpointInteval | 1.3.6.1.4.1.111.4.1.7.1.13 |
| oraDbConfigLogCheckpointTimeout | 1.3.6.1.4.1.111.4.1.7.1.14 |
| oraDbConfigLogFiles | 1.3.6.1.4.1.111.4.1.7.1.15 |
| oraDbConfigLogSmallEntryMax | 1.3.6.1.4.1.111.4.1.7.1.16 |
| oraDbConfigMaxRollbackSegments | 1.3.6.1.4.1.111.4.1.7.1.17 |
| oraDbConfigMaxDispatchers | 1.3.6.1.4.1.111.4.1.7.1.18 |
| oraDbConfigMTSMaxServers | 1.3.6.1.4.1.111.4.1.7.1.19 |
| oraDbConfigMTSServers | 1.3.6.1.4.1.111.4.1.7.1.20 |
| oraDbConfigOpenCursors | 1.3.6.1.4.1.111.4.1.7.1.21 |
| oraDbConfigOpenLinks | 1.3.6.1.4.1.111.4.1.7.1.22 |
| oraDbConfigOptimizerMode | 1.3.6.1.4.1.111.4.1.7.1.23 |
| oraDbConfigProcesses | 1.3.6.1.4.1.111.4.1.7.1.24 |
| oraDbConfigSerializable | 1.3.6.1.4.1.111.4.1.7.1.25 |
| oraDbConfigSessions | 1.3.6.1.4.1.111.4.1.7.1.26 |
| oraDbConfigSharedPool | 1.3.6.1.4.1.111.4.1.7.1.27 |
| oraDbConfigSortAreaSize | 1.3.6.1.4.1.111.4.1.7.1.28 |
| oraDbConfigSortAreaRetainedSize | 1.3.6.1.4.1.111.4.1.7.1.29 |
| oraDbConfigTransactions | 1.3.6.1.4.1.111.4.1.7.1.30 |
| oraDbConfigTransactionsPerRollback | 1.3.6.1.4.1.111.4.1.7.1.31 |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DB_BLOCK_BUFFERS parameter of the INIT.ORA file. Indicates the number of database blocks cached in memory of the SGA. This parameter is the most significant determinant of the SGA size and database instance performance. The size of each block can be determined using oraDbConfigDbBlockSize. |
| Typical Range | 1 - 2147483647 |
| Significance | very important |
| Related Variables | oraDbConfigDbBlockSize |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DB_BLOCK _CHECKPOINT_BATCH parameter of the INIT.ORA file. Indicates the maximum number of blocks that the DBWR process will write in one batch devoted to checkpoints. |
| Typical Range | 0 - 2147483647 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DB_BLOCK_SIZE parameter of the INIT.ORA file. Indicates the size, in bytes, of database blocks for this database. This information has significance for a number of other variables. |
| Typical Range | 1024 - 8192 (O/S dependent) |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DB_FILE_SIMULTANEOUS_WRITES parameter of the INIT.ORA file. Indicates the number of simultaneous writes (batches) for each database file when written by DBWR. |
| Typical Range | 1 - 2147483647 |
| Significance | less important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DB_FILE_MULTIBLOCK_READ_COUNT parameter of the INIT.ORA file. Indicates the maximum number of blocks read in one I/O operation during a sequential scan. The default is a function of the DB_BLOCK_BUFFERS and PROCESSES parameters in the INIT.ORA file. |
| Typical Range | Values in the range of 4 to 32 are reasonable. Actual maximums vary by operating system |
| Significance | important |
| Related Variables | oraDbConfigDbBlockBuffers, oraDbConfigDbProcesses |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DISTRIBUTED_LOCK_TIMEOUT parameter of the INIT.ORA file. Indicates the amount of time (in seconds) that distributed transactions must wait for locked resources. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | clock or simple string |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DISTRIBUTED_RECOVERY_CONNECTION_HOLD_ TIME parameter of the INIT.ORA file. Indicates the length of time (in seconds) to hold a remote connection open after a distributed transaction fails, in hopes that communication will be restored without having to reestablish the connection. Any value above 1800 means the connection never closes. |
| Typical Range | 1 - 1800 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | clock or simple string |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the DISTRIBUTED_TRANSACTIONS parameter of the INIT.ORA file. Indicates the maximum number of distributed transactions in which this database can concurrently participate. |
| Typical Range | 0 - 2147483647 |
| Significance | none |
| Related Variables | oraDbConfigDistTransactions |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_ARCHIVE_BUFFER_SIZE parameter of the INIT.ORA file. Indicates the size of each archival buffer, in redo log blocks (operating system blocks). The default should be adequate for most applications. |
| Typical Range | 1 - 2147483647 |
| Significance | less important |
| Related Variables | oraDbConfigLogArchiveBuffers, oraDbConfigLogBuffer |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_ARCHIVE_BUFFERS parameter from the INIT.ORA file. Indicates the number of buffers allocated for archiving. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | oraDbConfigLogArchiveBufferSize, oraDbConfigLogBuffer |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_BUFFER parameter of the INIT.ORA file. Indicates the number of bytes allocated to the redo log buffer in the SGA. In a busy system, a value of 65536 or higher would not be unreasonable. |
| Typical Range | 1,000 - 100,000 |
| Significance | important |
| Related Variables | oraDbConfigLogArchiveBuffers, oraDbConfigLogArchiveBufferSize |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_CHECKPOINT_INTERVAL parameter of the INIT.ORA file. Indicates the amount of time (in seconds) to pass before another checkpoint occurs. A value of 0 disables time-based checkpoints. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | oraDbConfigLogCheckpointTimeout |
| Suggested Presentation | clock or simple string |
| Syntax | INTEGER (0..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_CHECKPOINT_TIMEOUT parameter of the INIT.ORA file. The amount of time (in seconds) to pass between checkpoints. A value of 0 disables time-based checkpoints. |
| Typical Range | 0 - 2147483647 |
| Significance | important |
| Related Variables | oraDbConfigLogCheckpointInterval |
| Suggested Presentation | clock or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the LOG_FILES parameter of the INIT.ORA file. Indicates the maximum log group number. This value specifies the maximum number of redo log files that can be opened at database instance run time. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the MAX_ROLLBACK_SEGMENTS parameter of the INIT.ORA file. Indicates the maximum size of the rollback segment cache in the SGA. |
| Typical Range | 1 - 65536 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Explanation | The value of this variable is retrieved directly from the MTS_MAX_ DISPATCHERS parameter of the INIT.ORA file. Indicates the maximum number of dispatcher processes allowed to be running simultaneously. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the MTS_MAX_SERVERS parameter of the INIT.ORA file. Indicates the maximum number of shared server processes allowed to be running simultaneously. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the MTS_SERVERS parameter of the INIT.ORA file. Indicates the number of server processes that are created when an instance is started. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the OPEN_CURSORS parameter of the INIT.ORA file. Indicates the maximum number of open cursors (context areas) a single-user process can have at once. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the OPEN_LINKS parameter of the INIT.ORA file. Indicates the maximum number of concurrent open connections to remote database instances per user process. This parameter refers only to connections used for distributed transactions; direct connections to a remote database instance specified as an application connects are not counted. If set to 0, then no distributed transactions are allowed. |
| Typical Range | 0 - 255 |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | DisplayString |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the OPTIMIZER_MODE parameter of the INIT.ORA file. When set to RULE, this parameter causes rule-based optimization to be used, unless hints are specified in the query. When set to COST, the optimizer uses a cost-based approach for an SQL statement, if there are statistics in the dictionary for at least one table accessed in the statement. (Otherwise, the rule-based approach is used.) |
| Typical Range | RULE/COST |
| Significance | important |
| Related Variables | oraDbConfigSessions |
| Suggested Presentation | icon or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the PROCESSES parameter of the INIT.ORA file. For a multiple-process operation, this parameter specifies the maximum number of user processes that can simultaneously connect to an Oracle server. The PROCESSES parameter is used to derive the SESSIONS INIT.ORA parameter. The default is 50. |
| Typical Range | 6 - O/S dependent |
| Significance | important |
| Related Variables | oraDbConfigSessions, oraDbConfigTransactions |
| Suggested Presentation | gauge or simple string |
| Suggested Presentation | gauge or simple string |
| Syntax | TruthValue |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the SERIALIZABLE parameter of the INIT.ORA file. A value of TRUE indicates that queries acquire table-level read locks, preventing any update of objects read until the transaction containing the query is committed. |
| Typical Range | true/false |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | icon or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the SESSIONS parameter of the INIT.ORA file. Indicates the total number of user and system sessions. The default for parameter is derived as the value of the INIT.ORA PROCESSES parameter multiplied by 1.1. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | oraDbConfigProcesses |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the SHARED_POOL_SIZE parameter of the INIT.ORA file. Indicates the size (in bytes) of the shared pool. The shared pool contains shared cursors and stored procedures. The default is 3.5 Mbytes. |
| Typical Range | 300 Kbytes - O/S dependent |
| Significance | important |
| Related Variables | none |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the SORT_AREA_SIZE parameter of the INIT.ORA file. Indicates the maximum amount of PGA memory to use for an exterrnal (disk) sort (in bytes). The default (O/S dependent) is adequate for most DB operations. |
| Typical Range | 1 - 2147483647 |
| Significance | none |
| Related Variables | oraDbConfigRetainedSize, oraDbConfigSortSpaceMapSize |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the SORT_AREA_RETAINED_SIZE parameter of the INIT.ORA file. Indicates the maximum amount of session memory (in bytes) that will be used for an in-memory sort. The default value is equal to that assigned for the SORT_AREA_SIZE INIT.ORA parameter. |
| Typical Range | 0..value of oraDbConfigSortAreaSize |
| Significance | important |
| Related Variables | oraConfigSortAreaSize |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the TRANSACTIONS parameter of the INIT.ORA file. Indicates the maximum number of concurrent transactions. The default is the value of the PROCESSES INIT.ORA parameter multiplied by 1.1. |
| Typical Range | 1 - 2147483647 |
| Significance | important |
| Related Variables | oraDbConfigProcesses |
| Suggested Presentation | gauge or simple string |
| Syntax | INTEGER (1..2147483647) |
| Max-Access | read-only |
| Explanation | The value of this variable is retrieved directly from the TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter of the INIT.ORA file. Indicates the number of concurrent transactions allowed per rollback segment. The default is 30. |
| Typical Range | 1..O/S dependent |
| Significance | important |
| Related Variables | oraDbConfigTransactions |
| Suggested Presentation | gauge or simple string |