Index

block get rate

block visits per transaction

BYTES in DBA_DATA_FILES, A-28

cache hit ratio

call rate

calls per transaction

changed block ratio

SNMP with Enterprise Manager, 1-14

configuring

Configuring SNMP on UNIX Platforms, 1-12

Configuring SNMP on Windows NT, 1-10

connectionless communication, 1-9

consistent change ratio

CONSISTENT CHANGES in V$SYSSTAT, A-4

CONSISTENT GETS in V$SYSSTAT, A-4

continued row ratio

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

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_FREE_SPACE

dedicated server

designing management applications, 3-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, 4-1

extensible agents, 1-6

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

MTS_LISTENER_ADDRESS parameter, B-20

instance

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

instrumentation, 1-8

intelligent agents, 1-7

library

library cache

MIB table for, A-32

library cache miss ratio

LISTENER.ORA configuration file, B-3

Listener

MIB, B-1

listener

definition, B-1

ADDRESS section, B-28

LOG_DIRECTORY parameter, B-7

PASSWORDS_listener_name parameter, B-6

SID_NAME parameter, B-11

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-6

managed nodes, 1-6

management application

defined, 3

management applications, 1-5

tips for designing, 3-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-5

master agent

configuring, 1

defined, 3

master agents, 1-3, 1-6

MAX_ROLLBACK_SEGMENTS in INIT.ORA, A-56

Max-Access element

meaning in appendices, 4-1

MIB objects, 1-8

MIB variables

scaling dynamically, 3-2

MIBs, 1-3

defined, 1-8, 3

Listener MIB, B-1

Oracle Database MIB, A-1

Oracle Names MIB, C-1

private, 1-8

public Network Services MIB, E-1

public RDBMS MIB, D-1

reading variable descriptions, 4-1

standard hierarchy, 1-8

structure of, 1-8

variables, 1-8

monolithic agents, 1-6

MTS_LISTENER_ADDRESS parameter, B-20

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-6

Object Identifiers, 1-8

OID

OID subtree

OPEN_CURSORS in INIT.ORA, A-58

OIDs, 1-8

OPEN_LINKS in INIT.ORA, A-59

operating systems

SNMP support and, 1-10

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-7

relationship with SNMP, 1-7

Oracle Multiprotocol Interchange

configuration parameters, C-6

Oracle Names

operational status, C-17

Oracle Names MIB, C-1

Oracle7 Server

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-15

oraDedicatedSrvTable, B-13

oraDispatcherCurrentConnections variable, B-18

oraDispatcherEstablishedConnections variable, B-17

oraDispatcherIndex variable, B-17

oraDispatcherMaximumConnections variable, B-19

oraDispatcherProtocolInfo variable, B-20

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-9

oraListenerIndex variable, B-2

oraListenerLogFile, B-7

oraListenerName variable, B-3

oraListenerNumberOfServices variable, B-9

oraListenerParameterFile variable, B-6

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-28

oraListenerUptime variable, B-5

oraListenerVersion variable, B-3

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-24

oraPrespawnedSrvProcessorID variable, B-26

oraPrespawnedSrvProtocolInfo variable, B-26

oraPrespawnedSrvRejectedConnections variable, B-23

oraPrespawnedSrvState variable, B-25

oraPrespawnedSrvTable, B-21

oraRepDisabledTriggers variable, A-66

oraRepInvalidPackages variable, A-67

oraRepLinkAdminRequests variable, A-79

oraRepLinkDeferredTransactions variable, A-78

oraRepLinkErrors variable, A-78

oraRepLinkIndex variable, A-76

oraRepLinkName variable, A-77

oraRepLinkTable, A-76

oraRepMasterSchemaOtherMasters, A-74

oraRepMasterSchemaRequestErrors variable, A-72

oraRepMasterSchemaResolvedConflicts variable, A-73

oraRepMasterSchemaTable, A-72

oraRepPending2PhaseCommits variable, A-65

oraRepSchemaIndex variable, A-68

oraRepSchemaLinks, A-71

oraRepSchemaName variable, A-69

oraRepSchemas variable, A-67

oraRepSchemaStatus variable, A-70

oraRepSchemaTable, A-68

oraRepSchemaType variable, A-70

oraRepSnapshotSchemaMaster variable, A-75

oraRepSnapshotSchemaSnapshots variable, A-75

oraRepSnapshotSchemaTable, A-74

oraRepTable, A-65

oraSIDcurrentlyConnectedClients variable, B-12

oraSIDListenerIndex variable, B-11

oraSIDName variable, B-11

oraSIDReservedConnections variable, B-13

oraSIDTable, B-10

packets

recovering lost, 1-9

PARSE COUNT in V$SYSSTAT, A-8

PASSWORDS_listener_name parameter, B-6

performance ratios

see database instance performance ratios, 3-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

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-6

implementing SNMP, 1-10

ratios

see database instance performance ratios, 3-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, 3-5

REDO ENTRIES in V$SYSSTAT, A-10

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

redo log space wait ratio

defined, 3-5

REDO SYNC WRITES in V$SYSSTAT, A-11

Related Variables element

meaning in appendices, 4-2

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

row source ratio

schemas

SERIALIZABLE in INIT.ORA, A-61

server

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

Server Manager, 1-2

SGA

definition, A-42

Shared Global Area

shared pool

SHARED_POOL_SIZE in INIT.ORA, A-62

monitoring, A-32

SID_NAME parameter, B-11

Significance element

meaning in appendices, 4-2

SMALL_TABLE_THRESHOLD in INIT.ORA, A-17

SNMP

defined, 1-3

operating system support of, 1-10

Oracle products supporting, 1-10

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, 3-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, 4-1

Status element

meaning in appendices, 4-1

STATUS in V$TABLESPACE, A-24

subagent