Index

A B C D E F G I L M N O P R S T U V

A

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

B

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

C

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

D

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-46, A-48

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

DB_FILE_MULTIBLOCK_READ_COUNT in INIT.ORA, A-48

DBA_DATA_FILES, A-25

dedicated server

defined, B-14

designing management applications, 4-1

dispatcher

defined, B-16

E

Explanation element

meaning in appendices, 5-1

extensible agents, 1-7

F

FILE_ID in DBA_DATA_FILES, A-26

FILE_NAME in DBA_DATA_FILES, A-27

frameworks, 1-3

G

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

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

I

instrumentation, 1-9

intelligent agents, 1-8

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

L

library cache

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_BUFFER in INIT.ORA, A-48

LOG_CHECKPOINT_INTERVAL in INIT.ORA, A-49

LOG_DIRECTORY parameter, B-7

LOG_INTERVAL_TIMEOUT in INIT.ORA, A-49

LONG_TABLE_THRESHOLD in INIT.ORA, A-18

M

managed elements, 1-3, 1-7

managed nodes, 1-7

management applications, 1-6

tips for designing, 4-1

management consoles, 1-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

master agents, 1-3, 1-7

MAX_ROLLBACK_SEGMENTS in INIT.ORA, A-50

Max-Access element

meaning in appendices, 5-1

MIB objects, 1-8

MIB variables

scaling dynamically, 4-2

MIBs, 1-3

defined, 1-8

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_MAX_DISPATCHERS in INIT.ORA, A-51

MTS_MAX_SERVERS in INIT.ORA, A-51

MTS_SERVERS in INIT.ORA, A-52

N

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

NAMES.TRACE_LEVEL field, C-2

network listener, B-1

NEXT_EXTANT in DBA_TABLES, A-24

nodes

managed, 1-7

O

Object Identifiers, 1-9

OIDs, 1-9

OPEN_CURSORS in INIT.ORA, A-52

OPEN_LINKS in INIT.ORA, A-53

OPTIMIZER_MODE in INIT.ORA, A-54

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 Names

configuration parameters, C-6

operational status, C-17

Oracle Names MIB, C-1

oraDbConfigDbBlockBuffers variable, A-46

oraDbConfigDbBlockSize variable, A-47

oraDbConfigDbMultiBlockReadCount variable, A-47

oraDbConfigLogBuffer variable, A-48

oraDbConfigLogCheckpointInterval variable, A-49

oraDbConfigLogCheckpointTimeout variable, A-49

oraDbConfigMaxRollbackSegments variable, A-50

oraDbConfigMTSMaxDispatchers variable, A-50

oraDbConfigMTSMaxServers variable, A-51

oraDbConfigMTSServers variable, A-52

oraDbConfigOpenCursors variable, A-52

oraDbConfigOpenLinks variable, A-53

oraDbConfigOptimizerMode variable, A-53

oraDbConfigProcesses variable, A-54

oraDbConfigSerializable variable, A-55

oraDbConfigSessions variable, A-56

oraDbConfigSharedPool variable, A-56

oraDbConfigSortAreaRetainedSize variable, A-57

oraDbConfigSortAreaSize variable, A-57

oraDbConfigTable, A-45

oraDbConfigTransactions variable, A-58

oraDbConfigTranspactionsPerRollback variable, A-59

oraDbDataFileDiskReadBlocks variable, A-29

oraDbDataFileDiskReads variable, A-28

oraDbDataFileDiskReadTimeTicks variable, A-30

oraDbDataFileDiskWrites variable, A-28

oraDbDataFileDiskWriteTimeTicks variable, A-31

oraDbDataFileDiskWrittenBlocks variable, A-29

oraDbDataFileIndex variable, A-26

oraDbDataFileSizeAllocated variable, A-27

oraDbDatFileName variable, A-26

oraDbDatFileTable, A-25

oraDbLibraryCacheGetHits variable, A-34

oraDbLibraryCacheGets variable, A-34

oraDbLibraryCacheIndex variable, A-32

oraDbLibraryCacheInvalidations variable, A-37

oraDbLibraryCacheNameSpace variable, A-33

oraDbLibraryCachePinHits variable, A-35

oraDbLibraryCachePins variable, A-35

oraDbLibraryCacheReloads variable, A-36

oraDbLibraryCacheSumGetHits variable, A-39

oraDbLibraryCacheSumGets variable, A-38

oraDbLibraryCacheSumInvalidations variable, A-41

oraDbLibraryCacheSumPinHits variable, A-40

oraDbLibraryCacheSumPins variable, A-39

oraDbLibraryCacheSumReloads variable, A-41

oraDbLibraryCacheSumTable, A-38

oraDbLibraryCacheTable, A-32

oraDbSGADatabaseBuffers variable, A-44

oraDbSGAFixedSize variable, A-43

oraDbSGARedoBuffers variable, A-44

oraDbSGATable, A-42

oraDbSGAVariableSize variable, A-43

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

oraDbTablespaceName variable, A-22

oraDbTablespaceSizeAllocated variable, A-22

oraDbTablespaceSizeUsed variable, A-23

oraDbTablespaceState variable, A-23

oraDbTablespaceTable, A-20

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

oraRepLinkDeferredTransactions variable, A-69

oraRepLinkErrors variable, A-70

oraRepLinkIndex variable, A-68

oraRepLinkName variable, A-69

oraRepLinkTable, A-67

oraRepMasterSchemaOtherMasters, A-65

oraRepMasterSchemaRequestErrors variable, A-64

oraRepMasterSchemaResolvedConflicts variable, A-65

oraRepMasterSchemaTable, A-63

oraRepSchemaIndex variable, A-60

oraRepSchemaLinks, A-63

oraRepSchemaName variable, A-61

oraRepSchemaStatus variable, A-62

oraRepSchemaTable, A-59

oraRepSchemaType variable, A-61

oraRepSnapshotSchemaMaster variable, A-66

oraRepSnapshotSchemaSnapshots variable, A-67

oraRepSnapshotSchemaTable, A-66

oraRepTable, A-59

oraSIDcurrentlyConnectedClients variable, B-12

oraSIDListenerIndex variable, B-11

oraSIDName variable, B-12

oraSIDReservedConnections variable, B-13

oraSIDTable, B-10

P

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

PHYBLKRD in V$FILESTAT, A-29

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

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

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

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-48, A-54, A-56, A-58

protocols

between master and subagents, 1-7

implementing SNMP, 1-11

R

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-30, A-31

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-36, A-41

repositories, 1-4

row source ratio

defined, 4-5

S

SERIALIZABLE in INIT.ORA, A-55

SESSIONS in INIT.ORA, A-54, A-56

SGA

definition, A-42

shared pool

monitoring, A-32

SHARED_POOL_SIZE in INIT.ORA, A-56

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

SORT_AREA_SIZE in INIT.ORA, A-57

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

subagents, 1-3, 1-7

T

TABLE FETCH BY ROWID in V$SYSSTAT, A-14

TABLE FETCH CONTINUED ROW in V$SYSSTAT, A-15

TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT, A-15

TABLE SCAN ROWS GOTTEN in V$SYSSTAT, A-16

TABLE SCANS LONG TABLES in V$SYSSTAT, A-17

TABLE SCANS SHORT TABLES in V$SYSSTAT, A-17

TIMED_STATISTICS in INIT.ORA, A-30, A-31

TRACE_FILE parameter, B-8

transaction rate

defined, 4-5

TRANSACTIONS in INIT.ORA, A-58

TRANSACTIONS_PER_ROLLBACK_SEGMENT in INIT.ORA, A-59

traps, 1-3

tuning database server performance, 4-3

Typical Range element

meaning in appendices, 5-1

U

user call rate

defined, 4-5

USER CALLS in V$SYSSTAT, A-18

user calls per parse

defined, 4-6

USER COMMITS in V$SYSSTAT, A-19

user rollback ratio

defined, 4-6

USER ROLLBACKS in V$SYSSTAT, A-20

V

V$FILESTAT table, A-25

V$LIBRARYCACHE table, A-32

V$PARAMETER table, A-45

V$SGA table, A-42

V$SYSSTAT table, A-2

variables, A-32

reading descriptions of, 5-1

see MIB variables, 4-2