Oracle SNMP Support Reference Guide -- Index

ADDRESS section

of LISTENER.ORA file, B-28

Administrative Region, C-8

agents, 1-3

extensible, 1-7

intelligent, 1-8

master, 1-3, 1-7

monolithic, 1-7

sub-, 1-3, 1-7

applAccumulatedInboundAssociations variable, E-8

applAccumulatedOutboundAssociations variable, E-9

applFailedOutboundAssociations variable, E-10

applInboundAssociations variable, E-7

applIndex variable, E-3

applLastChange variable, E-7

applLastInboundActivity variable, E-9

applLastOutboundActivity variable, E-9

applName variable, E-4

applOperStatus variable, E-6

applOutboundAssociations variable, E-8

applRejectedInboundAssociations variable, E-9

applTable, E-1

applUptime variable, E-5

applVersion variable, E-5

block changes per transaction

defined, 4-3

block get rate

defined, 4-3

block visits per transaction

defined, 4-3

BYTES in DBA_DATA_FILES, A-28

cache hit ratio

defined, 4-3

call rate

defined, 4-4

calls per transaction

defined, 4-4

changed block ratio

defined, 4-4

configuring

SNMP with Enterprise Manager, 2-11

Configuring SNMP on UNIX Platforms, 2-9

Configuring SNMP on Windows NT, 2-1

connectionless communication, 1-10

consistent change ratio

defined, 4-4

CONSISTENT CHANGES in V$SYSSTAT, A-4

CONSISTENT GETS in V$SYSSTAT, A-4

continued row ratio

defined, 4-4

database instance performance ratios, 4-3, 4-4

block changes per transaction, 4-3

block get rate, 4-3

cache hit ratio, 4-3

call rate, 4-4

calls per transaction, 4-4

changed block ratio, 4-4

continue row ratio, 4-4

library cache miss ratio, 4-4

most useful, 4-3

presenting graphically, 4-2

recursive to user call ratio, 4-5

redo log space wait ratio, 4-5

row source ratio, 4-5

scaling dynamically, 4-2

sort overflow ratio, 4-5

transaction rate, 4-5

user call rate, 4-5

user calls per parse, 4-6

user rollback ratio, 4-6

using a sufficient sample for, 4-1

DB BLOCK CHANGES in V$SYSSTAT, A-5

DB BLOCK GETS in V$SYSSTAT, A-6

DB_BLOCK_BUFFERS in INIT.ORA, A-47, A-50

DB_BLOCK_CHECKPOINT_BATCH in INIT.ORA, A-48

DB_BLOCK_SIZE in INIT.ORA, A-30, A-49

DB_FILE_MULTIBLOCK_READ_COUNT in INIT.ORA, A-50

DB_FILE_SIMULTANEOUS_WRITES in INIT.ORA, A-49

DBA_DATA_FILES, A-26

defined, 1

DBA_FREE_SPACE

defined, 1

dedicated server

defined, B-14

designing management applications, 4-1

dispatcher

defined, B-16

DISTRIBUTED_LOCK_TIMEOUT in INIT.ORA, A-50

DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME in INIT.ORA, A-51

DISTRIBUTED_TRANSACTIONS in INIT.ORA, A-52

Explanation element

meaning in appendices, 5-1

extensible agents, 1-7

FILE_ID in DBA_DATA_FILES, A-26

FILE_NAME in DBA_DATA_FILES, A-27

frameworks, 1-3

GETHITS in V$LIBRARYCACHE, A-35, A-39

GETS in V$LIBRARYCACHE, A-34, A-39

INIT.ORA configuration file

defined, 2

MTS_LISTENER_ADDRESS parameter, B-21

instance

defined, 2

instrumentation, 1-9

intelligent agents, 1-8

INVALIDATIONS in V$LIBRARYCACHE, A-38, A-42

library

defined, 2

library cache

defined, 2

MIB table for, A-32

library cache miss ratio

defined, 4-4

Listener

MIB, B-1

listener

definition, B-1

LISTENER.ORA configuration file, B-3

ADDRESS section, B-28

LOG_DIRECTORY parameter, B-7

PASSWORDS_listener_name parameter, B-6

SID_NAME parameter, B-12

TRACE_FILE parameter, B-8

LOG_ARCHIVE_BUFFER_SIZE in INIT.ORA, A-52

LOG_ARCHIVE_BUFFERS in INIT.ORA, A-53

LOG_BUFFER in INIT.ORA, A-53

LOG_CHECKPOINT_INTERVAL in INIT.ORA, A-54

LOG_DIRECTORY parameter, B-7

LOG_FILES in INIT.ORA, A-55

LOG_INTERVAL_TIMEOUT in INIT.ORA, A-55

LONG_TABLE_THRESHOLD in INIT.ORA, A-18

managed elements, 1-3, 1-7

managed nodes, 1-7

management application

defined, 3

management applications, 1-6

tips for designing, 4-1

management consoles, 1-3

management framework

defined, 3

management frameworks, 1-3

Management Information Bases, 1-3

management stations, 1-3

management systems, 1-3

managing nodes, 1-3

mapping the network, 1-6

master agent

configuring, 1

defined, 3

master agents, 1-3, 1-7

MAX_ROLLBACK_SEGMENTS in INIT.ORA, A-56

Max-Access element

meaning in appendices, 5-1

MIB objects, 1-8

MIB variables

scaling dynamically, 4-2

MIBs, 1-3

defined, 1-8, 3

Listener MIB, B-1

Oracle Database MIB, A-1

Oracle Names MIB, C-1

private, 1-9

public Network Services MIB, E-1

public RDBMS MIB, D-1

reading variable descriptions, 5-1

standard hierarchy, 1-9

structure of, 1-9

variables, 1-9

monolithic agents, 1-7

MTS_LISTENER_ADDRESS parameter, B-21

MTS_MAX_DISPATCHERS in INIT.ORA, A-56

MTS_MAX_SERVERS in INIT.ORA, A-57

MTS_SERVERS in INIT.ORA, A-58

NAME in V$TABLESPACE, A-22

Names MIB

see Oracle Names MIB, C-1

NAMES.ORA configuration file, C-1, C-7

NAMESPACE in V$LIBRARYCACHE, A-34

NAMES.TRACE_LEVEL field, C-2

network listener, B-1

NEXT_EXTANT in DBA_TABLES, A-25

nodes

managed, 1-7

Object Identifiers, 1-9

OID

defined, 4

OID subtree

defined, 4

OIDs, 1-9

OPEN_CURSORS in INIT.ORA, A-58

OPEN_LINKS in INIT.ORA, A-59

OPTIMIZER_MODE in INIT.ORA, A-59

oraAgentEventArguments, F-7

oraAgentEventID, F-3

oraAgentEventIndex, F-2

oraAgentEventMessage, F-7

oraAgentEventName, F-2

oraAgentEventOcc, F-9

oraAgentEventResults, F-8

oraAgentEventService, F-4

oraAgentEventSeverity, F-5

oraAgentEventTable, F-1

oraAgentEventTime, F-4

Oracle

MIB

Listener, B-1

Oracle Database MIB, A-1

Oracle Enterprise Manager, 1-8

relationship with SNMP, 1-8

Oracle Multiprotocol Interchange

defined, 4

Oracle Names

configuration parameters, C-6

defined, 4

operational status, C-17

Oracle Names MIB, C-1

Oracle7 Server

defined, 4

oraDbConfigDbArchiveLogBuffers variable, A-53

oraDbConfigDbBlockBuffers variable, A-47

oraDbConfigDbBlockCkptBatch variable, A-48

oraDbConfigDbBlockSize variable, A-48

oraDbConfigDbFilesSimWrites variable, A-49

oraDbConfigDbMultiBlockReadCount variable, A-50

oraDbConfigDiskLockTimeout variable, A-50

oraDbConfigDistRecoveryConnectHold variable, A-51

oraDbConfigDistTransactions variable, A-51

oraDbConfigLogArchiveBufferSize variable, A-52

oraDbConfigLogBuffer variable, A-53

oraDbConfigLogCheckpointInterval variable, A-54

oraDbConfigLogCheckpointTimeout variable, A-54

oraDbConfigLogFiles variable, A-55

oraDbConfigMaxRollbackSegments variable, A-56

oraDbConfigMTSMaxDispatchers variable, A-56

oraDbConfigMTSMaxServers variable, A-57

oraDbConfigMTSServers variable, A-57

oraDbConfigOpenCursors variable, A-58

oraDbConfigOpenLinks variable, A-59

oraDbConfigOptimizerMode variable, A-59

oraDbConfigProcesses variable, A-60

oraDbConfigSerializable variable, A-61

oraDbConfigSessions variable, A-61

oraDbConfigSharedPool variable, A-62

oraDbConfigSortAreaRetainedSize variable, A-63

oraDbConfigSortAreaSize variable, A-63

oraDbConfigTable, A-45

oraDbConfigTransactions variable, A-64

oraDbConfigTranspactionsPerRollback variable, A-64

oraDbDataFileDiskReadBlocks variable, A-29

oraDbDataFileDiskReads variable, A-28

oraDbDataFileDiskReadTimeTicks variable, A-31

oraDbDataFileDiskWrites variable, A-29

oraDbDataFileDiskWriteTimeTicks variable, A-31

oraDbDataFileDiskWrittenBlocks variable, A-30

oraDbDataFileIndex variable, A-26

oraDbDataFileSizeAllocated variable, A-28

oraDbDatFileName variable, A-27

oraDbDatFileTable, A-25

oraDbLibraryCacheGetHits variable, A-35

oraDbLibraryCacheGets variable, A-34

oraDbLibraryCacheIndex variable, A-33

oraDbLibraryCacheInvalidations variable, A-37

oraDbLibraryCacheNameSpace variable, A-34

oraDbLibraryCachePinHits variable, A-36

oraDbLibraryCachePins variable, A-35

oraDbLibraryCacheReloads variable, A-37

oraDbLibraryCacheSumGetHits variable, A-39

oraDbLibraryCacheSumGets variable, A-38

oraDbLibraryCacheSumInvalidations variable, A-42

oraDbLibraryCacheSumPinHits variable, A-40

oraDbLibraryCacheSumPins variable, A-40

oraDbLibraryCacheSumReloads variable, A-41

oraDbLibraryCacheSumTable, A-38

oraDbLibraryCacheTable, A-32

oraDbSGADatabaseBuffers variable, A-44

oraDbSGAFixedSize variable, A-43

oraDbSGARedoBuffers variable, A-45

oraDbSGATable, A-42

oraDbSGAVariableSize variable, A-44

oraDbSysConsistentChanges variable, A-3

oraDbSysContact variable, A-4

oraDbSysDbBlockChanges variable, A-5

oraDbSysDbBlockGets variable, A-6

oraDbSysFreeBufferInspected variable, A-6

oraDbSysFreeBufferRequested variable, A-7

oraDbSysParseCount variable, A-8

oraDbSysPhysReads variable, A-8

oraDbSysPhysWrites variable, A-9

oraDbSysRedoEntries variable, A-10

oraDbSysRedoLogSpaceRequests variable, A-10

oraDbSysRedoSyncWrites variable, A-11

oraDbSysSortsDisk variable, A-12

oraDbSysSortsMemory variable, A-12

oraDbSysSortsRows variable, A-13

oraDbSysTable, A-2

oraDbSysTableFetchContinuedRow variable, A-15

oraDbSysTableFetchRowid variable, A-14

oraDbSysTableScanBlocks variable, A-15

oraDbSysTableScanRows variable, A-16

oraDbSysTableScansLong variable, A-17

oraDbSysTableScansShort variable, A-17

oraDbSysUserCalls variable, A-18

oraDbSysUserCommits variable, A-19

oraDbSysUserRollbacks variable, A-19

oraDbSyysWriteRequests variable, A-20

oraDbTablespaceIndex variable, A-21

oraDbTablespaceLargestAvailableChunk variable, A-25

oraDbTablespaceName variable, A-22

oraDbTablespaceSizeAllocated variable, A-23

oraDbTablespaceSizeUsed variable, A-23

oraDbTablespaceState variable, A-24

oraDbTablespaceTable, A-21

oraDedicatedSrvEstablishedConnections variable, B-15

oraDedicatedSrvIndex variable, B-14

oraDedicatedSrvRejectedConnections variable, B-16

oraDedicatedSrvTable, B-14

oraDispatcherCurrentConnections variable, B-19

oraDispatcherEstablishedConnections variable, B-18

oraDispatcherIndex variable, B-17

oraDispatcherMaximumConnections variable, B-19

oraDispatcherProtocolInfo variable, B-21

oraDispatcherRejectedConnections variable, B-18

oraDispatcherState variable, B-20

oraDispatcherTable, B-16

orAgentTraps, F-9

oraListenAddress variable, B-28

oraListenAddressIndex variable, B-27

oraListenAddressTable, B-27

oraListenerContact variable, B-10

oraListenerIndex variable, B-2

oraListenerLogFile, B-7

oraListenerName variable, B-3

oraListenerNumberOfServices variable, B-9

oraListenerParameterFile variable, B-7

oraListenerSecurityLevel variable, B-6

oraListenerState variable, B-4, B-8

oraListenerStateChange variable, B-29

oraListenerTable, B-1

oraListenerTraceFile, B-8

oraListenerTraceLevel variable, B-5

oraListenerTraps, B-29

oraListenerUptime variable, B-5

oraListenerVersion variable, B-4

oraNamesConfigAdminRegion variable, C-8

oraNamesConfigAuthorityRequired variable, C-9

oraNamesConfigAutoRefreshExpire variable, C-9

oraNamesConfigAutoRefreshRetry variable, C-10

oraNamesConfigCacheCheckpointFile variable, C-11

oraNamesConfigCacheCheckpointInterval variable, C-11

oraNamesConfigDefaultForwardersOnly variable, C-12

oraNamesConfigForwardingAvailable variable, C-13

oraNamesConfigForwardingDesired variable, C-14

oraNamesConfigLogStatsInterval variable, C-14

oraNamesConfigMaxReforwards variable, C-15

oraNamesConfigNoModifyRequests variable, C-15

oraNamesConfigResetStatsInterval variable, C-16

oraNamesConfigServerName variable, C-17

oraNamesConfigTable, C-6

oraNamesServerAdminRegion variable, C-28

oraNamesServerAliasLoopsDetected variable, C-22

oraNamesServerCorruptMessagesReceived variable, C-20

oraNamesServerCreatedOnLookup variable, C-23

oraNamesServerExactMatches variable, C-24

oraNamesServerForwardFailures variable, C-25

oraNamesServerForwardTimeouts variable, C-25

oraNamesServerLookupFailures variable, C-23

oraNamesServerLookupsAttempted variable, C-22

oraNamesServerName variable, C-28

oraNamesServerQueriesReceived variable, C-19

oraNamesServerQueriesTotalTime variable, C-20

oraNamesServerReloadCheckFailures variable, C-27

oraNamesServerRequestsForwarded variable, C-26

oraNamesServerResponsesReceived variable, C-26

oraNamesServerResponsesSent variable, C-21

oraNamesServerTable, C-17

oraNamesTnsContact variable, C-5

oraNamesTnsLogFile variable, C-3

oraNamesTnsParameter variable, C-3

oraNamesTnsReload variable, C-5

oraNamesTnsRunningTime variable, C-6

oraNamesTnsTable, C-1

oraNamesTnsTraceFile variable, C-4

oraNamesTnsTraceLevel variable, C-2

oraPrespawnedSrvCurrentConnections variable, B-24

oraPrespawnedSrvEstablishedConnections variable, B-23

oraPrespawnedSrvIndex variable, B-22

oraPrespawnedSrvMaximumConnections variable, B-25

oraPrespawnedSrvProcessorID variable, B-26

oraPrespawnedSrvProtocolInfo variable, B-26

oraPrespawnedSrvRejectedConnections variable, B-23

oraPrespawnedSrvState variable, B-25

oraPrespawnedSrvTable, B-21

oraRepLinkAdminRequests variable, A-77

oraRepLinkDeferredTransactions variable, A-75

oraRepLinkErrors variable, A-76

oraRepLinkIndex variable, A-74

oraRepLinkName variable, A-75

oraRepLinkTable, A-73

oraRepMasterSchemaOtherMasters, A-71

oraRepMasterSchemaRequestErrors variable, A-70

oraRepMasterSchemaResolvedConflicts variable, A-70

oraRepMasterSchemaTable, A-69

oraRepSchemaIndex variable, A-66

oraRepSchemaLinks, A-68

oraRepSchemaName variable, A-66

oraRepSchemaStatus variable, A-67

oraRepSchemaTable, A-65

oraRepSchemaType variable, A-67

oraRepSnapshotSchemaMaster variable, A-72

oraRepSnapshotSchemaSnapshots variable, A-73

oraRepSnapshotSchemaTable, A-71

oraRepTable, A-65

oraSIDcurrentlyConnectedClients variable, B-12

oraSIDListenerIndex variable, B-11

oraSIDName variable, B-12

oraSIDReservedConnections variable, B-13

oraSIDTable, B-10

packets

recovering lost, 1-10

PARSE COUNT in V$SYSSTAT, A-8

PASSWORDS_listener_name parameter, B-6

performance ratios

see database instance performance ratios, 4-1

PGA memory, A-63

PHYBLKRD in V$FILESTAT, A-30

PHYBLKWRT in V$FILESTAT, A-30

PHYRDS in V$FILESTAT, A-28

PHYSICAL READS in V$SYSSTAT, A-8

PHYSICAL WRITES in V$SYSSTAT, A-9

PHYWRTS in V$FILESTAT, A-29

defined, 4

PINHITS in V$LIBRARYCACHE, A-36, A-41

PINS in V$LIBRARYCACHE, A-36, A-40

platforms

management, 1-3

polls, 1-3

prespawned server

defined, B-21

private MIB

Listener, B-1

Oracle Database MIB, A-1

Oracle Names MIB, C-1

PROCESSES in INIT.ORA, A-50, A-60, A-62, A-64

protocols

between master and subagents, 1-7

implementing SNMP, 1-11

ratios

see database instance performance ratios, 4-1

rdbmsDbContact variable, D-5

rdbmsDbIndex variable, D-2

rdbmsDbInfoProductName variable, D-6

rdbmsDbInfoSizeAllocated variable, D-8

rdbmsDbInfoSizeUnits variable, D-7

rdbmsDbInfoSizeUsed variable, D-9

rdbmsDbInfoTable, D-5

rdbmsDbInfoVersion variable, D-7

rdbmsDbName variable, D-4

rdbmsDbPrivateMibOID variable, D-3

rdbmsDbTable, D-2

rdbmsDbVendorName variable, D-3

rdbmsRelState variable, D-25

rdbmsRelTable, D-24

rdbmsSrvContact variable, D-12

rdbmsSrvInfoDiskReads variable, D-15

rdbmsSrvInfoDiskWrites variable, D-16

rdbmsSrvInfoFinishedTransactions variable, D-14

rdbmsSrvInfoHighwaterInboundAssociations variable, D-20

rdbmsSrvInfoLogicalReads variable, D-16

rdbmsSrvInfoMaxInboundAssociations variable, D-20

rdbmsSrvInfoPageReads variable, D-18

rdbmsSrvInfoPageWrites variable, D-18

rdbmsSrvInfoRequestsHandled variable, D-19

rdbmsSrvInfoStartupTime variable, D-14

rdbmsSrvInfoTable, D-13

rdbmsSrvParamCurrValue variable, D-23

rdbmsSrvParamName variable, D-22

rdbmsSrvParamSubIndex variable, D-23

rdbmsSrvParamTable, D-21

rdbmsSrvPrivateMibOID variable, D-10

rdbmsSrvProductName variable, D-11

rdbmsSrvTable, D-9

rdbmsSrvVendorName variable, D-11

rdbmsStateChange trap, D-26

rdbmsTraps, D-25

READTIM in V$FILESTAT, A-31, A-32

recursive to user call ratio

defined, 4-5

REDO ENTRIES in V$SYSSTAT, A-10

REDO LOG SPACE REQUESTS in V$SYSSTAT, A-11

redo log space wait ratio

defined, 4-5

REDO SYNC WRITES in V$SYSSTAT, A-11

Related Variables element

meaning in appendices, 5-2

RELOADS in V$LIBRARYCACHE, A-37, A-41

repositories, 1-4

row source ratio

defined, 4-5

SERIALIZABLE in INIT.ORA, A-61

server

defined, 5

SESSIONS in INIT.ORA, A-60, A-61

SGA

defined, 5

definition, A-42

Shared Global Area

defined, 5

shared pool

defined, 5

monitoring, A-32

SHARED_POOL_SIZE in INIT.ORA, A-62

SID_NAME parameter, B-12

Significance element

meaning in appendices, 5-2

SMALL_TABLE_THRESHOLD in INIT.ORA, A-17

SNMP

defined, 1-3

Oracle products supporting, 1-11

SNMP traps

about, F-1

snmp.contact.listener_name, B-10

snmp.index.listener-name parameter, B-11

snmp.index.listenername parameter, B-2

SNMP.ORA, 5

SNMP.ORA configuration file

LISTENER_CONTACT parameter, B-10

snmp.index.listener-name parameter, B-2, B-11

sort overflow ratio

defined, 4-5

SORT_AREA_RETAINED_SIZE in INIT.ORA, A-63

SORT_AREA_SIZE in INIT.ORA, A-63

SORTS DISKS in V$SYSSTAT, A-12

SORTS MEMORY in V$SYSSTAT, A-13

SORTS ROWS in V$SYSSTAT, A-13

SQL*Net, C-1

STATUS element

of SNMP MIB definition, Version 2, 5-1

Status element

meaning in appendices, 5-1

STATUS in V$TABLESPACE, A-24

subagent

defined, 5

subagents, 1-3, 1-7