Oracle SNMP. Support Reference Guide

This guide covers the Oracle SNMP Support feature and the public and private MIBs that support its use with certain products. This information is provided to assist you in developing SNMP-based management applications for these products.

---

Table of contents :
Contents……Page 3
Send Us Your Comments……Page 19
Preface……Page 21
1 Overview of Oracle SNMP Support……Page 27
Benefits of Oracle SNMP Support……Page 28
Management Station……Page 29
Management Framework……Page 30
Management Application……Page 32
Subagent……Page 33
Management Information Base (MIB)……Page 34
How SNMP Communications Are Performed……Page 36
SNMP Support On Oracle……Page 37
Installing the SNMP Network Service……Page 39
Configuring the SNMP Network Service……Page 40
Configuring the SNMP Services File……Page 41
Modifying the Master Peer Agent Configuration File……Page 42
Manually Starting SNMP Services……Page 44
Testing the SNMP Environment……Page 45
Testing the Value of an OID……Page 46
Using only an SNMP Console……Page 47
Starting the SNMP Agents……Page 48
Configuring SNMP with Enterprise Manager……Page 49
Oracle Database……Page 51
Network Services MIB……Page 52
Other Oracle Private MIBs……Page 53
Interpreting Oracle OIDs……Page 54
Interpreting OIDs for Oracle-Implemented Public MIBs……Page 55
Interpreting OIDs for Instances of Oracle MIB Variables……Page 56
Using a Sufficient Sample Size to Calculate Tuning Ratios……Page 59
Working Around the Wraparound……Page 60
Most Useful Database Instance Performance Ratios……Page 61
Variable name……Page 65
A Interpreting Variables of the Oracle Database MIB……Page 67
oraDbSysTable……Page 68
oraDbSysConsistentChanges……Page 69
oraDbSysConsistentGets……Page 70
oraDbSysDbBlockChanges……Page 71
oraDbSysFreeBufferInspected……Page 72
oraDbSysFreeBufferRequested……Page 73
oraDbSysPhysReads……Page 74
oraDbSysPhysWrites……Page 75
oraDbSysRedoLogSpaceRequests……Page 76
oraDbSysRedoSyncWrites……Page 77
oraDbSysSortsMemory……Page 78
oraDbSysSortsRows……Page 79
oraDbSysTableFetchRowid……Page 80
oraDbSysTableScanBlocks……Page 81
oraDbSysTableScanRows……Page 82
oraDbSysTableScansShort……Page 83
oraDbSysUserCalls……Page 84
oraDbSysUserRollbacks……Page 85
oraDbSysWriteRequests……Page 86
oraDbTablespaceIndex……Page 87
oraDbTablespaceName……Page 88
oraDbTablespaceSizeUsed……Page 89
oraDbTablespaceState……Page 90
oraDbDataFileTable……Page 91
oraDbDataFileIndex……Page 92
oraDbDataFileName……Page 93
oraDbDataFileDiskReads……Page 94
oraDbDataFileDiskReadBlocks……Page 95
oraDbDataFileDiskWrittenBlocks……Page 96
oraDbDataFileDiskWriteTimeTicks……Page 97
oraDbLibraryCacheTable……Page 98
oraDbLibraryCacheIndex……Page 99
oraDbLibraryCacheGets……Page 100
oraDbLibraryCachePins……Page 101
oraDbLibraryCachePinHits……Page 102
oraDbLibraryCacheInvalidations……Page 103
oraDbLibraryCacheSumGets……Page 104
oraDbLibraryCacheSumGetHits……Page 105
oraDbLibraryCacheSumPinHits……Page 106
oraDbLibraryCacheSumReloads……Page 107
oraDbSGATable……Page 108
oraDbSGAFixedSize……Page 109
oraDbSGADatabaseBuffers……Page 110
oraDbConfigTable……Page 111
oraDbConfigDbBlockBuffers……Page 113
oraDbConfigDbBlockSize……Page 114
oraDbConfigDbFileSimWrites……Page 115
oraDbConfigDistLockTimeout……Page 116
oraDbConfigDistTransactions……Page 117
oraDbConfigLogArchiveBufferSize……Page 118
oraDbConfigLogBuffer……Page 119
oraDbConfigLogCheckpointTimeout……Page 120
oraDbConfigLogFiles……Page 121
oraDbConfigMTSMaxDispatchers……Page 122
oraDbConfigMTSServers……Page 123
oraDbConfigOpenCursors……Page 124
oraDbConfigOptimizerMode……Page 125
oraDbConfigProcesses……Page 126
oraDbConfigSessions……Page 127
oraDbConfigSharedPool……Page 128
oraDbConfigSortAreaRetainedSize……Page 129
oraDbConfigTransactionsPerRollback……Page 130
oraRepSchemaTable……Page 131
oraRepSchemaName……Page 132
oraRepSchemaStatus……Page 133
oraRepSchemaLinks……Page 134
oraRepMasterSchema Table……Page 135
oraRepMasterSchemaResolvedConflicts……Page 136
oraRepSnapshotSchemaTable……Page 137
oraRepSnapshotSchemaMaster……Page 138
oraRepLinkTable……Page 139
oraRepLinkIndex……Page 140
oraRepLinkDeferredTransactions……Page 141
oraRepLinkErrors……Page 142
oraRepLinkAdminRequests……Page 143
oraListenerTable……Page 145
oraListenerIndex……Page 146
oraListenerName……Page 147
oraListenerStartDate……Page 148
oraListenerTraceLevel……Page 149
oraListenerSecurityLevel……Page 150
oraListenerLogFile……Page 151
oraListenerState……Page 152
oraListenerNumberOfServices……Page 153
oraSIDTable……Page 154
oraSIDListenerIndex……Page 155
oraSIDCurrentConnectedClients……Page 156
oraSIDReservedConnections……Page 157
oraDedicatedSrvIndex……Page 158
oraDedicatedSrvEstablishedConnections……Page 159
oraDispatcherTable……Page 160
OraDispatcherIndex……Page 161
oraDispatcherRejectedConnections……Page 162
oraDispatcherMaximumConnections……Page 163
oraDispatcherState……Page 164
oraPrespawnedSrvTable……Page 165
oraPrespawnedSrvIndex……Page 166
oraPrespawnedSrvRejectedConnections……Page 167
oraPrespawnedSrvCurrentConnections……Page 168
oraPrespawnedSrvState……Page 169
oraPrespawnedSrvProcessorID……Page 170
oraListenAddressIndex……Page 171
oraListenAddress……Page 172
oraListenerStateChange……Page 173
oraNamesTNSTable……Page 175
oraNamesTNSTraceLevel……Page 176
oraNamesTNSLogFile……Page 177
oraNamesTNSTraceFile……Page 178
oraNamesTNSReload……Page 179
oraNamesConfigTable……Page 180
oraNamesConfigAdminRegion……Page 182
oraNamesConfigAutoRefreshExpire……Page 183
oraNamesConfigAutoRefreshRetry……Page 184
oraNamesConfigCacheCheckpointInterval……Page 185
oraNamesConfigDefaultForwardersOnly……Page 186
oraNamesConfigForwardingAvailable……Page 187
oraNamesConfigLogStatsInterval……Page 188
oraNamesConfigNoModifyRequests……Page 189
oraNamesConfigResetStatsInterval……Page 190
oraNamesServerTable……Page 191
oraNamesServerQueriesReceived……Page 193
oraNamesServerCorruptMessagesReceived……Page 194
oraNamesServerResponsesSent……Page 195
oraNamesServerLookupsAttempted……Page 196
oraNamesServerLookupFailures……Page 197
oraNamesServerExactMatches……Page 198
oraNamesServerForwardTimeouts……Page 199
oraNamesServerRequestsForwarded……Page 200
oraNamesServerReloadCheckFailures……Page 201
oraNamesServerAdminRegion……Page 202
D Interpreting Variables of the Public RDBMS MIB……Page 205
rdbmsDbIndex……Page 206
rdbmsDbVendorName……Page 207
rdbmsDbName……Page 208
rdbmsDbInfoTable……Page 209
rdbmsDbInfoProductName……Page 210
rdbmsDbInfoSizeUnits……Page 211
rdbmsDbInfoSizeAllocated……Page 212
rdbmsSrvTable……Page 213
rdbmsSrvPrivateMIBOID……Page 214
rdbmsSrvProductName……Page 215
rdbmsSrvContact……Page 216
rdbmsSrvInfoTable……Page 217
rdbmsSrvInfoFinishedTransactions……Page 218
rdbmsSrvInfoDiskReads……Page 219
rdbmsSrvInfoDiskWrites……Page 220
rdbmsSrvInfoLogicalWrites……Page 221
rdbmsSrvInfoPageWrites……Page 222
rdbmsSrvInfoRequestsHandled……Page 223
rdbmsSrvInfoMaxInboundAssociations……Page 224
rdbmsSrvParamTable……Page 225
rdbmsSrvParamName……Page 226
rdbmsSrvParamCurrValue……Page 227
rdbmsRelTable……Page 228
rdbmsTraps……Page 229
rdbmsStateChange……Page 230
applTable……Page 231
applIndex……Page 233
applName……Page 234
applUptime……Page 235
applOperStatus……Page 236
applInboundAssociations……Page 237
applAccumulatedInboundAssociations……Page 238
applRejectedInboundAssociations……Page 239
applFailedOutboundAssociations……Page 240
oraAgentEventTable……Page 243
oraAgentEventName……Page 244
oraAgentEventID……Page 245
oraAgentEventTime……Page 246
oraAgentEventUser……Page 247
oraAgentEventAppID……Page 248
oraAgentEventArguments……Page 249
oraAgentEventResults……Page 250
oraAgentEventOcc……Page 251
Glossary……Page 253
Index……Page 261