ORADB-MIB
104 objects
No module-level DESCRIPTION found.
Imported Objects
| RDBMS-MIB MISSING | rdbmsDbIndex |
| RFC-1212 | OBJECT-TYPE |
| RFC1155-SMI | Counter enterprises experimental |
| RFC1213-MIB | DisplayString |
| OID | Name | Access | Status | Description |
|---|---|---|---|---|
| 1.3.6.1.4.1.111 | Nodeoracle | |||
| 1.3.6.1.4.1.111.4 | NodeoraDbMIB | |||
| 1.3.6.1.4.1.111.4.1 | NodeoraDbObjects | |||
| 1.3.6.1.4.1.111.4.1.1 | TableoraDbSysTable | not-accessible | mandatory | Oracle-specific performance information global to a database. |
| 1.3.6.1.4.1.111.4.1.1.1 | RoworaDbSysEntry | not-accessible | mandatory | Selected info from the v$sysstat table on instance performance. Variables are included here because they have been found particularly useful in tuning an Oracl… |
| 1.3.6.1.4.1.111.4.1.1.1.1 | ColumnoraDbSysConsistentChanges | read-only | mandatory | the 'consistent changes' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.2 | ColumnoraDbSysConsistentGets | read-only | mandatory | the 'consistent gets' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.3 | ColumnoraDbSysDbBlockChanges | read-only | mandatory | the 'Db block changes' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.4 | ColumnoraDbSysDbBlockGets | read-only | mandatory | the 'db block gets' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.5 | ColumnoraDbSysFreeBufferInspected | read-only | mandatory | the 'free buffer inspected' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.6 | ColumnoraDbSysFreeBufferRequested | read-only | mandatory | the 'free buffer requested' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.7 | ColumnoraDbSysParseCount | read-only | mandatory | the 'parse count' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.8 | ColumnoraDbSysPhysReads | read-only | mandatory | the 'physical reads' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.9 | ColumnoraDbSysPhysWrites | read-only | mandatory | the 'physical writes' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.10 | ColumnoraDbSysRedoEntries | read-only | mandatory | the 'redo entries' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.11 | ColumnoraDbSysRedoLogSpaceRequests | read-only | mandatory | the 'redo log space requests' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.12 | ColumnoraDbSysRedoSyncWrites | read-only | mandatory | the 'redo synch writes' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.13 | ColumnoraDbSysSortsDisk | read-only | mandatory | the 'sorts (disk)' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.14 | ColumnoraDbSysSortsMemory | read-only | mandatory | the 'sorts (memory)' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.15 | ColumnoraDbSysSortsRows | read-only | mandatory | the 'sorts (rows)' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.16 | ColumnoraDbSysTableFetchRowid | read-only | mandatory | the 'table fetch by rowid' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.17 | ColumnoraDbSysTableFetchContinuedRow | read-only | mandatory | the 'table fetch continued row' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.18 | ColumnoraDbSysTableScanBlocks | read-only | mandatory | the 'table scan blocks gotten' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.19 | ColumnoraDbSysTableScanRows | read-only | mandatory | the 'table scan rows gotten' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.20 | ColumnoraDbSysTableScansLong | read-only | mandatory | the 'table scans (long tables)' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.21 | ColumnoraDbSysTableScansShort | read-only | mandatory | the 'table scans (short tables)' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.22 | ColumnoraDbSysUserCalls | read-only | mandatory | the 'user calls' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.23 | ColumnoraDbSysUserCommits | read-only | mandatory | the 'user commits' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.24 | ColumnoraDbSysUserRollbacks | read-only | mandatory | the 'user rollbacks' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.1.1.25 | ColumnoraDbSysWriteRequests | read-only | mandatory | the 'write requests' parameter from v$sysstat |
| 1.3.6.1.4.1.111.4.1.2 | TableoraDbTablespaceTable | not-accessible | mandatory | Information on tablespaces within an Oracle database. |
| 1.3.6.1.4.1.111.4.1.2.1 | RoworaDbTablespaceEntry | not-accessible | mandatory | Information for each tablespace within an Oracle database. |
| 1.3.6.1.4.1.111.4.1.2.1.1 | ColumnoraDbTablespaceIndex | read-only | mandatory | A numeric index, unique among tablespaces within a single Oracle database. |
| 1.3.6.1.4.1.111.4.1.2.1.2 | ColumnoraDbTablespaceName | read-only | mandatory | The name of this tablespace. |
| 1.3.6.1.4.1.111.4.1.2.1.3 | ColumnoraDbTablespaceSizeAllocated | read-only | 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. |
| 1.3.6.1.4.1.111.4.1.2.1.4 | ColumnoraDbTablespaceSizeUsed | read-only | mandatory | The amount of disk space, in kilobytes, which is actually in use for storing data. |
| 1.3.6.1.4.1.111.4.1.2.1.5 | ColumnoraDbTablespaceState | read-only | mandatory | The current accessibility of this tablespace. If a tablespace is offline(2), then SQL statements cannot reference objects contained in the tablespace. An inval… |
| 1.3.6.1.4.1.111.4.1.2.1.6 | ColumnoraDbTablespaceLargestAvailableChunk | read-only | mandatory | The size, in kilobytes, of the largest contiguous set of free data blocks in the tablespace. |
| 1.3.6.1.4.1.111.4.1.3 | TableoraDbDataFileTable | not-accessible | mandatory | Information on data files within an Oracle database. |
| 1.3.6.1.4.1.111.4.1.3.1 | RoworaDbDataFileEntry | not-accessible | mandatory | Information for each data file within an Oracle database. |
| 1.3.6.1.4.1.111.4.1.3.1.1 | ColumnoraDbDataFileIndex | read-only | mandatory | A numeric index, unique among data files associated with a single tablespace. |
| 1.3.6.1.4.1.111.4.1.3.1.2 | ColumnoraDbDataFileName | read-only | mandatory | The fully-qualified name of this datafile. |
| 1.3.6.1.4.1.111.4.1.3.1.3 | ColumnoraDbDataFileSizeAllocated | read-only | mandatory | The allocated size, in kilobytes, of this data file. |
| 1.3.6.1.4.1.111.4.1.3.1.4 | ColumnoraDbDataFileDiskReads | read-only | mandatory | The total number of reads issued against this data file since startup. |
| 1.3.6.1.4.1.111.4.1.3.1.5 | ColumnoraDbDataFileDiskWrites | read-only | mandatory | The total number of writes issued against this data file since startup. |
| 1.3.6.1.4.1.111.4.1.3.1.6 | ColumnoraDbDataFileDiskReadBlocks | read-only | mandatory | The total number of physical blocks read from this data file since startup. |
| 1.3.6.1.4.1.111.4.1.3.1.7 | ColumnoraDbDataFileDiskWrittenBlocks | read-only | mandatory | The total number of physical blocks written to this data file since startup. |
| 1.3.6.1.4.1.111.4.1.3.1.8 | ColumnoraDbDataFileDiskReadTimeTicks | read-only | 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 … |
| 1.3.6.1.4.1.111.4.1.3.1.9 | ColumnoraDbDataFileDiskWriteTimeTicks | read-only | 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… |
| 1.3.6.1.4.1.111.4.1.4 | TableoraDbLibraryCacheTable | not-accessible | mandatory | Information on libraryCache performance. |
| 1.3.6.1.4.1.111.4.1.4.1 | RoworaDbLibraryCacheEntry | not-accessible | mandatory | LibraryCache information for each Oracle database. |
| 1.3.6.1.4.1.111.4.1.4.1.1 | ColumnoraDbLibraryCacheIndex | read-only | mandatory | A unique integer for each row of the table. |
| 1.3.6.1.4.1.111.4.1.4.1.2 | ColumnoraDbLibraryCacheNameSpace | read-only | mandatory | The namespace of the v$librarycache table that this row relates to. |
| 1.3.6.1.4.1.111.4.1.4.1.3 | ColumnoraDbLibraryCacheGets | read-only | mandatory | Number of times the system requests handles to library objects in this namespace. |
| 1.3.6.1.4.1.111.4.1.4.1.4 | ColumnoraDbLibraryCacheGetHits | read-only | mandatory | Number of times the handles are already allocated in the cache. |
| 1.3.6.1.4.1.111.4.1.4.1.5 | ColumnoraDbLibraryCachePins | read-only | mandatory | Number of times the system issues pin requests for objects in the cache in order to access them. |
| 1.3.6.1.4.1.111.4.1.4.1.6 | ColumnoraDbLibraryCachePinHits | read-only | mandatory | Number of times the objects the system is pinning are already allocated and initialized in the cache. |
| 1.3.6.1.4.1.111.4.1.4.1.7 | ColumnoraDbLibraryCacheReloads | read-only | mandatory | Number of times the library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated |
| 1.3.6.1.4.1.111.4.1.4.1.8 | ColumnoraDbLibraryCacheInvalidations | read-only | mandatory | Number of times that non-persistent library objects (like shared SQL areas) have been invalidated. |
| 1.3.6.1.4.1.111.4.1.5 | TableoraDbLibraryCacheSumTable | not-accessible | mandatory | Information on library cache performance, summed over all library caches in a single database instance. |
| 1.3.6.1.4.1.111.4.1.5.1 | RoworaDbLibraryCacheSumEntry | not-accessible | mandatory | LibraryCache information, summed over all library caches, for each Oracle database. |
| 1.3.6.1.4.1.111.4.1.5.1.1 | ColumnoraDbLibraryCacheSumGets | read-only | mandatory | Number of times the system requests handles to library objects, summed over all library caches in the instance. |
| 1.3.6.1.4.1.111.4.1.5.1.2 | ColumnoraDbLibraryCacheSumGetHits | read-only | mandatory | Number of times the handles are already allocated in the cache, summed over all library caches in the instance. |
| 1.3.6.1.4.1.111.4.1.5.1.3 | ColumnoraDbLibraryCacheSumPins | read-only | 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. |
| 1.3.6.1.4.1.111.4.1.5.1.4 | ColumnoraDbLibraryCacheSumPinHits | read-only | 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. |
| 1.3.6.1.4.1.111.4.1.5.1.5 | ColumnoraDbLibraryCacheSumReloads | read-only | 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 cac… |
| 1.3.6.1.4.1.111.4.1.5.1.6 | ColumnoraDbLibraryCacheSumInvalidations | read-only | mandatory | Number of times that non-persistent library objects (like shared SQL areas) have been invalidated, summed over all library caches in the instance. |
| 1.3.6.1.4.1.111.4.1.6 | TableoraDbSGATable | not-accessible | mandatory | Summary information on the System Global Area |
| 1.3.6.1.4.1.111.4.1.6.1 | RoworaDbSGAEntry | not-accessible | mandatory | A single entry from the v$sga table |
| 1.3.6.1.4.1.111.4.1.6.1.1 | ColumnoraDbSGAFixedSize | read-only | mandatory | |
| 1.3.6.1.4.1.111.4.1.6.1.2 | ColumnoraDbSGAVariableSize | read-only | mandatory | |
| 1.3.6.1.4.1.111.4.1.6.1.3 | ColumnoraDbSGADatabaseBuffers | read-only | mandatory | |
| 1.3.6.1.4.1.111.4.1.6.1.4 | ColumnoraDbSGARedoBuffers | read-only | mandatory | |
| 1.3.6.1.4.1.111.4.1.7 | TableoraDbConfigTable | not-accessible | mandatory | Oracle-specific configuration information global to a database. |
| 1.3.6.1.4.1.111.4.1.7.1 | RoworaDbConfigEntry | not-accessible | mandatory | Oracle-specific configuration information. This table only lists a few init.ora parameters that are particularly relevant to the task of monitoring database pe… |
| 1.3.6.1.4.1.111.4.1.7.1.1 | ColumnoraDbConfigDbBlockBuffers | read-only | mandatory | The DB_BLOCK_BUFFERS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.2 | ColumnoraDbConfigDbBlockCkptBatch | read-only | mandatory | The DB_BLOCK_CHECKPOINT_BATCH parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.3 | ColumnoraDbConfigDbBlockSize | read-only | mandatory | The DB_BLOCK_SIZE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.4 | ColumnoraDbConfigDbFileSimWrites | read-only | mandatory | The DB_FILE_SIMULTANEOUS_WRITES parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.5 | ColumnoraDbConfigDbMultiBlockReadCount | read-only | mandatory | The DB_MULTIBLOCK_READ_COUNT parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.6 | ColumnoraDbConfigDistLockTimeout | read-only | mandatory | The DISTRIBUTED_LOCK_TIMEOUT parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.7 | ColumnoraDbConfigDistRecoveryConnectHold | read-only | mandatory | The DISTRIBUTED_RECOVERY_CONNECT_HOLD parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.8 | ColumnoraDbConfigDistTransactions | read-only | mandatory | The DISTRIBUTED_TRANSACTIONS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.9 | ColumnoraDbConfigLogArchiveBufferSize | read-only | mandatory | The LOG_ARCHIVE_BUFFER_SIZE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.10 | ColumnoraDbConfigLogArchiveBuffers | read-only | mandatory | The LOG_ARCHIVE_BUFFERS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.11 | ColumnoraDbConfigLogBuffer | read-only | mandatory | The LOG_BUFFER parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.12 | ColumnoraDbConfigLogCheckpointInterval | read-only | mandatory | The LOG_CHECKPOINT_INTERVAL parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.13 | ColumnoraDbConfigLogCheckpointTimeout | read-only | mandatory | The LOG_CHECKPOINT_TIMEOUT parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.14 | ColumnoraDbConfigLogFiles | read-only | mandatory | The LOG_FILES parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.15 | ColumnoraDbConfigMaxRollbackSegments | read-only | mandatory | The MAX_ROLLBACK_SEGMENTS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.16 | ColumnoraDbConfigMTSMaxDispatchers | read-only | mandatory | The MTS_MAX_DISPATCHERS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.17 | ColumnoraDbConfigMTSMaxServers | read-only | mandatory | The MTS_MAX_SERVERS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.18 | ColumnoraDbConfigMTSServers | read-only | mandatory | The MTS_SERVERS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.19 | ColumnoraDbConfigOpenCursors | read-only | mandatory | The OPEN_CURSORS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.20 | ColumnoraDbConfigOpenLinks | read-only | mandatory | The OPEN_LINKS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.21 | ColumnoraDbConfigOptimizerMode | read-only | mandatory | The OPTIMIZER_MODE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.22 | ColumnoraDbConfigProcesses | read-only | mandatory | The PROCESSES parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.23 | ColumnoraDbConfigSerializable | read-only | mandatory | The SERIALIZABLE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.24 | ColumnoraDbConfigSessions | read-only | mandatory | The SESSIONS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.25 | ColumnoraDbConfigSharedPool | read-only | mandatory | The SHARED_POOL parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.26 | ColumnoraDbConfigSortAreaSize | read-only | mandatory | The SORT_AREA_SIZE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.27 | ColumnoraDbConfigSortAreaRetainedSize | read-only | mandatory | The SORT_AREA_RETAINED_SIZE parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.28 | ColumnoraDbConfigTransactions | read-only | mandatory | The TRANSACTIONS parameter from the init.ora file |
| 1.3.6.1.4.1.111.4.1.7.1.29 | ColumnoraDbConfigTransactionsPerRollback | read-only | mandatory | The TRANSACTIONS_PER_ROLLBACK parameter from the init.ora file |