OraDbSysEntry |
|
SEQUENCE |
|
|
|
|
oraDbSysConsistentChanges |
Counter |
|
|
oraDbSysConsistentGets |
Counter |
|
|
oraDbSysDbBlockChanges |
Counter |
|
|
oraDbSysDbBlockGets |
Counter |
|
|
oraDbSysFreeBufferInspected |
Counter |
|
|
oraDbSysFreeBufferRequested |
Counter |
|
|
oraDbSysParseCount |
Counter |
|
|
oraDbSysPhysReads |
Counter |
|
|
oraDbSysPhysWrites |
Counter |
|
|
oraDbSysRedoEntries |
Counter |
|
|
oraDbSysRedoLogSpaceRequests |
Counter |
|
|
oraDbSysRedoSyncWrites |
Counter |
|
|
oraDbSysSortsDisk |
Counter |
|
|
oraDbSysSortsMemory |
Counter |
|
|
oraDbSysSortsRows |
Counter |
|
|
oraDbSysTableFetchRowid |
Counter |
|
|
oraDbSysTableFetchContinuedRow |
Counter |
|
|
oraDbSysTableScanBlocks |
Counter |
|
|
oraDbSysTableScanRows |
Counter |
|
|
oraDbSysTableScansLong |
Counter |
|
|
oraDbSysTableScansShort |
Counter |
|
|
oraDbSysUserCalls |
Counter |
|
|
oraDbSysUserCommits |
Counter |
|
|
oraDbSysUserRollbacks |
Counter |
|
|
oraDbSysWriteRequests |
Counter |
|
OraDbTablespaceEntry |
|
SEQUENCE |
|
|
|
|
oraDbTablespaceIndex |
INTEGER |
|
|
oraDbTablespaceName |
DisplayString |
|
|
oraDbTablespaceSizeAllocated |
INTEGER |
-2147483648..2147483647 |
|
oraDbTablespaceSizeUsed |
INTEGER |
-2147483648..2147483647 |
|
oraDbTablespaceState |
INTEGER |
|
|
oraDbTablespaceLargestAvailableChunk |
INTEGER |
-2147483648..2147483647 |
OraDbDataFileEntry |
|
SEQUENCE |
|
|
|
|
oraDbDataFileIndex |
INTEGER |
|
|
oraDbDataFileName |
DisplayString |
|
|
oraDbDataFileSizeAllocated |
INTEGER |
-2147483648..2147483647 |
|
oraDbDataFileDiskReads |
Counter |
|
|
oraDbDataFileDiskWrites |
Counter |
|
|
oraDbDataFileDiskReadBlocks |
Counter |
|
|
oraDbDataFileDiskWrittenBlocks |
Counter |
|
|
oraDbDataFileDiskReadTimeTicks |
Counter |
|
|
oraDbDataFileDiskWriteTimeTicks |
Counter |
|
OraDbLibraryCacheEntry |
|
SEQUENCE |
|
|
|
|
oraDbLibraryCacheIndex |
INTEGER |
|
|
oraDbLibraryCacheNameSpace |
DisplayString |
|
|
oraDbLibraryCacheGets |
Counter |
|
|
oraDbLibraryCacheGetHits |
Counter |
|
|
oraDbLibraryCachePins |
Counter |
|
|
oraDbLibraryCachePinHits |
Counter |
|
|
oraDbLibraryCacheReloads |
Counter |
|
|
oraDbLibraryCacheInvalidations |
Counter |
|
OraDbLibraryCacheSumEntry |
|
SEQUENCE |
|
|
|
|
oraDbLibraryCacheSumGets |
Counter |
|
|
oraDbLibraryCacheSumGetHits |
Counter |
|
|
oraDbLibraryCacheSumPins |
Counter |
|
|
oraDbLibraryCacheSumPinHits |
Counter |
|
|
oraDbLibraryCacheSumReloads |
Counter |
|
|
oraDbLibraryCacheSumInvalidations |
Counter |
|
OraDbConfigEntry |
|
SEQUENCE |
|
|
|
|
oraDbConfigDbBlockBuffers |
INTEGER |
|
|
oraDbConfigDbBlockCkptBatch |
INTEGER |
|
|
oraDbConfigDbBlockSize |
INTEGER |
|
|
oraDbConfigDbFileSimWrites |
INTEGER |
|
|
oraDbConfigDbMultiBlockReadCount |
INTEGER |
|
|
oraDbConfigDistLockTimeout |
INTEGER |
|
|
oraDbConfigDistRecoveryConnectHold |
INTEGER |
|
|
oraDbConfigDistTransactions |
INTEGER |
|
|
oraDbConfigLogArchiveBufferSize |
INTEGER |
|
|
oraDbConfigLogArchiveBuffers |
INTEGER |
|
|
oraDbConfigLogBuffer |
INTEGER |
|
|
oraDbConfigLogCheckpointInterval |
INTEGER |
|
|
oraDbConfigLogCheckpointTimeout |
INTEGER |
|
|
oraDbConfigLogFiles |
INTEGER |
|
|
oraDbConfigMaxRollbackSegments |
INTEGER |
|
|
oraDbConfigMTSMaxDispatchers |
INTEGER |
|
|
oraDbConfigMTSMaxServers |
INTEGER |
|
|
oraDbConfigMTSServers |
INTEGER |
|
|
oraDbConfigOpenCursors |
INTEGER |
|
|
oraDbConfigOpenLinks |
INTEGER |
|
|
oraDbConfigOptimizerMode |
DisplayString |
|
|
oraDbConfigProcesses |
INTEGER |
|
|
oraDbConfigSerializable |
TruthValue |
|
|
oraDbConfigSessions |
INTEGER |
|
|
oraDbConfigSharedPool |
INTEGER |
|
|
oraDbConfigSortAreaRetainedSize |
INTEGER |
|
|
oraDbConfigSortAreaSize |
INTEGER |
|
|
oraDbConfigTransactions |
INTEGER |
|
|
oraDbConfigTransactionsPerRollback |
INTEGER |
|
oraDbSysEntry |
1.3.6.1.4.1.111.4.1.1.1 |
Selected info from the v 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. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbSysEntry |
|
|
oraDbTablespaceEntry |
1.3.6.1.4.1.111.4.1.2.1 |
Information for each tablespace within an Oracle database. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbTablespaceEntry |
|
|
oraDbDataFileEntry |
1.3.6.1.4.1.111.4.1.3.1 |
Information for each data file within an Oracle database. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbDataFileEntry |
|
|
oraDbLibraryCacheEntry |
1.3.6.1.4.1.111.4.1.4.1 |
LibraryCache information for each Oracle database. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbLibraryCacheEntry |
|
|
oraDbLibraryCacheSumEntry |
1.3.6.1.4.1.111.4.1.5.1 |
LibraryCache information, summed over all library caches,
for each Oracle database. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbLibraryCacheSumEntry |
|
|
oraDbSGAEntry |
1.3.6.1.4.1.111.4.1.6.1 |
A single entry from the v table |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbSGAEntry |
|
|
oraDbConfigEntry |
1.3.6.1.4.1.111.4.1.7.1 |
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. |
Status: mandatory |
Access: not-accessible |
OBJECT-TYPE |
|
|
|
|
OraDbConfigEntry |
|
|