ORADB-MIB

All MIBs › ORADB-MIB

Category: Database

Description: Monitors Oracle Database instance health, session counts, tablespace usage, and performance metrics.

Start monitoring vendor-neutral, standards-based MIB, any SNMPv3-capable network device (SNMP engine identity/boot/clock status) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

What Is ORADB-MIB?

ORADB-MIB is a vendor-specific SNMP module for monitoring Oracle relational database server instances, exposing internals of the Oracle RDBMS engine to general-purpose SNMP management platforms. It surfaces database performance counters such as buffer cache statistics, physical disk I/O activity, redo log generation, consistent-read activity, and SQL parse rates, organized around a system-wide statistics table. This MIB is used chiefly to monitor the software/service health and performance load of the Oracle database engine rather than physical hardware, with indicators like physical reads/writes, buffer cache hit efficiency (free buffer inspected vs. requested), block change rates, and parse counts revealing I/O bottlenecks, cache pressure, or SQL inefficiency long before an outage occurs. It builds on standard SNMPv2-SMI conventions and loosely mirrors data available through Oracle's own V$SYSSTAT dynamic performance views. It is typically deployed on production Oracle database servers monitored by enterprise NMS or capacity-planning tools alongside OS-level and Oracle Listener monitoring. Engineers can download the ORADB-MIB file directly to load it into their MIB browser.

IPNetwork Monitor allows you to monitor SNMP objects defined in ORADB-MIB. Use the built-in SNMP Monitoring Browser to explore available variables, view their current values and descriptions, and select the objects you want to monitor. You can then create SNMP monitors, configure thresholds, and receive alerts when monitored values change.

Supported Devices

Oracle database server
Oracle RDBMS instance monitored via SNMP

Monitoring Examples

An administrator polls the oraDbSysTable/oraDbSysEntry row for counters like oraDbSysPhysReads and oraDbSysPhysWrites to trend disk I/O load, and compares oraDbSysConsistentGets against oraDbSysConsistentChanges to gauge multi-version read consistency overhead. A widening gap between oraDbSysFreeBufferRequested and oraDbSysFreeBufferInspected signals buffer cache contention that may call for a larger SGA. A sustained rise in oraDbSysParseCount without matching query volume growth can indicate hard-parsing due to poor cursor sharing, driving up CPU usage on the database host.

What Can Be Monitored

physical reads/writes rate
buffer cache efficiency
consistent gets/changes
SQL parse count
redo log entries generated
database block change rate

Imported Objects

From RDBMS-MIB

rdbmsDbIndex

OBJECT-TYPE

From RFC-1212

OBJECT-TYPE

From RFC1155-SMI

Counter
enterprises
experimental

From RFC1213-MIB

DisplayString

OIDs

OID symbolic	OID numeric	Type	Access	Description
oracle	1.3.6.1.4.1.111
oraDbMIB	1.3.6.1.4.1.111.4
oraDbObjects	1.3.6.1.4.1.111.4.1
oraDbSysTable	1.3.6.1.4.1.111.4.1.1		not-accessible	Oracle-specific performance information global to a database.
oraDbSysEntry	1.3.6.1.4.1.111.4.1.1.1		not-accessible	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 considered in conjunction with other variables, often as a ratio. Frequently, hints on these are given in the descriptions, but Oracle tuning documentation should always be consulted, particularly the Oracle University course on tuning V7 applications.
CTR oraDbSysConsistentChanges	1.3.6.1.4.1.111.4.1.1.1.1	Counter	read-only	the 'consistent changes' parameter from v$sysstat
CTR oraDbSysConsistentGets	1.3.6.1.4.1.111.4.1.1.1.2	Counter	read-only	the 'consistent gets' parameter from v$sysstat
CTR oraDbSysDbBlockChanges	1.3.6.1.4.1.111.4.1.1.1.3	Counter	read-only	the 'Db block changes' parameter from v$sysstat
CTR oraDbSysDbBlockGets	1.3.6.1.4.1.111.4.1.1.1.4	Counter	read-only	the 'db block gets' parameter from v$sysstat
CTR oraDbSysFreeBufferInspected	1.3.6.1.4.1.111.4.1.1.1.5	Counter	read-only	the 'free buffer inspected' parameter from v$sysstat
CTR oraDbSysFreeBufferRequested	1.3.6.1.4.1.111.4.1.1.1.6	Counter	read-only	the 'free buffer requested' parameter from v$sysstat
CTR oraDbSysParseCount	1.3.6.1.4.1.111.4.1.1.1.7	Counter	read-only	the 'parse count' parameter from v$sysstat
CTR oraDbSysPhysReads	1.3.6.1.4.1.111.4.1.1.1.8	Counter	read-only	the 'physical reads' parameter from v$sysstat
CTR oraDbSysPhysWrites	1.3.6.1.4.1.111.4.1.1.1.9	Counter	read-only	the 'physical writes' parameter from v$sysstat
CTR oraDbSysRedoEntries	1.3.6.1.4.1.111.4.1.1.1.10	Counter	read-only	the 'redo entries' parameter from v$sysstat
CTR oraDbSysRedoLogSpaceRequests	1.3.6.1.4.1.111.4.1.1.1.11	Counter	read-only	the 'redo log space requests' parameter from v$sysstat
CTR oraDbSysRedoSyncWrites	1.3.6.1.4.1.111.4.1.1.1.12	Counter	read-only	the 'redo synch writes' parameter from v$sysstat
CTR oraDbSysSortsDisk	1.3.6.1.4.1.111.4.1.1.1.13	Counter	read-only	the 'sorts (disk)' parameter from v$sysstat
CTR oraDbSysSortsMemory	1.3.6.1.4.1.111.4.1.1.1.14	Counter	read-only	the 'sorts (memory)' parameter from v$sysstat
CTR oraDbSysSortsRows	1.3.6.1.4.1.111.4.1.1.1.15	Counter	read-only	the 'sorts (rows)' parameter from v$sysstat
CTR oraDbSysTableFetchRowid	1.3.6.1.4.1.111.4.1.1.1.16	Counter	read-only	the 'table fetch by rowid' parameter from v$sysstat
CTR oraDbSysTableFetchContinuedRow	1.3.6.1.4.1.111.4.1.1.1.17	Counter	read-only	the 'table fetch continued row' parameter from v$sysstat
CTR oraDbSysTableScanBlocks	1.3.6.1.4.1.111.4.1.1.1.18	Counter	read-only	the 'table scan blocks gotten' parameter from v$sysstat
CTR oraDbSysTableScanRows	1.3.6.1.4.1.111.4.1.1.1.19	Counter	read-only	the 'table scan rows gotten' parameter from v$sysstat
CTR oraDbSysTableScansLong	1.3.6.1.4.1.111.4.1.1.1.20	Counter	read-only	the 'table scans (long tables)' parameter from v$sysstat
CTR oraDbSysTableScansShort	1.3.6.1.4.1.111.4.1.1.1.21	Counter	read-only	the 'table scans (short tables)' parameter from v$sysstat
CTR oraDbSysUserCalls	1.3.6.1.4.1.111.4.1.1.1.22	Counter	read-only	the 'user calls' parameter from v$sysstat
CTR oraDbSysUserCommits	1.3.6.1.4.1.111.4.1.1.1.23	Counter	read-only	the 'user commits' parameter from v$sysstat
CTR oraDbSysUserRollbacks	1.3.6.1.4.1.111.4.1.1.1.24	Counter	read-only	the 'user rollbacks' parameter from v$sysstat
CTR oraDbSysWriteRequests	1.3.6.1.4.1.111.4.1.1.1.25	Counter	read-only	the 'write requests' parameter from v$sysstat
oraDbTablespaceTable	1.3.6.1.4.1.111.4.1.2		not-accessible	Information on tablespaces within an Oracle database.
oraDbTablespaceEntry	1.3.6.1.4.1.111.4.1.2.1		not-accessible	Information for each tablespace within an Oracle database.
INT oraDbTablespaceIndex	1.3.6.1.4.1.111.4.1.2.1.1	INTEGER	read-only	A numeric index, unique among tablespaces within a single Oracle database.
STR oraDbTablespaceName	1.3.6.1.4.1.111.4.1.2.1.2	DisplayString	read-only	The name of this tablespace.
INT oraDbTablespaceSizeAllocated	1.3.6.1.4.1.111.4.1.2.1.3	INTEGER	read-only	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.
INT oraDbTablespaceSizeUsed	1.3.6.1.4.1.111.4.1.2.1.4	INTEGER	read-only	The amount of disk space, in kilobytes, which is actually in use for storing data.
INT oraDbTablespaceState	1.3.6.1.4.1.111.4.1.2.1.5	INTEGER	read-only	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.
INT oraDbTablespaceLargestAvailableChunk	1.3.6.1.4.1.111.4.1.2.1.6	INTEGER	read-only	The size, in kilobytes, of the largest contiguous set of free data blocks in the tablespace.
oraDbDataFileTable	1.3.6.1.4.1.111.4.1.3		not-accessible	Information on data files within an Oracle database.
oraDbDataFileEntry	1.3.6.1.4.1.111.4.1.3.1		not-accessible	Information for each data file within an Oracle database.
INT oraDbDataFileIndex	1.3.6.1.4.1.111.4.1.3.1.1	INTEGER	read-only	A numeric index, unique among data files associated with a single tablespace.
STR oraDbDataFileName	1.3.6.1.4.1.111.4.1.3.1.2	DisplayString	read-only	The fully-qualified name of this datafile.
INT oraDbDataFileSizeAllocated	1.3.6.1.4.1.111.4.1.3.1.3	INTEGER	read-only	The allocated size, in kilobytes, of this data file.
CTR oraDbDataFileDiskReads	1.3.6.1.4.1.111.4.1.3.1.4	Counter	read-only	The total number of reads issued against this data file since startup.
CTR oraDbDataFileDiskWrites	1.3.6.1.4.1.111.4.1.3.1.5	Counter	read-only	The total number of writes issued against this data file since startup.
CTR oraDbDataFileDiskReadBlocks	1.3.6.1.4.1.111.4.1.3.1.6	Counter	read-only	The total number of physical blocks read from this data file since startup.
CTR oraDbDataFileDiskWrittenBlocks	1.3.6.1.4.1.111.4.1.3.1.7	Counter	read-only	The total number of physical blocks written to this data file since startup.
CTR oraDbDataFileDiskReadTimeTicks	1.3.6.1.4.1.111.4.1.3.1.8	Counter	read-only	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.
CTR oraDbDataFileDiskWriteTimeTicks	1.3.6.1.4.1.111.4.1.3.1.9	Counter	read-only	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.
oraDbLibraryCacheTable	1.3.6.1.4.1.111.4.1.4		not-accessible	Information on libraryCache performance.
oraDbLibraryCacheEntry	1.3.6.1.4.1.111.4.1.4.1		not-accessible	LibraryCache information for each Oracle database.
INT oraDbLibraryCacheIndex	1.3.6.1.4.1.111.4.1.4.1.1	INTEGER	read-only	A unique integer for each row of the table.
STR oraDbLibraryCacheNameSpace	1.3.6.1.4.1.111.4.1.4.1.2	DisplayString	read-only	The namespace of the v$librarycache table that this row relates to.
CTR oraDbLibraryCacheGets	1.3.6.1.4.1.111.4.1.4.1.3	Counter	read-only	Number of times the system requests handles to library objects in this namespace.
CTR oraDbLibraryCacheGetHits	1.3.6.1.4.1.111.4.1.4.1.4	Counter	read-only	Number of times the handles are already allocated in the cache.
CTR oraDbLibraryCachePins	1.3.6.1.4.1.111.4.1.4.1.5	Counter	read-only	Number of times the system issues pin requests for objects in the cache in order to access them.
CTR oraDbLibraryCachePinHits	1.3.6.1.4.1.111.4.1.4.1.6	Counter	read-only	Number of times the objects the system is pinning are already allocated and initialized in the cache.
CTR oraDbLibraryCacheReloads	1.3.6.1.4.1.111.4.1.4.1.7	Counter	read-only	Number of times the library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated
CTR oraDbLibraryCacheInvalidations	1.3.6.1.4.1.111.4.1.4.1.8	Counter	read-only	Number of times that non-persistent library objects (like shared SQL areas) have been invalidated.
oraDbLibraryCacheSumTable	1.3.6.1.4.1.111.4.1.5		not-accessible	Information on library cache performance, summed over all library caches in a single database instance.
oraDbLibraryCacheSumEntry	1.3.6.1.4.1.111.4.1.5.1		not-accessible	LibraryCache information, summed over all library caches, for each Oracle database.
CTR oraDbLibraryCacheSumGets	1.3.6.1.4.1.111.4.1.5.1.1	Counter	read-only	Number of times the system requests handles to library objects, summed over all library caches in the instance.
CTR oraDbLibraryCacheSumGetHits	1.3.6.1.4.1.111.4.1.5.1.2	Counter	read-only	Number of times the handles are already allocated in the cache, summed over all library caches in the instance.
CTR oraDbLibraryCacheSumPins	1.3.6.1.4.1.111.4.1.5.1.3	Counter	read-only	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.
CTR oraDbLibraryCacheSumPinHits	1.3.6.1.4.1.111.4.1.5.1.4	Counter	read-only	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.
CTR oraDbLibraryCacheSumReloads	1.3.6.1.4.1.111.4.1.5.1.5	Counter	read-only	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.
CTR oraDbLibraryCacheSumInvalidations	1.3.6.1.4.1.111.4.1.5.1.6	Counter	read-only	Number of times that non-persistent library objects (like shared SQL areas) have been invalidated, summed over all library caches in the instance.
oraDbSGATable	1.3.6.1.4.1.111.4.1.6		not-accessible	Summary information on the System Global Area
oraDbSGAEntry	1.3.6.1.4.1.111.4.1.6.1		not-accessible	A single entry from the v$sga table
INT oraDbSGAFixedSize	1.3.6.1.4.1.111.4.1.6.1.1	INTEGER	read-only
INT oraDbSGAVariableSize	1.3.6.1.4.1.111.4.1.6.1.2	INTEGER	read-only
INT oraDbSGADatabaseBuffers	1.3.6.1.4.1.111.4.1.6.1.3	INTEGER	read-only
INT oraDbSGARedoBuffers	1.3.6.1.4.1.111.4.1.6.1.4	INTEGER	read-only
oraDbConfigTable	1.3.6.1.4.1.111.4.1.7		not-accessible	Oracle-specific configuration information global to a database.
oraDbConfigEntry	1.3.6.1.4.1.111.4.1.7.1		not-accessible	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, we make it easier to graph them along with the dynamic performance values that they affect. A complete list of parameters can be found in the Internet standard MIB 'Config' objects.
INT oraDbConfigDbBlockBuffers	1.3.6.1.4.1.111.4.1.7.1.1	INTEGER	read-only	The DB_BLOCK_BUFFERS parameter from the init.ora file
INT oraDbConfigDbBlockCkptBatch	1.3.6.1.4.1.111.4.1.7.1.2	INTEGER	read-only	The DB_BLOCK_CHECKPOINT_BATCH parameter from the init.ora file
INT oraDbConfigDbBlockSize	1.3.6.1.4.1.111.4.1.7.1.3	INTEGER	read-only	The DB_BLOCK_SIZE parameter from the init.ora file
INT oraDbConfigDbFileSimWrites	1.3.6.1.4.1.111.4.1.7.1.4	INTEGER	read-only	The DB_FILE_SIMULTANEOUS_WRITES parameter from the init.ora file
INT oraDbConfigDbMultiBlockReadCount	1.3.6.1.4.1.111.4.1.7.1.5	INTEGER	read-only	The DB_MULTIBLOCK_READ_COUNT parameter from the init.ora file
INT oraDbConfigDistLockTimeout	1.3.6.1.4.1.111.4.1.7.1.6	INTEGER	read-only	The DISTRIBUTED_LOCK_TIMEOUT parameter from the init.ora file
INT oraDbConfigDistRecoveryConnectHold	1.3.6.1.4.1.111.4.1.7.1.7	INTEGER	read-only	The DISTRIBUTED_RECOVERY_CONNECT_HOLD parameter from the init.ora file
INT oraDbConfigDistTransactions	1.3.6.1.4.1.111.4.1.7.1.8	INTEGER	read-only	The DISTRIBUTED_TRANSACTIONS parameter from the init.ora file
INT oraDbConfigLogArchiveBufferSize	1.3.6.1.4.1.111.4.1.7.1.9	INTEGER	read-only	The LOG_ARCHIVE_BUFFER_SIZE parameter from the init.ora file
INT oraDbConfigLogArchiveBuffers	1.3.6.1.4.1.111.4.1.7.1.10	INTEGER	read-only	The LOG_ARCHIVE_BUFFERS parameter from the init.ora file
INT oraDbConfigLogBuffer	1.3.6.1.4.1.111.4.1.7.1.11	INTEGER	read-only	The LOG_BUFFER parameter from the init.ora file
INT oraDbConfigLogCheckpointInterval	1.3.6.1.4.1.111.4.1.7.1.12	INTEGER	read-only	The LOG_CHECKPOINT_INTERVAL parameter from the init.ora file
INT oraDbConfigLogCheckpointTimeout	1.3.6.1.4.1.111.4.1.7.1.13	INTEGER	read-only	The LOG_CHECKPOINT_TIMEOUT parameter from the init.ora file
INT oraDbConfigLogFiles	1.3.6.1.4.1.111.4.1.7.1.14	INTEGER	read-only	The LOG_FILES parameter from the init.ora file
INT oraDbConfigMaxRollbackSegments	1.3.6.1.4.1.111.4.1.7.1.15	INTEGER	read-only	The MAX_ROLLBACK_SEGMENTS parameter from the init.ora file
INT oraDbConfigMTSMaxDispatchers	1.3.6.1.4.1.111.4.1.7.1.16	INTEGER	read-only	The MTS_MAX_DISPATCHERS parameter from the init.ora file
INT oraDbConfigMTSMaxServers	1.3.6.1.4.1.111.4.1.7.1.17	INTEGER	read-only	The MTS_MAX_SERVERS parameter from the init.ora file
INT oraDbConfigMTSServers	1.3.6.1.4.1.111.4.1.7.1.18	INTEGER	read-only	The MTS_SERVERS parameter from the init.ora file
INT oraDbConfigOpenCursors	1.3.6.1.4.1.111.4.1.7.1.19	INTEGER	read-only	The OPEN_CURSORS parameter from the init.ora file
INT oraDbConfigOpenLinks	1.3.6.1.4.1.111.4.1.7.1.20	INTEGER	read-only	The OPEN_LINKS parameter from the init.ora file
STR oraDbConfigOptimizerMode	1.3.6.1.4.1.111.4.1.7.1.21	DisplayString	read-only	The OPTIMIZER_MODE parameter from the init.ora file
INT oraDbConfigProcesses	1.3.6.1.4.1.111.4.1.7.1.22	INTEGER	read-only	The PROCESSES parameter from the init.ora file
T/F oraDbConfigSerializable	1.3.6.1.4.1.111.4.1.7.1.23	TruthValue	read-only	The SERIALIZABLE parameter from the init.ora file
INT oraDbConfigSessions	1.3.6.1.4.1.111.4.1.7.1.24	INTEGER	read-only	The SESSIONS parameter from the init.ora file
INT oraDbConfigSharedPool	1.3.6.1.4.1.111.4.1.7.1.25	INTEGER	read-only	The SHARED_POOL parameter from the init.ora file
INT oraDbConfigSortAreaSize	1.3.6.1.4.1.111.4.1.7.1.26	INTEGER	read-only	The SORT_AREA_SIZE parameter from the init.ora file
INT oraDbConfigSortAreaRetainedSize	1.3.6.1.4.1.111.4.1.7.1.27	INTEGER	read-only	The SORT_AREA_RETAINED_SIZE parameter from the init.ora file
INT oraDbConfigTransactions	1.3.6.1.4.1.111.4.1.7.1.28	INTEGER	read-only	The TRANSACTIONS parameter from the init.ora file
INT oraDbConfigTransactionsPerRollback	1.3.6.1.4.1.111.4.1.7.1.29	INTEGER	read-only	The TRANSACTIONS_PER_ROLLBACK parameter from the init.ora file

RFC description

Oracle database performance statistics and monitoring information for database tuning and optimization.

Start monitoring Oracle database server/RDBMS instance (performance counters) with a free 30-day trial of IPNetwork Monitor. Import MIBs, browse SNMP OIDs, create custom SNMP monitors, configure alerts, and monitor any SNMP-enabled network device from a single console.

Download ORADB-MIB

What Is ORADB-MIB?

Supported Devices

Monitoring Examples

What Can Be Monitored

This MIB depends on

Related MIBs

RFC description