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