Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Conventions

Part I List of Chapters

1 Overview of Oracle SNMP Support

• Benefits of Oracle SNMP Support
• How SNMP Works
• The Components of SNMP
• • Management Station
  • • Requirements for Implementing Oracle SNMP Support
  • Management Framework
  • Management Application
  • Managed Node
  • Master Agent
  • Subagent
• How SNMP Communications Are Performed
• Oracle Enterprise Manager and SNMP
• • SNMP Trap Notification
  • • SNMP Fetchlets
    • SNMP Receivelets
  • Enterprise Manager SNMP Subagent
• Management Information Base (MIB)

2 Configuring SNMP for Oracle

• Configuring SNMP on Microsoft Windows Platforms
• • Installing the SNMP Network Service
  • Configuring the SNMP Network Service
  • Integrating SNMP with Enterprise Manager SNMP Subagent
  • • Installing the Peer Executables
    • Configuring the SNMP Services File
    • Modifying the Oracle SNMP Peer Master Agent Configuration File
  • Starting the SNMP Environment
  • • Verifying Active UDP Ports
    • Manually Starting SNMP Services
    • Starting and Stopping SNMP Services by Batch File
  • Testing the SNMP Environment
  • • Testing the Value of an OID
    • Testing Oracle Specific Values
• Configuring SNMP on UNIX Platform
• • Using only an SNMP Console
  • Configuring the SNMP Master Agent
  • Starting the SNMP Agents
  • Loading the Oracle MIBs
• Configuring SNMP with Enterprise Manager
• • Controlling Enterprise Manager SNMP Subagent
  • Setting Up SNMP Trap Notifications

3 Oracle MIB Overview

• Oracle Products Providing SNMP Support
• • Oracle Database
  • Oracle Listener
  • Oracle Enterprise Manager
• MIBs Supporting These Products
• • Network Services MIB
  • Public RDBMS MIB
  • Private Oracle Database MIB
  • Other Oracle Private MIBs
• Interpreting SNMP OIDs
• • Interpreting Oracle OIDs
  • Interpreting OIDs for Oracle-Implemented Public MIBs
  • Interpreting OIDs for Instances of Oracle MIB Variables

4 Reading the MIB Variable Descriptions

• Variable Name Description
• MIB Definition

5 Designing Management Applications Based on Oracle MIBs

• Using MIB Variables for Different Purposes
• Using a Sufficient Sample Size to Calculate Tuning Ratios
• Presenting Performance Ratios Graphically
• Scaling MIB Variable Values Dynamically
• Working Around the Wraparound
• Most Useful Database Instance Performance Ratios

Part II List of Appendices

A Configuration Files

• Configuration Files
• User-configurable Parameters

B Interpreting Variables of the Oracle Database MIB

• oraDbSysTable
• oraDbSysConsistentChanges
• oraDbSysConsistentGets
• oraDbSysDbBlockChanges
• oraDbSysDbBlockGets
• oraDbSysFreeBufferInspected
• oraDbSysFreeBufferRequested
• oraDbSysParseCount
• oraDbSysPhysReads
• oraDbSysPhysWrites
• oraDbSysRedoEntries
• oraDbSysRedoLogSpaceRequests
• oraDbSysRedoSyncWrites
• oraDbSysSortsDisk
• oraDbSysSortsMemory
• oraDbSysSortsRows
• oraDbSysTableFetchRowid
• oraDbSysTableFetchContinuedRow
• oraDbSysTableScanBlocks
• oraDbSysTableScanRows
• oraDbSysTableScansLong
• oraDbSysTableScansShort
• oraDbSysUserCalls
• oraDbSysUserCommits
• oraDbSysUserRollbacks
• oraDbTablespaceTable
• oraDbTablespaceIndex
• oraDbTablespaceName
• oraDbTablespaceSizeAllocated
• oraDbTablespaceSizeUsed
• oraDbTablespaceState
• oraDbTablespaceLargestAvailableChunk
• oraDbDataFileTable
• oraDbDataFileIndex
• oraDbDataFileName
• oraDbDataFileSizeAllocated
• oraDbDataFileDiskReads
• oraDbDataFileDiskWrites
• oraDbDataFileDiskReadBlocks
• oraDbDataFileDiskWrittenBlocks
• oraDbDataFileDiskReadTimeTicks
• oraDbDataFileDiskWriteTimeTicks
• oraDbLibraryCacheTable
• oraDbLibraryCacheIndex
• oraDbLibraryCacheNameSpace
• oraDbLibraryCacheGets
• oraDbLibraryCacheGetHits
• oraDbLibraryCachePins
• oraDbLibraryCachePinHits
• oraDbLibraryCacheReloads
• oraDbLibraryCacheInvalidations
• oraDbLibraryCacheSumTable
• oraDbLibraryCacheSumGets
• oraDbLibraryCacheSumGetHits
• oraDbLibraryCacheSumPins
• oraDbLibraryCacheSumPinHits
• oraDbLibraryCacheSumReloads
• oraDbLibraryCacheSumInvalidations
• oraDbSGATable
• oraDbSGAFixedSize
• oraDbSGAVariableSize
• oraDbSGADatabaseBuffers
• oraDbSGARedoBuffers
• oraDbConfigTable
• oraDbConfigDbBlockBuffers
• oraDbConfigDbBlockSize
• oraDbConfigDbMultiBlockReadCount
• oraDbConfigLogBuffer
• oraDbConfigLogCheckpointInterval
• oraDbConfigLogCheckpointTimeout
• oraDbConfigOpenCursors
• oraDbConfigOpenLinks
• oraDbConfigOptimizerMode
• oraDbConfigProcesses
• oraDbConfigSessions
• oraDbConfigSharedPool
• oraDbConfigSortAreaSize
• oraDbConfigSortAreaRetainedSize
• oraDbConfigTransactions
• oraDbConfigTransactionsPerRollback

C Interpreting Variables of the Oracle Network Listener MIB

• oraListenerTable
• oraListenerIndex
• oraListenerName
• oraListenerVersion
• oraListenerStartDate
• oraListenerUptime
• oraListenerTraceLevel
• oraListenerSecurityLevel
• oraListenerParameterFile
• oraListenerLogFile
• oraListenerTraceFile
• oraListenerState
• oraListenerNumberOfServices
• oraListenerContact
• oraSIDTable
• oraSIDListenerIndex
• oraSIDName
• oraSIDCurrentConnectedClients
• oraSIDReservedConnections
• oraDedicatedSrvTable
• oraDedicatedSrvIndex
• oraDedicatedSrvEstablishedConnections
• oraDedicatedSrvRejectedConnections
• oraDispatcherTable
• OraDispatcherIndex
• oraDispatcherEstablishedConnections
• oraDispatcherRejectedConnections
• oraDispatcherCurrentConnections
• oraDispatcherMaximumConnections
• oraDispatcherState
• oraDispatcherProtocolInfo
• oraPrespawnedSrvTable
• oraPrespawnedSrvIndex
• oraPrespawnedSrvEstablishedConnections
• oraPrespawnedSrvRejectedConnections
• oraPrespawnedSrvCurrentConnections
• oraPrespawnedSrvMaximumConnections
• oraPrespawnedSrvState
• oraPrespawnedSrvProtocolInfo
• oraPrespawnedSrvProcessorID
• oraListenAddressTable
• oraListenAddressIndex
• oraListenAddress
• oraListenerTraps
• oraListenerStateChange

D Interpreting Variables of the Public RDBMS MIB

• rdbmsDbTable
• rdbmsDbIndex
• rdbmsDbPrivateMIBOID
• rdbmsDbVendorName
• rdbmsDbName
• rdbmsDbContact
• rdbmsDbInfoTable
• rdbmsDbInfoProductName
• rdbmsDbInfoVersion
• rdbmsDbInfoSizeUnits
• rdbmsDbInfoSizeAllocated
• rdbmsDbInfoSizeUsed
• rdbmsSrvTable
• rdbmsSrvPrivateMIBOID
• rdbmsSrvVendorName
• rdbmsSrvProductName
• rdbmsSrvContact
• rdbmsSrvInfoTable
• rdbmsSrvInfoStartupTime
• rdbmsSrvInfoFinishedTransactions
• rdbmsSrvInfoDiskReads
• rdbmsSrvInfoLogicalReads
• rdbmsSrvInfoDiskWrites
• rdbmsSrvInfoLogicalWrites
• rdbmsSrvInfoPageReads
• rdbmsSrvInfoPageWrites
• rdbmsSrvInfoRequestsHandled
• rdbmsSrvInfoHighwaterInboundAssociations
• rdbmsSrvInfoMaxInboundAssociations
• rdbmsSrvParamTable
• rdbmsSrvParamName
• rdbmsSrvParamSubIndex
• rdbmsSrvParamCurrValue
• rdbmsRelTable
• rdbmsRelState
• rdbmsTraps
• rdbmsStateChange

E Interpreting Implemented Variables of the Network Services MIB

• applTable
• applIndex
• applName
• applVersion
• applUptime
• applOperStatus
• applLastChange
• applInboundAssociations

F Interpreting Variables of the Enterprise Manager MIB

• oraEM4AlertTable
• • oraEM4AlertTargetName
  • oraEM4AlertTargetType
  • oraEM4AlertHostName
  • oraEM4AlertMetricName
  • oraEM4AlertKeyName
  • oraEM4AlertKeyValue
  • oraEM4AlertTimeStamp
  • oraEM4AlertSeverity
  • oraEM4AlertMessage
  • oraEM4AlertRuleName
  • oraEM4AlertRuleOwner
  • oraEM4AlertMetricValue
  • oraEM4AlertContext
• oraEM4JobAlertTable
• • oraEM4JobAlertJobName
  • oraEM4JobAlertJobOwner
  • oraEM4JobAlertJobType
  • oraEM4JobAlertJobStatus
  • oraEM4JobAlertTargets
  • oraEM4JobAlertTimeStamp
  • oraEM4JobAlertRuleName
  • oraEM4JobAlertRuleOwner
  • oraEM4JobAlertMetricName
  • oraEM4JobAlertMetricValue
  • oraEM4JobAlertContext
  • oraEM4JobAlertKeyName
  • oraEM4JobAlertKeyValue
  • oraEM4JobAlertSeverity

Glossary

Index