Index

@ A B C D E F G H I J K L M N O P Q R S T U V W X Y Z

@

• $ORACLE_HOME/network/admin

  A

• ADDRESS section, of LISTENER.ORA file
• Administrative Region
• agents
  • extensible
  • master [2]
  • monolithic
  • SNMP version followed
  • sub- [2] [3]
• applAccumulatedInboundAssociations variable
• applAccumulatedOutboundAssociations variable
• applFailedOutboundAssociations variable
• applInboundAssociations variable
• applIndex variable
• applLastChange variable
• applLastInboundActivity variable
• applLastOutboundActivity variable
• applName variable
• applOperStatus variable
• applOutboundAssociations variable
• applRejectedInboundAssociations variable
• applTable
• applUptime variable
• applVersion variable

  B

• block changes per transaction, defined
• block get rate, defined
• block visits per transaction, defined
• BYTES in DBA_DATA_FILES

  C

• cache hit ratio, defined
• call rate, defined
• calls per transaction, defined
• changed block ratio, defined
• Connection Manager, defined
• connectionless communication
• consistent change ratio, defined
• CONSISTENT CHANGES in V$SYSSTAT
• CONSISTENT GETS in V$SYSSTAT
• continued row ratio, defined
• Control Utility program, for Oracle Multiprotocol Interchange

  D

• database instance performance ratios [2]
  • block changes per transaction
  • block get rate
  • cache hit ratio
  • call rate
  • calls per transaction
  • changed block ratio
  • continue row ratio
  • library cache miss ratio
  • most useful
  • presenting graphically
  • recursive to user call ratio
  • redo log space wait ratio
  • row source ratio
  • scaling dynamically
  • sort overflow ratio
  • transaction rate
  • user call rate
  • user calls per parse
  • user rollback ratio
  • using a sufficient sample for
• DB BLOCK CHANGES in V$SYSSTAT
• DB BLOCK GETS in V$SYSSTAT
• DB_BLOCK_BUFFERS in INIT.ORA [2]
• DB_BLOCK_CHECKPOINT_BATCH in INIT.ORA
• DB_BLOCK_SIZE in INIT.ORA [2]
• DB_FILE_MULTIBLOCK_READ_COUNT in INIT.ORA
• DB_FILE_SIMULTANEOUS_WRITES in INIT.ORA
• DBA_DATA_FILES
  • defined
• DBA_FREE_SPACE, defined
• dedicated server, defined
• designing management applications
• dispatcher, defined
• DISTRIBUTED_LOCK_TIMEOUT in INIT.ORA
• DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME in INIT.ORA
• DISTRIBUTED_TRANSACTIONS in INIT.ORA

  E

• Explanation element, meaning in appendices
• extensible agents

  F

• FILE_ID in DBA_DATA_FILES
• FILE_NAME in DBA_DATA_FILES
• frameworks [2]

  G

• GETHITS in V$LIBRARYCACHE [2]
• GETS in V$LIBRARYCACHE [2]

  H

  I

• INIT.ORA configuration file
  • defined
  • MTS_LISTENER_ADDRESS parameter
• instance, defined
• instrumentation
• INTCHG.ORA configuration file
  • directory for
• INVALIDATIONS in V$LIBRARYCACHE [2]

  J

  K

  L

• library cache miss ratio, defined
• library cache
  • defined
  • MIB table for
• library, defined
• LISTENER.ORA configuration file
  • ADDRESS section
  • LOG_DIRECTORY parameter
  • PASSWORDS_listener_name parameter
  • SID_NAME parameter
  • TRACE_FILE parameter
• listener
  • definition
  • MIB
• LOG_ARCHIVE_BUFFER_SIZE in INIT.ORA
• LOG_ARCHIVE_BUFFERS in INIT.ORA
• LOG_BUFFER in INIT.ORA
• LOG_CHECKPOINT_INTERVAL in INIT.ORA
• LOG_DIRECTORY parameter
• LOG_FILES in INIT.ORA
• LOG_INTERVAL_TIMEOUT in INIT.ORA
• LONG_TABLE_THRESHOLD in INIT.ORA

  M

• managed elements [2]
• managed nodes
• management application, defined [2]
• management applications
  • tips for designing
• management consoles [2]
• management framework, defined [2]
• management frameworks [2]
• Management Information Bases
• management stations [2]
• management systems [2]
• managing nodes [2] [3]
• mapping the network [2]
• master agent, defined
• master agents [2]
• Max-Access element, meaning in appendices
• MAX_ROLLBACK_SEGMENTS in INIT.ORA
• MIB objects
• MIB variables, scaling dynamically
• MIBs
  • defined [2]
  • Listener MIB
  • Oracle Database MIB
  • Oracle Multiprotocol Interchange MIB
  • Oracle Names MIB
  • private
  • public Network Services MIB
  • public RDBMS MIB
  • reading variable descriptions
  • SNMP version followed
  • standard hierarchy
  • structure of
  • variables
• monolithic agents
• MTS_LISTENER_ADDRESS parameter
• MTS_MAX_DISPATCHERS in INIT.ORA
• MTS_MAX_SERVERS in INIT.ORA
• MTS_SERVERS in INIT.ORA
• Multiprotocol Interchange
  • Connection Manager
  • Navigator

  N

• NAME in V$TABLESPACE
• Names MIB, see Oracle Names MIB
• NAMES.ORA configuration file [2]
• NAMES.TRACE_LEVEL field
• NAMESPACE in V$LIBRARYCACHE
• Navigator, defined
• network listener
• NEXT_EXTANT in DBA_TABLES
• nodes, managed

  O

• Object Identifiers
• OID subtree, defined
• OID, defined
• OIDs
• OPEN_CURSORS in INIT.ORA
• OPEN_LINKS in INIT.ORA
• operating systems, SNMP support and
• OPTIMIZER_MODE in INIT.ORA
• Oracle Database MIB
• ORACLE Multiprotocol Interchange
  • Control Utility program
  • defined
• Oracle Names MIB
• Oracle Names
  • configuration parameters
  • defined
  • operational status
• Oracle7 Server, defined
• Oracle, MIB, Listener
• oraCmanagerAccumulatedFailedConnections variable
• oraCmanagerAccumulatedSuccessfulConnections variable
• oraCmanagerActivePumps variable
• oraCmanagerAverageConnectTime variable
• oraCmanagerCurrentConnectionsInUse variable
• oraCmanagerErrorMessage variable
• oraCmanagerErrors variable
• oraCmanagerFailedAddressIndex variable
• oraCmanagerFailedAddressTable
• oraCmanagerImmediateAverageBytes variable
• oraCmanagerListenAddress variable
• oraCmanagerListenAddressIndex variable
• oraCmanagerListenAddressTable
• oraCmanagerLogFile variable
• oraCmanagerLogging variable
• oraCmanagerMaximumConnectDuration variable
• oraCmanagerMaximumConnections variable
• oraCmanagerMaximumConnectionsPerPump variable
• oraCmanagerMaximumConnectTime variable
• oraCmanagerMaximumPumps variable
• oraCmanagerMinimumConnectTime variable
• oraCmanagerPumpStrategy variable
• oraCmanagerRunningTime variable
• oraCmanagerStartTime variable
• oraCmanagerState variable
• oraCmanagerStoppable variable
• oraCmanagerTable
• oraCmanagerTraceFile variable
• oraCmanagerTraceLevel variable
• oraCmangerFailedAddress variable
• oraConnectionDestinationAddress variable
• oraConnectionDuration variable
• oraConnectionIdleTime variable
• oraConnectionIndex variable
• oraConnectionPumpID variable
• oraConnectionSourceAddress variable
• oraConnectionTable
• oraDbConfigDbArchiveLogBuffers variable
• oraDbConfigDbBlockBuffers variable
• oraDbConfigDbBlockCkptBatch variable
• oraDbConfigDbBlockSize variable
• oraDbConfigDbFilesSimWrites variable
• oraDbConfigDbMultiBlockReadCount variable
• oraDbConfigDiskLockTimeout variable
• oraDbConfigDistRecoveryConnectHold variable
• oraDbConfigDistTransactions variable
• oraDbConfigLogArchiveBufferSize variable
• oraDbConfigLogBuffer variable
• oraDbConfigLogCheckpointInterval variable
• oraDbConfigLogCheckpointTimeout variable
• oraDbConfigLogFiles variable
• oraDbConfigMaxRollbackSegments variable
• oraDbConfigMTSMaxDispatchers variable
• oraDbConfigMTSMaxServers variable
• oraDbConfigMTSServers variable
• oraDbConfigOpenCursors variable
• oraDbConfigOpenLinks variable
• oraDbConfigOptimizerMode variable
• oraDbConfigProcesses variable
• oraDbConfigSerializable variable
• oraDbConfigSessions variable
• oraDbConfigSharedPool variable
• oraDbConfigSortAreaRetainedSize variable
• oraDbConfigSortAreaSize variable
• oraDbConfigTable
• oraDbConfigTransactions variable
• oraDbConfigTranspactionsPerRollback variable
• oraDbDataFileDiskReadBlocks variable
• oraDbDataFileDiskReads variable
• oraDbDataFileDiskReadTimeTicks variable
• oraDbDataFileDiskWrites variable
• oraDbDataFileDiskWriteTimeTicks variable
• oraDbDataFileDiskWrittenBlocks variable
• oraDbDataFileIndex variable
• oraDbDataFileSizeAllocated variable
• oraDbDatFileName variable
• oraDbDatFileTable
• oraDbLibraryCacheGetHits variable
• oraDbLibraryCacheGets variable
• oraDbLibraryCacheIndex variable
• oraDbLibraryCacheInvalidations variable
• oraDbLibraryCacheNameSpace variable
• oraDbLibraryCachePinHits variable
• oraDbLibraryCachePins variable
• oraDbLibraryCacheReloads variable
• oraDbLibraryCacheSumGetHits variable
• oraDbLibraryCacheSumGets variable
• oraDbLibraryCacheSumInvalidations variable
• oraDbLibraryCacheSumPinHits variable
• oraDbLibraryCacheSumPins variable
• oraDbLibraryCacheSumReloads variable
• oraDbLibraryCacheSumTable
• oraDbLibraryCacheTable
• oraDbSGADatabaseBuffers variable
• oraDbSGAFixedSize variable
• oraDbSGARedoBuffers variable
• oraDbSGATable
• oraDbSGAVariableSize variable
• oraDbSysConsistentChanges variable
• oraDbSysContact variable
• oraDbSysDbBlockChanges variable
• oraDbSysDbBlockGets variable
• oraDbSysFreeBufferInspected variable
• oraDbSysFreeBufferRequested variable
• oraDbSysParseCount variable
• oraDbSysPhysReads variable
• oraDbSysPhysWrites variable
• oraDbSysRedoEntries variable
• oraDbSysRedoLogSpaceRequests variable
• oraDbSysRedoSyncWrites variable
• oraDbSysSortsDisk variable
• oraDbSysSortsMemory variable
• oraDbSysSortsRows variable
• oraDbSysTable
• oraDbSysTableFetchContinuedRow variable
• oraDbSysTableFetchRowid variable
• oraDbSysTableScanBlocks variable
• oraDbSysTableScanRows variable
• oraDbSysTableScansLong variable
• oraDbSysTableScansShort variable
• oraDbSysUserCalls variable
• oraDbSysUserCommits variable
• oraDbSysUserRollbacks variable
• oraDbSyysWriteRequests variable
• oraDbTablespaceIndex variable
• oraDbTablespaceLargestAvailableChunk variable
• oraDbTablespaceName variable
• oraDbTablespaceSizeAllocated variable
• oraDbTablespaceSizeUsed variable
• oraDbTablespaceState variable
• oraDbTablespaceTable
• oraDedicatedSrvEstablishedConnections variable
• oraDedicatedSrvIndex variable
• oraDedicatedSrvRejectedConnections variable
• oraDedicatedSrvTable
• oraDispatcherCurrentConnections variable
• oraDispatcherEstablishedConnections variable
• oraDispatcherIndex variable
• oraDispatcherMaximumConnections variable
• oraDispatcherProtocolInfo variable
• oraDispatcherRejectedConnections variable
• oraDispatcherState variable
• oraDispatcherTable
• oraInterchgConfigDirectory variable
• oraInterchgContactInfo variable
• oraInterchgTable
• oraInterchgTraps
• oraListenAddress variable
• oraListenAddressIndex variable
• oraListenAddressTable
• oraListenerContact variable
• oraListenerIndex variable
• oraListenerLogFile
• oraListenerName variable
• oraListenerNumberOfServices variable
• oraListenerParameterFile variable
• oraListenerSecurityLevel variable
• oraListenerState variable [2]
• oraListenerStateChange variable
• oraListenerTable
• oraListenerTraceFile
• oraListenerTraceLevel variable
• oraListenerTraps
• oraListenerUptime variable
• oraListenerVersion variable
• oraNamesConfigAdminRegion variable
• oraNamesConfigAuthorityRequired variable
• oraNamesConfigAutoRefreshExpire variable
• oraNamesConfigAutoRefreshRetry variable
• oraNamesConfigCacheCheckpointFile variable
• oraNamesConfigCacheCheckpointInterval variable
• oraNamesConfigDefaultForwardersOnly variable
• oraNamesConfigForwardingAvailable variable
• oraNamesConfigForwardingDesired variable
• oraNamesConfigLogStatsInterval variable
• oraNamesConfigMaxReforwards variable
• oraNamesConfigNoModifyRequests variable
• oraNamesConfigResetStatsInterval variable
• oraNamesConfigServerName variable
• oraNamesConfigTable
• oraNamesServerAdminRegion variable
• oraNamesServerAliasLoopsDetected variable
• oraNamesServerCorruptMessagesReceived variable
• oraNamesServerCreatedOnLookup variable
• oraNamesServerExactMatches variable
• oraNamesServerForwardFailures variable
• oraNamesServerForwardTimeouts variable
• oraNamesServerLookupFailures variable
• oraNamesServerLookupsAttempted variable
• oraNamesServerName variable
• oraNamesServerQueriesReceived variable
• oraNamesServerQueriesTotalTime variable
• oraNamesServerReloadCheckFailures variable
• oraNamesServerRequestsForwarded variable
• oraNamesServerResponsesReceived variable
• oraNamesServerResponsesSent variable
• oraNamesServerTable
• oraNamesTnsContact variable
• oraNamesTnsLogFile variable
• oraNamesTnsParameter variable
• oraNamesTnsReload variable
• oraNamesTnsRunningTime variable
• oraNamesTnsTable
• oraNamesTnsTraceFile variable
• oraNamesTnsTraceLevel variable
• oraNavigatorAccumulatedFailedRequests variable
• oraNavigatorAccumulatedSuccessfulRequests variable
• oraNavigatorErrorMessage variable
• oraNavigatorErrors variable
• oraNavigatorFailedAddress variable
• oraNavigatorFailedAddressIndex variable
• oraNavigatorFailedAddressTable
• oraNavigatorListenAddress variable
• oraNavigatorListenAddressIndex variable
• oraNavigatorListenAddressTable
• oraNavigatorLogFile variable
• oraNavigatorLogging variable
• oraNavigatorLoggingLevel variable
• oraNavigatorRouteAddress variable
• oraNavigatorRouteAddressIndex variable
• oraNavigatorRouteAddressTable
• oraNavigatorRunningTime variable
• oraNavigatorState variable
• oraNavigatorStoppable variable
• oraNavigatorTable
• oraNavigatorTraceFile variable
• oraNavigatorTraceLevel variable
• oraPrespawnedSrvCurrentConnections variable
• oraPrespawnedSrvEstablishedConnections variable
• oraPrespawnedSrvIndex variable
• oraPrespawnedSrvMaximumConnections variable
• oraPrespawnedSrvProcessorID variable
• oraPrespawnedSrvProtocolInfo variable
• oraPrespawnedSrvRejectedConnections variable
• oraPrespawnedSrvState variable
• oraPrespawnedSrvTable
• oraPumpAccumulatedBytesSent variable
• oraPumpActiveConnections variable
• oraPumpActiveTime variable
• oraPumpAverageConnectTime variable
• oraPumpBufferUtilization variable
• oraPumpCurrentBytesPerSecond variable
• oraPumpErrorMessage variable
• oraPumpErrors variable
• oraPumpFailedAddress variable
• oraPumpFailedAddressIndex variable
• oraPumpFailedAddressTable
• oraPumpFailedConnections variable
• oraPumpImmediateAverageBytes variable
• oraPumpIndex variable
• oraPumpListenAddress variable
• oraPumpListenAddressIndex variable
• oraPumpMaximumAverageBytes variable
• oraPumpMaximumBuffers variable
• oraPumpMaximumConnectDuration variable
• oraPumpMaximumConnectTime variable
• oraPumpMinimumConnectTime variable
• oraPumpSuccessfulConnections variable
• oraPumpTable
• oraPumpTraceFile variable
• oraPumpTraceLevel variable
• oraRepDisabledTriggers variable
• oraRepInvalidPackages variable
• oraRepLinkAdminRequests variable
• oraRepLinkDeferredTransactions variable
• oraRepLinkErrors variable
• oraRepLinkIndex variable
• oraRepLinkName variable
• oraRepLinkTable
• oraRepMasterSchemaOtherMasters
• oraRepMasterSchemaRequestErrors variable
• oraRepMasterSchemaResolvedConflicts variable
• oraRepMasterSchemaTable
• oraRepPending2PhaseCommits variable
• oraRepSchemaIndex variable
• oraRepSchemaLinks
• oraRepSchemaName variable
• oraRepSchemas variable
• oraRepSchemaStatus variable
• oraRepSchemaTable
• oraRepSchemaType variable
• oraRepSnapshotSchemaMaster variable
• oraRepSnapshotSchemaSnapshots variable
• oraRepSnapshotSchemaTable
• oraRepTable
• oraSIDcurrentlyConnectedClients variable
• oraSIDListenerIndex variable
• oraSIDName variable
• oraSIDReservedConnections variable
• oraSIDTable

  P

• packets, recovering lost
• PARSE COUNT in V$SYSSTAT
• PASSWORDS_listener_name parameter
• performance ratios, see database instance performance ratios
• PGA memory
• PHYBLKRD in V$FILESTAT
• PHYBLKWRT in V$FILESTAT
• PHYRDS in V$FILESTAT
• PHYSICAL READS in V$SYSSTAT
• PHYSICAL WRITES in V$SYSSTAT
• PHYWRTS in V$FILESTAT
• pin, defined
• PINHITS in V$LIBRARYCACHE [2]
• PINS in V$LIBRARYCACHE [2]
• platforms, management
• polls
• prespawned server, defined
• private MIB
  • Listener
  • Oracle Database MIB
  • Oracle Multiprotocol Interchange MIB
  • Oracle Names MIB
• PROCESSES in INIT.ORA [2] [3] [4]
• protocols
  • between master and subagents
  • implementing SNMP
• PUMP_CONNECTIONS in INTCHG.ORA [2]
• PUMP_UPTIME in INTCHG.ORA
• pump, definition
• PUMPS in INTCHG.ORA [2]

  Q

  R

• ratios, see database instance performance ratios
• rdbmsDbContact variable
• rdbmsDbIndex variable
• rdbmsDbInfoProductName variable
• rdbmsDbInfoSizeAllocated variable
• rdbmsDbInfoSizeUnits variable
• rdbmsDbInfoSizeUsed variable
• rdbmsDbInfoTable
• rdbmsDbInfoVersion variable
• rdbmsDbName variable
• rdbmsDbPrivateMibOID variable
• rdbmsDbTable
• rdbmsDbVendorName variable
• rdbmsRelState variable
• rdbmsRelTable
• rdbmsSrvContact variable
• rdbmsSrvInfoDiskReads variable
• rdbmsSrvInfoDiskWrites variable
• rdbmsSrvInfoFinishedTransactions variable
• rdbmsSrvInfoHighwaterInboundAssociations variable
• rdbmsSrvInfoLogicalReads variable
• rdbmsSrvInfoMaxInboundAssociations variable
• rdbmsSrvInfoPageReads variable
• rdbmsSrvInfoPageWrites variable
• rdbmsSrvInfoRequestsHandled variable
• rdbmsSrvInfoStartupTime variable
• rdbmsSrvInfoTable
• rdbmsSrvParamCurrValue variable
• rdbmsSrvParamName variable
• rdbmsSrvParamSubIndex variable
• rdbmsSrvParamTable
• rdbmsSrvPrivateMibOID variable
• rdbmsSrvProductName variable
• rdbmsSrvTable
• rdbmsSrvVendorName variable
• rdbmsStateChange trap
• rdbmsTraps
• READTIM in V$FILESTAT [2]
• recursive to user call ratio, defined
• REDO ENTRIES in V$SYSSTAT
• REDO LOG SPACE REQUESTS in V$SYSSTAT
• redo log space wait ratio, defined
• REDO SYNC WRITES in V$SYSSTAT
• Related Variables element, meaning in appendices
• RELOADS in V$LIBRARYCACHE [2]
• replication
• repositories
• route address, defined
• row source ratio, defined

  S

• schemas, replication of
• SERIALIZABLE in INIT.ORA
• Server Manager
• server, defined
• SESSIONS in INIT.ORA [2]
• SGA
  • defined
  • definition
• Shared Global Area, defined
• shared pool
  • defined
  • monitoring
• SHARED_POOL_SIZE in INIT.ORA
• SID_NAME parameter
• Significance element, meaning in appendices
• SMALL_TABLE_THRESHOLD in INIT.ORA
• snmp.contact.listener_name
• snmp.index.listener-name parameter
• snmp.index.listenername parameter
• SNMP.ORA
• SNMP.ORA configuration file
  • LISTENER_CONTACT parameter
  • snmp.index.listener-name parameter [2]
• SNMP
  • defined
  • operating system support of
  • Oracle products supporting
  • versions of
• sort overflow ratio, defined
• SORT_AREA_RETAINED_SIZE in INIT.ORA
• SORT_AREA_SIZE in INIT.ORA
• SORTS DISKS in V$SYSSTAT
• SORTS MEMORY in V$SYSSTAT
• SORTS ROWS in V$SYSSTAT
• SQL*Net
• Status element
  • meaning in appendices
  • of SNMP MIB definition, Version 2
• STATUS in V$TABLESPACE
• subagent, defined
• subagents [2] [3]
• Suggested Presentation element, meaning in appendices
• Syntax element, meaning in appendices
• sysUpTime, used to derive oraListenerUpTime value

  T

• TABLE FETCH BY ROWID in V$SYSSTAT
• TABLE FETCH CONTINUED ROW in V$SYSSTAT
• TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT
• TABLE SCAN ROWS GOTTEN in V$SYSSTAT
• TABLE SCANS LONG TABLES in V$SYSSTAT
• TABLE SCANS SHORT TABLES in V$SYSSTAT
• TIMED_STATISTICS in INIT.ORA [2]
• TNS_ADMIN, default directory for
• TNSNAV.ORA configuration file, directory for
• TNSNET.ORA configuration file, directory for
• TRACE_FILE parameter
• transaction rate, defined
• TRANSACTIONS in INIT.ORA
• TRANSACTIONS_PER_ROLLBACK_SEGMENT in INIT.ORA
• trap variables, for Oracle Multiprotocol Interchange
• traps
• tuning database server performance
• Typical Range element, meaning in appendices

  U

• user call rate, defined
• USER CALLS in V$SYSSTAT
• user calls per parse, defined
• USER COMMITS in V$SYSSTAT
• user rollback ratio, defined
• USER ROLLBACKS in V$SYSSTAT

  V

• V$ table, defined
• V$DATABASE table, defined
• V$FILESTAT table [2]
• V$INSTANCE table, defined
• V$LIBRARYCACHE table
  • defined
• V$LICENSE table, defined
• V$PARAMETER table
• V$ROWCACHE table, defined
• V$SESSTAT table, defined
• V$SGA table
  • defined
• V$SGASTAT table, defined
• V$SYSSTAT table
  • defined
• V$TABLESPACE table, defined
• V$VERSION table, defined
• variables
  • reading descriptions of
  • see MIB variables

  W

• WRITE REQUESTS in V$SYSSTAT

  X

  Y

  Z