Index

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

A

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
Suggested Presentation element
meaning in appendices, 4.1
Syntax element
meaning in appendices, 4.1
sysUpTime
used to derive oraListenerUpTime value, C.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