Oracle SNMP Support Reference Guide
Release 8.1.5

A67822-01

Library

Product

Index

Next

Contents

Title and Copyright Information

Send Us Your Comments

Preface

1 Overview of Oracle SNMP Support

Benefits of Oracle SNMP Support
How SNMP Works
The Components of SNMP
Management Station
Management Framework
Management Application
Managed Node
Master Agent
Subagent
Oracle Enterprise Manager
Intelligent Agents
Management Information Base (MIB)
How SNMP Communications Are Performed
SNMP Support On Oracle
Configuring SNMP for Oracle
Configuring SNMP on Windows NT
Configuring SNMP on UNIX Platforms
Using only an SNMP Console
Configuring the SNMP Master Agent
Starting the SNMP Agents
Loading the Oracle MIBs
Configuring SNMP with Oracle Enterprise Manager and an SNMP Console

2 Oracle MIB Overview

Oracle Products Providing SNMP Support
Oracle Servers
Listener
Oracle Names
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

3 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

4 Reading the MIB Variable Descriptions

Variable name

A 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
oraDbSysWriteRequests
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
oraDbConfigDbBlockCkptBatch
oraDbConfigDbBlockSize
oraDbConfigDbFileSimWrites
oraDbConfigDbMultiBlockReadCount
oraDbConfigDistLockTimeout
oraDbConfigDistRecoveryConnectHold
oraDbConfigDistTransactions
oraDbConfigLogArchiveBufferSize
oraDbConfigLogArchiveBuffers
oraDbConfigLogBuffer
oraDbConfigLogCheckpointInterval
oraDbConfigLogCheckpointTimeout
oraDbConfigLogFiles
oraDbConfigMaxRollbackSegments
oraDbConfigMTSMaxDispatchers
oraDbConfigMTSMaxServers
oraDbConfigMTSServers
oraDbConfigOpenCursors
oraDbConfigOpenLinks
oraDbConfigOptimizerMode
oraDbConfigProcesses
oraDbConfigSerializable
oraDbConfigSessions
oraDbConfigSharedPool
oraDbConfigSortAreaSize
oraDbConfigSortAreaRetainedSize
oraDbConfigTransactions
oraDbConfigTransactionsPerRollback
oraRepTable
oraRepPending2PhaseCommits
oraRepDisabledTriggers
oraRepInvalidPackages
oraRepSchemas
oraRepSchemaTable
oraRepSchemaIndex
oraRepSchemaName
oraRepSchemaType
oraRepSchemaStatus
oraRepSchemaLinks
oraRepMasterSchema Table
oraRepMasterSchemaRequestErrors
oraRepMasterSchemaResolvedConflicts
oraRepMasterSchemaOtherMasters
oraRepSnapshotSchemaTable
oraRepSnapshotSchemaMaster
oraRepSnapshotSchemaSnapshots
oraRepLinkTable
oraRepLinkIndex
oraRepLinkName
oraRepLinkDeferredTransactions
oraRepLinkErrors
oraRepLinkAdminRequests

B 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

C Interpreting Variables of the Oracle Names MIB

oraNamesTNSTable
oraNamesTNSTraceLevel
oraNamesTNSParameterFile
oraNamesTNSLogFile
oraNamesTNSTraceFile
oraNamesTNSContact
oraNamesTNSReload
oraNamesTNSRunningTime
oraNamesConfigTable
oraNamesConfigAdminRegion
oraNamesConfigAuthorityRequired
oraNamesConfigAutoRefreshExpire
oraNamesConfigAutoRefreshRetry
oraNamesConfigCacheCheckpointFile
oraNamesConfigCacheCheckpointInterval
oraNamesConfigDefaultForwardersOnly
oraNamesConfigForwardingAvailable
oraNamesConfigForwardingDesired
oraNamesConfigLogStatsInterval
oraNamesConfigMaxReforwards
oraNamesConfigNoModifyRequests
oraNamesConfigResetStatsInterval
oraNamesConfigServerName
oraNamesServerTable
oraNamesServerQueriesReceived
oraNamesServerQueriesTotalTime
oraNamesServerCorruptMessagesReceived
oraNamesServerResponsesSent
oraNamesServerAliasLoopsDetected
oraNamesServerLookupsAttempted
oraNamesServerCreatedOnLookup
oraNamesServerLookupFailures
oraNamesServerExactMatches
oraNamesServerForwardFailures
oraNamesServerForwardTimeouts
oraNamesServerResponsesReceived
oraNamesServerRequestsForwarded
oraNamesServerReloadCheckFailures
oraNamesServerName
oraNamesServerAdminRegion

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
applAccumulatedInboundAssociations
applAccumulatedOutboundAssociations
applRejectedInboundAssociations
applFailedOutboundAssociations

F Interpreting Variables of the Enterprise Manager MIB

oraAgentEventTable
oraAgentEventIndex
oraAgentEventName
oraAgentEventID
oraAgentEventService
oraAgentEventTime
oraAgentEventSeverity
oraAgentEventUser
oraAgentEventAppID
oraAgentEventMessage
oraAgentEventArguments
oraAgentEventResults
oraAgentTraps
oraAgentEventOcc

Glossary

Index



Next
Oracle
Copyright © 1999 Oracle Corporation.

All Rights Reserved.

Library

Product

Index