ORADB-MIB Table View
Table-centric layout grouping table, row, and column objects.
Tables
7
Rows
7
Columns
87
.1.3.6.1.4.1.111.4.1.1
·
1 row entry
·
25 columns
Oracle-specific performance information global to a database.
Selected info from the v$sysstat table on instance performance.
Variables are included here
because they have been found particularly useful in
tuning an Oracle instance. In many cases, the variable should
only be con…
Variables are included here
because they have been found particularly useful in
tuning an Oracle instance. In many cases, the variable should
only be con…
Indexes
RDBMS-MIBrdbmsDbIndex
| Column | Syntax | OID |
|---|---|---|
|
oraDbSysConsistentChanges
mandatory
the 'consistent changes' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.1 |
|
oraDbSysConsistentGets
mandatory
the 'consistent gets' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.2 |
|
oraDbSysDbBlockChanges
mandatory
the 'Db block changes' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.3 |
|
oraDbSysDbBlockGets
mandatory
the 'db block gets' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.4 |
|
oraDbSysFreeBufferInspected
mandatory
the 'free buffer inspected' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.5 |
|
oraDbSysFreeBufferRequested
mandatory
the 'free buffer requested' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.6 |
|
oraDbSysParseCount
mandatory
the 'parse count' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.7 |
|
oraDbSysPhysReads
mandatory
the 'physical reads' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.8 |
|
oraDbSysPhysWrites
mandatory
the 'physical writes' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.9 |
|
oraDbSysRedoEntries
mandatory
the 'redo entries' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.10 |
|
oraDbSysRedoLogSpaceRequests
mandatory
the 'redo log space requests' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.11 |
|
oraDbSysRedoSyncWrites
mandatory
the 'redo synch writes' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.12 |
|
oraDbSysSortsDisk
mandatory
the 'sorts (disk)' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.13 |
|
oraDbSysSortsMemory
mandatory
the 'sorts (memory)' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.14 |
|
oraDbSysSortsRows
mandatory
the 'sorts (rows)' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.15 |
|
oraDbSysTableFetchRowid
mandatory
the 'table fetch by rowid' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.16 |
|
oraDbSysTableFetchContinuedRow
mandatory
the 'table fetch continued row' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.17 |
|
oraDbSysTableScanBlocks
mandatory
the 'table scan blocks gotten' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.18 |
|
oraDbSysTableScanRows
mandatory
the 'table scan rows gotten' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.19 |
|
oraDbSysTableScansLong
mandatory
the 'table scans (long tables)' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.20 |
|
oraDbSysTableScansShort
mandatory
the 'table scans (short tables)' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.21 |
|
oraDbSysUserCalls
mandatory
the 'user calls' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.22 |
|
oraDbSysUserCommits
mandatory
the 'user commits' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.23 |
|
oraDbSysUserRollbacks
mandatory
the 'user rollbacks' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.24 |
|
oraDbSysWriteRequests
mandatory
the 'write requests' parameter from v$sysstat
|
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.1.1.25 |
.1.3.6.1.4.1.111.4.1.2
·
1 row entry
·
6 columns
Information on tablespaces within an Oracle database.
Information for each tablespace within an Oracle database.
Indexes
RDBMS-MIBrdbmsDbIndex oraDbTablespaceIndex
| Column | Syntax | OID | ||||||
|---|---|---|---|---|---|---|---|---|
|
oraDbTablespaceIndex
mandatory
A numeric index, unique among tablespaces within a single
Oracle database. |
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.2.1.1 |
||||||
|
oraDbTablespaceName
mandatory
The name of this tablespace.
|
RFC1213-MIBDisplayString Textual Convention: RFC1213-MIBDisplayString OctetString |
.1.3.6.1.4.1.111.4.1.2.1.2 |
||||||
|
oraDbTablespaceSizeAllocated
mandatory
The amount of disk space, in kilobytes, allocated for this
tablespace. This is the sum of the sizes of the data files associated with the tablespace. |
Integer32 Constraints: range: -2147483648-2147483647 |
.1.3.6.1.4.1.111.4.1.2.1.3 |
||||||
|
oraDbTablespaceSizeUsed
mandatory
The amount of disk space, in kilobytes, which is actually in
use for storing data. |
Integer32 Constraints: range: -2147483648-2147483647 |
.1.3.6.1.4.1.111.4.1.2.1.4 |
||||||
|
oraDbTablespaceState
mandatory
The current accessibility of this tablespace. If a
tablespace is offline(2), then SQL statements cannot reference objects contained in the tablespace. An invalid(3) tablespace is one that has been dropped. |
Enumeration Enumerated Values:
|
.1.3.6.1.4.1.111.4.1.2.1.5 |
||||||
|
oraDbTablespaceLargestAvailableChunk
mandatory
The size, in kilobytes, of the largest contiguous set of free
data blocks in the tablespace. |
Integer32 Constraints: range: -2147483648-2147483647 |
.1.3.6.1.4.1.111.4.1.2.1.6 |
.1.3.6.1.4.1.111.4.1.3
·
1 row entry
·
9 columns
Information on data files within an Oracle database.
Information for each data file within an Oracle database.
Indexes
RDBMS-MIBrdbmsDbIndex oraDbDataFileIndex
| Column | Syntax | OID |
|---|---|---|
|
oraDbDataFileIndex
mandatory
A numeric index, unique among data files associated with a
single tablespace. |
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.3.1.1 |
|
oraDbDataFileName
mandatory
The fully-qualified name of this datafile.
|
RFC1213-MIBDisplayString Textual Convention: RFC1213-MIBDisplayString OctetString |
.1.3.6.1.4.1.111.4.1.3.1.2 |
|
oraDbDataFileSizeAllocated
mandatory
The allocated size, in kilobytes, of this data file.
|
Integer32 Constraints: range: -2147483648-2147483647 |
.1.3.6.1.4.1.111.4.1.3.1.3 |
|
oraDbDataFileDiskReads
mandatory
The total number of reads issued against this data file since
startup. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.4 |
|
oraDbDataFileDiskWrites
mandatory
The total number of writes issued against this data file since
startup. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.5 |
|
oraDbDataFileDiskReadBlocks
mandatory
The total number of physical blocks read from this data file
since startup. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.6 |
|
oraDbDataFileDiskWrittenBlocks
mandatory
The total number of physical blocks written to this data file
since startup. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.7 |
|
oraDbDataFileDiskReadTimeTicks
mandatory
The time spent reading from this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If TIMED_STATISTICS is FALSE, then the value will be zero. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.8 |
|
oraDbDataFileDiskWriteTimeTicks
mandatory
The time spent writing to this data file since startup IF
the database parameter TIMED_STATISTICS is TRUE. If TIMED_STATISTICS is FALSE, then the value will be zero. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.3.1.9 |
.1.3.6.1.4.1.111.4.1.4
·
1 row entry
·
8 columns
Information on libraryCache performance.
LibraryCache information for each Oracle database.
Indexes
RDBMS-MIBrdbmsDbIndex oraDbLibraryCacheIndex
| Column | Syntax | OID |
|---|---|---|
|
oraDbLibraryCacheIndex
mandatory
A unique integer for each row of the table.
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.4.1.1 |
|
oraDbLibraryCacheNameSpace
mandatory
The namespace of the v$librarycache table that this
row relates to. |
RFC1213-MIBDisplayString Textual Convention: RFC1213-MIBDisplayString OctetString |
.1.3.6.1.4.1.111.4.1.4.1.2 |
|
oraDbLibraryCacheGets
mandatory
Number of times the system requests handles to library
objects in this namespace. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.3 |
|
oraDbLibraryCacheGetHits
mandatory
Number of times the handles are already allocated in
the cache. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.4 |
|
oraDbLibraryCachePins
mandatory
Number of times the system issues pin requests
for objects in the cache in order to access them. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.5 |
|
oraDbLibraryCachePinHits
mandatory
Number of times the objects the system is pinning
are already allocated and initialized in the cache. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.6 |
|
oraDbLibraryCacheReloads
mandatory
Number of times the library objects have to be reinitialized
and reloaded with data because they have been aged out or invalidated |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.7 |
|
oraDbLibraryCacheInvalidations
mandatory
Number of times that non-persistent library objects
(like shared SQL areas) have been invalidated. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.4.1.8 |
.1.3.6.1.4.1.111.4.1.5
·
1 row entry
·
6 columns
Information on library cache performance, summed over all library caches in a single database instance.
LibraryCache information, summed over all library caches,
for each Oracle database.
for each Oracle database.
Indexes
RDBMS-MIBrdbmsDbIndex
| Column | Syntax | OID |
|---|---|---|
|
oraDbLibraryCacheSumGets
mandatory
Number of times the system requests handles to library
objects, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.1 |
|
oraDbLibraryCacheSumGetHits
mandatory
Number of times the handles are already allocated in
the cache, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.2 |
|
oraDbLibraryCacheSumPins
mandatory
Number of times the system issues pin requests
for objects in a cache in order to access them, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.3 |
|
oraDbLibraryCacheSumPinHits
mandatory
Number of times the objects the system is pinning
are already allocated and initialized in a cache, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.4 |
|
oraDbLibraryCacheSumReloads
mandatory
Number of times the library objects have to be reinitialized
and reloaded with data because they have been aged out or invalidated, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.5 |
|
oraDbLibraryCacheSumInvalidations
mandatory
Number of times that non-persistent library objects
(like shared SQL areas) have been invalidated, summed over all library caches in the instance. |
RFC1155-SMICounter Textual Convention: RFC1155-SMICounter Unsigned32Type Constraints: range: 0..4294967295 |
.1.3.6.1.4.1.111.4.1.5.1.6 |
.1.3.6.1.4.1.111.4.1.6
·
1 row entry
·
4 columns
Summary information on the System Global Area
A single entry from the v$sga table
Indexes
RDBMS-MIBrdbmsDbIndex
| Column | Syntax | OID |
|---|---|---|
| oraDbSGAFixedSize mandatory | Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.6.1.1 |
| oraDbSGAVariableSize mandatory | Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.6.1.2 |
| oraDbSGADatabaseBuffers mandatory | Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.6.1.3 |
| oraDbSGARedoBuffers mandatory | Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.6.1.4 |
.1.3.6.1.4.1.111.4.1.7
·
1 row entry
·
29 columns
Oracle-specific configuration information global to a database.
Oracle-specific configuration information.
This table only lists a few
init.ora parameters that are particularly relevant to the
task of monitoring database performance. By giving them
easy-to-use, fixed object-ids, w…
This table only lists a few
init.ora parameters that are particularly relevant to the
task of monitoring database performance. By giving them
easy-to-use, fixed object-ids, w…
Indexes
RDBMS-MIBrdbmsDbIndex
| Column | Syntax | OID | ||||
|---|---|---|---|---|---|---|
|
oraDbConfigDbBlockBuffers
mandatory
The DB_BLOCK_BUFFERS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.1 |
||||
|
oraDbConfigDbBlockCkptBatch
mandatory
The DB_BLOCK_CHECKPOINT_BATCH parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.2 |
||||
|
oraDbConfigDbBlockSize
mandatory
The DB_BLOCK_SIZE parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.3 |
||||
|
oraDbConfigDbFileSimWrites
mandatory
The DB_FILE_SIMULTANEOUS_WRITES parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.4 |
||||
|
oraDbConfigDbMultiBlockReadCount
mandatory
The DB_MULTIBLOCK_READ_COUNT parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.5 |
||||
|
oraDbConfigDistLockTimeout
mandatory
The DISTRIBUTED_LOCK_TIMEOUT parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.6 |
||||
|
oraDbConfigDistRecoveryConnectHold
mandatory
The DISTRIBUTED_RECOVERY_CONNECT_HOLD parameter from the
init.ora file |
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.7 |
||||
|
oraDbConfigDistTransactions
mandatory
The DISTRIBUTED_TRANSACTIONS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.8 |
||||
|
oraDbConfigLogArchiveBufferSize
mandatory
The LOG_ARCHIVE_BUFFER_SIZE parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.9 |
||||
|
oraDbConfigLogArchiveBuffers
mandatory
The LOG_ARCHIVE_BUFFERS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.10 |
||||
|
oraDbConfigLogBuffer
mandatory
The LOG_BUFFER parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.11 |
||||
|
oraDbConfigLogCheckpointInterval
mandatory
The LOG_CHECKPOINT_INTERVAL parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.12 |
||||
|
oraDbConfigLogCheckpointTimeout
mandatory
The LOG_CHECKPOINT_TIMEOUT parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.13 |
||||
|
oraDbConfigLogFiles
mandatory
The LOG_FILES parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.14 |
||||
|
oraDbConfigMaxRollbackSegments
mandatory
The MAX_ROLLBACK_SEGMENTS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.15 |
||||
|
oraDbConfigMTSMaxDispatchers
mandatory
The MTS_MAX_DISPATCHERS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.16 |
||||
|
oraDbConfigMTSMaxServers
mandatory
The MTS_MAX_SERVERS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.17 |
||||
|
oraDbConfigMTSServers
mandatory
The MTS_SERVERS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.18 |
||||
|
oraDbConfigOpenCursors
mandatory
The OPEN_CURSORS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.19 |
||||
|
oraDbConfigOpenLinks
mandatory
The OPEN_LINKS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.20 |
||||
|
oraDbConfigOptimizerMode
mandatory
The OPTIMIZER_MODE parameter from the init.ora file
|
RFC1213-MIBDisplayString Textual Convention: RFC1213-MIBDisplayString OctetString |
.1.3.6.1.4.1.111.4.1.7.1.21 |
||||
|
oraDbConfigProcesses
mandatory
The PROCESSES parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.22 |
||||
|
oraDbConfigSerializable
mandatory
The SERIALIZABLE parameter from the init.ora file
|
TruthValue Textual Convention: TruthValue EnumerationType Values:
|
.1.3.6.1.4.1.111.4.1.7.1.23 |
||||
|
oraDbConfigSessions
mandatory
The SESSIONS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.24 |
||||
|
oraDbConfigSharedPool
mandatory
The SHARED_POOL parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.25 |
||||
|
oraDbConfigSortAreaSize
mandatory
The SORT_AREA_SIZE parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.26 |
||||
|
oraDbConfigSortAreaRetainedSize
mandatory
The SORT_AREA_RETAINED_SIZE parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.27 |
||||
|
oraDbConfigTransactions
mandatory
The TRANSACTIONS parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.28 |
||||
|
oraDbConfigTransactionsPerRollback
mandatory
The TRANSACTIONS_PER_ROLLBACK parameter from the init.ora file
|
Integer32 Textual Convention: COPS-PR-SPPIInteger32 Integer32Type Constraints: range: -2147483648..2147483647 |
.1.3.6.1.4.1.111.4.1.7.1.29 |