Index

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

A

Accessibility, Preface

ADDRESS section

of LISTENER.ORA file, C.43

Administrators, 1.1

AppleTalk, 1.4

applInboundAssociations variable, E.8

applIndex variable, E.2

applLastChange variable, E.7

applName variable, E.3

applOperStatus variable, E.6

applTable, E.1

applUptime variable, E.5

applVersion variable, E.4

B

Batch File, 2.1.4.3

Block Get Rate, 5.6

Block Visits Per Transaction, 5.6

BYTES in DBA_DATA_FILES, B.36

C

Cache Hit Ratio, 5.6

Call Rate, 5.6

Calls Per Transaction, 5.6

Changed Block Ratio, 5.6

CONFIG.encap, 2.2.2

CONFIG.Master, 2.2.2

configuration procedures, 2.1

Configuring SNMP, 2.1, 2.1

Consistent Change Ratio, 5.6

CONSISTENT CHANGES in V$SYSSTAT, B.2

CONSISTENT GETS in V$SYSSTAT, B.3

Continued Row Ratio, 5.6

D

database instance performance ratios

most useful, 5.6

presenting graphically, 5.3

scaling dynamically, 5.4

DB BLOCK CHANGES in V$SYSSTAT, B.4

DB BLOCK GETS in V$SYSSTAT, B.5

DB_BLOCK_BUFFERS in INIT.ORA, B.65, B.67

DB_BLOCK_SIZE in INIT.ORA, B.40, B.66

DB_FILE_MULTIBLOCK_READ_COUNT in INIT.ORA, B.67

DBA_DATA_FILES, B.33

dbsnmp.noheuristic, A.2

dbsnmp.polltime, A.2

dedicated server

defined, C.20

designing management applications, 5

dispatcher

defined, C.24

DML, 5.6

E

emctl, 2.3.1

Enterprise Manager, 1.5.2

Enterprise Manager SNMP Subagent, 1.5.2

Explanation element

meaning in appendices, 4.1

F

Fetchlets, 1.5.1.1

FILE_ID in DBA_DATA_FILES, B.34

FILE_NAME in DBA_DATA_FILES, B.35

G

GETHITS in V$LIBRARYCACHE, B.47, B.54

GETS in V$LIBRARYCACHE, B.46, B.53

GUI SNMP Query/Set Utility, 2.1.5

I

instrumentation, 1.6

Internet Engineering Task Force, 1.6

Internet Protocol, 1.4

Internetwork Packet Exchange, 1.4

Interpreting SNMP OIDs, 3.3

INVALIDATIONS in V$LIBRARYCACHE, B.51, B.58

L

library cache

MIB table for, B.43

Library Cache Miss Ratio, 5.6

Listener, 3.1.2

MIB, C

listener

definition, C.1

LISTENER.ORA configuration file, C.3

ADDRESS section, C.43

LOG_DIRECTORY parameter, C.10

PASSWORDS_listener_name parameter, C.8

SID_NAME parameter, C.17

TRACE_FILE parameter, C.11

LMHOSTS.SAM files, 2.1.3.2

LOG_BUFFER in INIT.ORA, B.68

LOG_CHECKPOINT_INTERVAL in INIT.ORA, B.69

LOG_DIRECTORY parameter, C.10

LOG_INTERVAL_TIMEOUT in INIT.ORA, B.70

LONG_TABLE_THRESHOLD in INIT.ORA, B.22

M

managed elements, 1.2

Managed Node, 1.3.4

Management Application, 1.3.3

management applications

tips for designing, 5

Management Framework, 1.3.2

management framework, 1.2

Management Information Base, 1.2

management platform, 1.2

Master Agent, 1.3.5

MASTER.CFG file, 2.1.3.3, 2.1.3.3, 2.1.3.3

Max-Access element

meaning in appendices, 4.1

MIB variables

scaling dynamically, 5.4

MIBs

Listener MIB, C

Oracle Database MIB, B

public Network Services MIB, E

public RDBMS MIB, D

Microsoft SNMP Service, 2.1.3.2

Microsoft Windows Platforms, 2.1

N

NAME in V$TABLESPACE, B.28

NAMESPACE in V$LIBRARYCACHE, B.45

network listener, C.1

NEXT_EXTANT in DBA_TABLES, B.32

Notification, 1.5.1

Notification Methods, 2.3.2, 2.3.2

Notification Rules, 2.3.2

Notifications, 2.3.2

O

object identifier, 3.3.1

OID, 1.6

OPEN_CURSORS in INIT.ORA, B.71

OPEN_LINKS in INIT.ORA, B.72

OPTIMIZER_MODE in INIT.ORA, B.73

Oracle, Preface

MIB

Listener, C

Oracle Database MIB, B

Oracle Management Agent, 2.1.3

Oracle SNMP Peer Encapsulator, Glossary

Oracle SNMP Peer Master Agent, Glossary

oraDbConfigDbBlockBuffers variable, B.65

oraDbConfigDbBlockSize variable, B.66

oraDbConfigDbMultiBlockReadCount variable, B.67

oraDbConfigLogBuffer variable, B.68

oraDbConfigLogCheckpointInterval variable, B.69

oraDbConfigLogCheckpointTimeout variable, B.70

oraDbConfigOpenCursors variable, B.71

oraDbConfigOpenLinks variable, B.72

oraDbConfigOptimizerMode variable, B.73

oraDbConfigProcesses variable, B.74

oraDbConfigSessions variable, B.75

oraDbConfigSharedPool variable, B.76

oraDbConfigSortAreaRetainedSize variable, B.78

oraDbConfigSortAreaSize variable, B.77

oraDbConfigTable, B.64

oraDbConfigTransactions variable, B.79

oraDbConfigTranspactionsPerRollback variable, B.80

oraDbDataFileDiskReadBlocks variable, B.39

oraDbDataFileDiskReads variable, B.37

oraDbDataFileDiskReadTimeTicks variable, B.41

oraDbDataFileDiskWrites variable, B.38

oraDbDataFileDiskWriteTimeTicks variable, B.42

oraDbDataFileDiskWrittenBlocks variable, B.40

oraDbDataFileIndex variable, B.34

oraDbDataFileSizeAllocated variable, B.36

oraDbDatFileName variable, B.35

oraDbDatFileTable, B.33

oraDbLibraryCacheGetHits variable, B.47

oraDbLibraryCacheGets variable, B.46

oraDbLibraryCacheIndex variable, B.44

oraDbLibraryCacheInvalidations variable, B.51

oraDbLibraryCacheNameSpace variable, B.45

oraDbLibraryCachePinHits variable, B.49

oraDbLibraryCachePins variable, B.48

oraDbLibraryCacheReloads variable, B.50

oraDbLibraryCacheSumGetHits variable, B.54

oraDbLibraryCacheSumGets variable, B.53

oraDbLibraryCacheSumInvalidations variable, B.58

oraDbLibraryCacheSumPinHits variable, B.56

oraDbLibraryCacheSumPins variable, B.55

oraDbLibraryCacheSumReloads variable, B.57

oraDbLibraryCacheSumTable, B.52

oraDbLibraryCacheTable, B.43

oraDbSGADatabaseBuffers variable, B.62

oraDbSGAFixedSize variable, B.60

oraDbSGARedoBuffers variable, B.63

oraDbSGATable, B.59

oraDbSGAVariableSize variable, B.61

oraDbSysConsistentChanges variable, B.2

oraDbSysContact variable, B.3

oraDbSysDbBlockChanges variable, B.4

oraDbSysDbBlockGets variable, B.5

oraDbSysFreeBufferInspected variable, B.6

oraDbSysFreeBufferRequested variable, B.7

oraDbSysParseCount variable, B.8

oraDbSysPhysReads variable, B.9

oraDbSysPhysWrites variable, B.10

oraDbSysRedoEntries variable, B.11

oraDbSysRedoLogSpaceRequests variable, B.12

oraDbSysRedoSyncWrites variable, B.13

oraDbSysSortsDisk variable, B.14

oraDbSysSortsMemory variable, B.15

oraDbSysSortsRows variable, B.16

oraDbSysTable, B.1

oraDbSysTableFetchContinuedRow variable, B.18

oraDbSysTableFetchRowid variable, B.17

oraDbSysTableScanBlocks variable, B.19

oraDbSysTableScanRows variable, B.20

oraDbSysTableScansLong variable, B.21

oraDbSysTableScansShort variable, B.22

oraDbSysUserCalls variable, B.23

oraDbSysUserCommits variable, B.24

oraDbSysUserRollbacks variable, B.25

oraDbSyysWriteRequests variable, B.26

oraDbTablespaceIndex variable, B.27

oraDbTablespaceLargestAvailableChunk variable, B.32

oraDbTablespaceName variable, B.28

oraDbTablespaceSizeAllocated variable, B.29

oraDbTablespaceSizeUsed variable, B.30

oraDbTablespaceState variable, B.31

oraDbTablespaceTable, B.26

oraDedicatedSrvEstablishedConnections variable, C.22

oraDedicatedSrvIndex variable, C.21

oraDedicatedSrvRejectedConnections variable, C.23

oraDedicatedSrvTable, C.20

oraDispatcherCurrentConnections variable, C.28

oraDispatcherEstablishedConnections variable, C.26

oraDispatcherIndex variable, C.25

oraDispatcherMaximumConnections variable, C.29

oraDispatcherProtocolInfo variable, C.31

oraDispatcherRejectedConnections variable, C.27

oraDispatcherState variable, C.30

oraDispatcherTable, C.24

orAgentTraps, F.1

oraListenAddress variable, C.43

oraListenAddressIndex variable, C.42

oraListenAddressTable, C.41

oraListenerContact variable, C.14

oraListenerIndex variable, C.2

oraListenerLogFile, C.10

oraListenerName variable, C.3

oraListenerNumberOfServices variable, C.13

oraListenerParameterFile variable, C.9

oraListenerSecurityLevel variable, C.8

oraListenerState variable, C.5, C.12

oraListenerStateChange variable, C.45

oraListenerTable, C.1

oraListenerTraceFile, C.11

oraListenerTraceLevel variable, C.7

oraListenerTraps, C.44

oraListenerUptime variable, C.6

oraListenerVersion variable, C.4

oraPrespawnedSrvCurrentConnections variable, C.36

oraPrespawnedSrvEstablishedConnections variable, C.34

oraPrespawnedSrvIndex variable, C.33

oraPrespawnedSrvMaximumConnections variable, C.37

oraPrespawnedSrvProcessorID variable, C.40

oraPrespawnedSrvProtocolInfo variable, C.39

oraPrespawnedSrvRejectedConnections variable, C.35

oraPrespawnedSrvState variable, C.38

oraPrespawnedSrvTable, C.32

oraSIDcurrentlyConnectedClients variable, C.18

oraSIDListenerIndex variable, C.16

oraSIDName variable, C.17

oraSIDReservedConnections variable, C.19

oraSIDTable, C.15

P

PASSWORDS_listener_name parameter, C.8

Peer Executables, 2.1.3.1

Peer SNMP Master Agent, 2.1.3.1

Performance Ratios, 5.3

PGA memory, B.77

PHYBLKRD in V$FILESTAT, B.39

PHYBLKWRT in V$FILESTAT, B.40

PHYRDS in V$FILESTAT, B.37

PHYSICAL READS in V$SYSSTAT, B.9

PHYSICAL WRITES in V$SYSSTAT, B.10

PHYWRTS in V$FILESTAT, B.38

PINHITS in V$LIBRARYCACHE, B.49, B.56

PINS in V$LIBRARYCACHE, B.48, B.55

prespawned server

defined, C.32

private MIB

Listener, C

Oracle Database MIB, B

PROCESSES in INIT.ORA, B.67, B.74, B.75, B.79

R

Ratios, 5.2

rdbmsDbContact variable, D.6

rdbmsDbIndex variable, D.2

rdbmsDbInfoProductName variable, D.8

rdbmsDbInfoSizeAllocated variable, D.11

rdbmsDbInfoSizeUnits variable, D.10

rdbmsDbInfoSizeUsed variable, D.12

rdbmsDbInfoTable, D.7

rdbmsDbInfoVersion variable, D.9

rdbmsDbName variable, D.5

rdbmsDbPrivateMibOID variable, D.3

rdbmsDbTable, D.1

rdbmsDbVendorName variable, D.4

rdbmsRelState variable, D.35

rdbmsRelTable, D.34

rdbmsSrvContact variable, D.17

rdbmsSrvInfoDiskReads variable, D.21

rdbmsSrvInfoDiskWrites variable, D.23

rdbmsSrvInfoFinishedTransactions variable, D.20

rdbmsSrvInfoHighwaterInboundAssociations variable, D.28

rdbmsSrvInfoLogicalReads variable, D.22

rdbmsSrvInfoMaxInboundAssociations variable, D.29

rdbmsSrvInfoPageReads variable, D.25

rdbmsSrvInfoPageWrites variable, D.26

rdbmsSrvInfoRequestsHandled variable, D.27

rdbmsSrvInfoStartupTime variable, D.19

rdbmsSrvInfoTable, D.18

rdbmsSrvParamCurrValue variable, D.33

rdbmsSrvParamName variable, D.31

rdbmsSrvParamSubIndex variable, D.32

rdbmsSrvParamTable, D.30

rdbmsSrvPrivateMibOID variable, D.14

rdbmsSrvProductName variable, D.16

rdbmsSrvTable, D.13

rdbmsSrvVendorName variable, D.15

rdbmsStateChange trap, D.37

rdbmsTraps, D.36

READTIM in V$FILESTAT, B.41, B.42

Receivelets, 1.5.1.2

Recursive to User Call Ratio, 5.6

REDO ENTRIES in V$SYSSTAT, B.11

REDO LOG SPACE REQUESTS in V$SYSSTAT, B.12

Redo Log Space Wait Ratio, 5.6

REDO SYNC WRITES in V$SYSSTAT, B.13

Related Variables element

meaning in appendices, 4.1

RELOADS in V$LIBRARYCACHE, B.50, B.57

Row Source Ratio, 5.6

S

Sample Size, 5.2

SERVICES file, 2.1.3.2

SESSIONS in INIT.ORA, B.74, B.75

SGA

definition, B.59

shared pool

monitoring, B.43

SHARED_POOL_SIZE in INIT.ORA, B.76

SID_NAME parameter, C.17

Significance element

meaning in appendices, 4.1

SMALL_TABLE_THRESHOLD in INIT.ORA, B.21

SNMP, Preface, 1, 1

SNMP Peer Encapsulator, 2.1.3.1, 2.1.3.2

SNMP poll, 1.2

SNMP Trap, 1.5.1

SNMP Traps, 1.6

SNMP traps

about, F

snmp_ro.ora, A.1

snmp_rw.ora, A.1

snmp.index.listener-name parameter, C.16

SNMP.ORA configuration file

snmp.index.listener-name parameter, C.16

SNMPUTILG tool, 2.1.5

SNMPUTILG.EXE, 2.1.5

Sort Overflow Ratio, 5.6

SORT_AREA_RETAINED_SIZE in INIT.ORA, B.78

SORT_AREA_SIZE in INIT.ORA, B.77

SORTS DISKS in V$SYSSTAT, B.14

SORTS MEMORY in V$SYSSTAT, B.15

SORTS ROWS in V$SYSSTAT, B.16

Status element

meaning in appendices, 4.1

STATUS in V$TABLESPACE, B.31

Subagent, 1.3.6

T

TABLE FETCH BY ROWID in V$SYSSTAT, B.17

TABLE FETCH CONTINUED ROW in V$SYSSTAT, B.18

TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT, B.19

TABLE SCAN ROWS GOTTEN in V$SYSSTAT, B.20

TABLE SCANS LONG TABLES in V$SYSSTAT, B.21

TABLE SCANS SHORT TABLES in V$SYSSTAT, B.22

TIMED_STATISTICS in INIT.ORA, B.41, B.42

TRACE_FILE parameter, C.11

Transaction Rate, 5.6

TRANSACTIONS in INIT.ORA, B.79

TRANSACTIONS_PER_ROLLBACK_SEGMENT in INIT.ORA, B.80

traps, 1.2

tuning database server performance, 5.6

Tuning Ratios, 5.2

Typical Range element

meaning in appendices, 4.1

U

UNIX Platform, 2.2

User Call Rate, 5.6

USER CALLS in V$SYSSTAT, B.23

User Calls Per Parse, 5.6

USER COMMITS in V$SYSSTAT, B.24

User Datagram Protocol, 1.4

User Rollback Ratio, 5.6

USER ROLLBACKS in V$SYSSTAT, B.25

User-configurable Parameters, A.2

V

V$FILESTAT table, B.33

V$LIBRARYCACHE table, B.43

V$PARAMETER table, B.64

V$SGA table, B.59

V$SYSSTAT table, B.1

variables, B.43

see MIB variables, 5.4

W

Wraparound, 5.5