ORADB-MIB
AI MIB Summary
Standard SNMP MIB module defining data structures for ORADB-MIB.
105
Objects
Active
Status
4
Dependencies
Imported Objects
Objects
105 total| Object Name |
|---|
oracle OBJECT IDENTIFIER .1.3.6.1.4.1.111 |
RFC1213-MIB Unknown .1.3.6.1.4.1.111 |
oraDbMIB OBJECT IDENTIFIER .1.3.6.1.4.1.111.4 |
oraDbObjects OBJECT IDENTIFIER .1.3.6.1.4.1.111.4.1 |
oraDbSysTableOracle-specific performance information global to a database. SEQUENCE OF OraDbSysEntry .1.3.6.1.4.1.111.4.1.1 |
oraDbSysEntrySelected 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. OraDbSysEntry .1.3.6.1.4.1.111.4.1.1.1 |
oraDbSysConsistentChangesthe 'consistent changes' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.1 |
oraDbSysConsistentGetsthe 'consistent gets' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.2 |
oraDbSysDbBlockChangesthe 'Db block changes' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.3 |
oraDbSysDbBlockGetsthe 'db block gets' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.4 |
oraDbSysFreeBufferInspectedthe 'free buffer inspected' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.5 |
oraDbSysFreeBufferRequestedthe 'free buffer requested' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.6 |
oraDbSysParseCountthe 'parse count' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.7 |
oraDbSysPhysReadsthe 'physical reads' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.8 |
oraDbSysPhysWritesthe 'physical writes' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.9 |
oraDbSysRedoEntriesthe 'redo entries' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.10 |
oraDbSysRedoLogSpaceRequeststhe 'redo log space requests' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.11 |
oraDbSysRedoSyncWritesthe 'redo synch writes' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.12 |
oraDbSysSortsDiskthe 'sorts (disk)' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.13 |
oraDbSysSortsMemorythe 'sorts (memory)' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.14 |
oraDbSysSortsRowsthe 'sorts (rows)' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.15 |
oraDbSysTableFetchRowidthe 'table fetch by rowid' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.16 |
oraDbSysTableFetchContinuedRowthe 'table fetch continued row' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.17 |
oraDbSysTableScanBlocksthe 'table scan blocks gotten' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.18 |
oraDbSysTableScanRowsthe 'table scan rows gotten' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.19 |
oraDbSysTableScansLongthe 'table scans (long tables)' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.20 |
oraDbSysTableScansShortthe 'table scans (short tables)' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.21 |
oraDbSysUserCallsthe 'user calls' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.22 |
oraDbSysUserCommitsthe 'user commits' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.23 |
oraDbSysUserRollbacksthe 'user rollbacks' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.24 |
oraDbSysWriteRequeststhe 'write requests' parameter from v$sysstatro Counter .1.3.6.1.4.1.111.4.1.1.1.25 |
oraDbTablespaceTableInformation on tablespaces within an Oracle database. SEQUENCE OF OraDbTablespaceEntry .1.3.6.1.4.1.111.4.1.2 |
oraDbTablespaceEntryInformation for each tablespace within an Oracle database. OraDbTablespaceEntry .1.3.6.1.4.1.111.4.1.2.1 |
oraDbTablespaceIndexA numeric index, unique among tablespaces within a single
Oracle database.ro INTEGER .1.3.6.1.4.1.111.4.1.2.1.1 |
oraDbTablespaceNameThe name of this tablespace.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.111.4.1.2.1.2 |
oraDbTablespaceSizeAllocatedThe 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.ro INTEGER (-2147483648..2147483647) .1.3.6.1.4.1.111.4.1.2.1.3 |
oraDbTablespaceSizeUsedThe amount of disk space, in kilobytes, which is actually in
use for storing data.ro INTEGER (-2147483648..2147483647) .1.3.6.1.4.1.111.4.1.2.1.4 |
oraDbTablespaceStateThe 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.ro Enumeration .1.3.6.1.4.1.111.4.1.2.1.5 |
oraDbTablespaceLargestAvailableChunkThe size, in kilobytes, of the largest contiguous set of free
data blocks in the tablespace.ro INTEGER (-2147483648..2147483647) .1.3.6.1.4.1.111.4.1.2.1.6 |
oraDbDataFileTableInformation on data files within an Oracle database. SEQUENCE OF OraDbDataFileEntry .1.3.6.1.4.1.111.4.1.3 |
oraDbDataFileEntryInformation for each data file within an Oracle database. OraDbDataFileEntry .1.3.6.1.4.1.111.4.1.3.1 |
oraDbDataFileIndexA numeric index, unique among data files associated with a
single tablespace.ro INTEGER .1.3.6.1.4.1.111.4.1.3.1.1 |
oraDbDataFileNameThe fully-qualified name of this datafile.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.111.4.1.3.1.2 |
oraDbDataFileSizeAllocatedThe allocated size, in kilobytes, of this data file.ro INTEGER (-2147483648..2147483647) .1.3.6.1.4.1.111.4.1.3.1.3 |
oraDbDataFileDiskReadsThe total number of reads issued against this data file since
startup.ro Counter .1.3.6.1.4.1.111.4.1.3.1.4 |
oraDbDataFileDiskWritesThe total number of writes issued against this data file since
startup.ro Counter .1.3.6.1.4.1.111.4.1.3.1.5 |
oraDbDataFileDiskReadBlocksThe total number of physical blocks read from this data file
since startup.ro Counter .1.3.6.1.4.1.111.4.1.3.1.6 |
oraDbDataFileDiskWrittenBlocksThe total number of physical blocks written to this data file
since startup.ro Counter .1.3.6.1.4.1.111.4.1.3.1.7 |
oraDbDataFileDiskReadTimeTicksThe 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.ro Counter .1.3.6.1.4.1.111.4.1.3.1.8 |
oraDbDataFileDiskWriteTimeTicksThe 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.ro Counter .1.3.6.1.4.1.111.4.1.3.1.9 |
oraDbLibraryCacheTableInformation on libraryCache performance. SEQUENCE OF OraDbLibraryCacheEntry .1.3.6.1.4.1.111.4.1.4 |
oraDbLibraryCacheEntryLibraryCache information for each Oracle database. OraDbLibraryCacheEntry .1.3.6.1.4.1.111.4.1.4.1 |
oraDbLibraryCacheIndexA unique integer for each row of the table.ro INTEGER .1.3.6.1.4.1.111.4.1.4.1.1 |
oraDbLibraryCacheNameSpaceThe namespace of the v$librarycache table that this
row relates to.ro DisplayString (SNMPv2-TC) .1.3.6.1.4.1.111.4.1.4.1.2 |
oraDbLibraryCacheGetsNumber of times the system requests handles to library
objects in this namespace.ro Counter .1.3.6.1.4.1.111.4.1.4.1.3 |
oraDbLibraryCacheGetHitsNumber of times the handles are already allocated in
the cache.ro Counter .1.3.6.1.4.1.111.4.1.4.1.4 |
oraDbLibraryCachePinsNumber of times the system issues pin requests
for objects in the cache in order to access them.ro Counter .1.3.6.1.4.1.111.4.1.4.1.5 |
oraDbLibraryCachePinHitsNumber of times the objects the system is pinning
are already allocated and initialized in the cache.ro Counter .1.3.6.1.4.1.111.4.1.4.1.6 |
oraDbLibraryCacheReloadsNumber of times the library objects have to be reinitialized
and reloaded with data because they have been aged out or
invalidatedro Counter .1.3.6.1.4.1.111.4.1.4.1.7 |
oraDbLibraryCacheInvalidationsNumber of times that non-persistent library objects
(like shared SQL areas) have been invalidated.ro Counter .1.3.6.1.4.1.111.4.1.4.1.8 |
oraDbLibraryCacheSumTableInformation on library cache performance, summed over all
library caches in a single database instance. SEQUENCE OF OraDbLibraryCacheSumEntry .1.3.6.1.4.1.111.4.1.5 |
oraDbLibraryCacheSumEntryLibraryCache information, summed over all library caches,
for each Oracle database. OraDbLibraryCacheSumEntry .1.3.6.1.4.1.111.4.1.5.1 |
oraDbLibraryCacheSumGetsNumber of times the system requests handles to library
objects, summed over all library caches in the instance.ro Counter .1.3.6.1.4.1.111.4.1.5.1.1 |
oraDbLibraryCacheSumGetHitsNumber of times the handles are already allocated in
the cache, summed over all library caches in the instance.ro Counter .1.3.6.1.4.1.111.4.1.5.1.2 |
oraDbLibraryCacheSumPinsNumber 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.ro Counter .1.3.6.1.4.1.111.4.1.5.1.3 |
oraDbLibraryCacheSumPinHitsNumber of times the objects the system is pinning
are already allocated and initialized in a cache,
summed over all library caches in the instance.ro Counter .1.3.6.1.4.1.111.4.1.5.1.4 |
oraDbLibraryCacheSumReloadsNumber 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.ro Counter .1.3.6.1.4.1.111.4.1.5.1.5 |
oraDbLibraryCacheSumInvalidationsNumber of times that non-persistent library objects
(like shared SQL areas) have been invalidated, summed over
all library caches in the instance.ro Counter .1.3.6.1.4.1.111.4.1.5.1.6 |
oraDbSGATableSummary information on the System Global Area SEQUENCE OF OraDbSGAEntry .1.3.6.1.4.1.111.4.1.6 |
oraDbSGAEntryA single entry from the v$sga table OraDbSGAEntry .1.3.6.1.4.1.111.4.1.6.1 |
oraDbSGAFixedSizero INTEGER .1.3.6.1.4.1.111.4.1.6.1.1 |
oraDbSGAVariableSizero INTEGER .1.3.6.1.4.1.111.4.1.6.1.2 |
oraDbSGADatabaseBuffersro INTEGER .1.3.6.1.4.1.111.4.1.6.1.3 |
oraDbSGARedoBuffersro INTEGER .1.3.6.1.4.1.111.4.1.6.1.4 |
oraDbConfigTableOracle-specific configuration information global to a database. SEQUENCE OF OraDbConfigEntry .1.3.6.1.4.1.111.4.1.7 |
oraDbConfigEntryOracle-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. OraDbConfigEntry .1.3.6.1.4.1.111.4.1.7.1 |
oraDbConfigDbBlockBuffersThe DB_BLOCK_BUFFERS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.1 |
oraDbConfigDbBlockCkptBatchThe DB_BLOCK_CHECKPOINT_BATCH parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.2 |
oraDbConfigDbBlockSizeThe DB_BLOCK_SIZE parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.3 |
oraDbConfigDbFileSimWritesThe DB_FILE_SIMULTANEOUS_WRITES parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.4 |
oraDbConfigDbMultiBlockReadCountThe DB_MULTIBLOCK_READ_COUNT parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.5 |
oraDbConfigDistLockTimeoutThe DISTRIBUTED_LOCK_TIMEOUT parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.6 |
oraDbConfigDistRecoveryConnectHoldThe DISTRIBUTED_RECOVERY_CONNECT_HOLD parameter from the
init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.7 |
oraDbConfigDistTransactionsThe DISTRIBUTED_TRANSACTIONS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.8 |
oraDbConfigLogArchiveBufferSizeThe LOG_ARCHIVE_BUFFER_SIZE parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.9 |
oraDbConfigLogArchiveBuffersThe LOG_ARCHIVE_BUFFERS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.10 |
oraDbConfigLogBufferThe LOG_BUFFER parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.11 |
oraDbConfigLogCheckpointIntervalThe LOG_CHECKPOINT_INTERVAL parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.12 |
oraDbConfigLogCheckpointTimeoutThe LOG_CHECKPOINT_TIMEOUT parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.13 |
oraDbConfigLogFilesThe LOG_FILES parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.14 |
oraDbConfigMaxRollbackSegmentsThe MAX_ROLLBACK_SEGMENTS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.15 |
oraDbConfigMTSMaxDispatchersThe MTS_MAX_DISPATCHERS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.16 |
oraDbConfigMTSMaxServersThe MTS_MAX_SERVERS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.17 |
oraDbConfigMTSServersThe MTS_SERVERS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.18 |
oraDbConfigOpenCursorsThe OPEN_CURSORS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.19 |
oraDbConfigOpenLinksThe OPEN_LINKS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.20 |
oraDbConfigOptimizerModeThe OPTIMIZER_MODE parameter from the init.ora filero DisplayString (SNMPv2-TC) .1.3.6.1.4.1.111.4.1.7.1.21 |
oraDbConfigProcessesThe PROCESSES parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.22 |
oraDbConfigSerializableThe SERIALIZABLE parameter from the init.ora filero TruthValue (SNMPv2-TC) .1.3.6.1.4.1.111.4.1.7.1.23 |
oraDbConfigSessionsThe SESSIONS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.24 |
oraDbConfigSharedPoolThe SHARED_POOL parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.25 |
oraDbConfigSortAreaSizeThe SORT_AREA_SIZE parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.26 |
oraDbConfigSortAreaRetainedSizeThe SORT_AREA_RETAINED_SIZE parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.27 |
oraDbConfigTransactionsThe TRANSACTIONS parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.28 |
oraDbConfigTransactionsPerRollbackThe TRANSACTIONS_PER_ROLLBACK parameter from the init.ora filero INTEGER .1.3.6.1.4.1.111.4.1.7.1.29 |