Oracle SNMP Support Reference Guide
Release 8.0.5
A64404-01
Library
Product
Contents
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
A
ADDRESS section
of LISTENER.ORA file, B-28
Administrative Region, C-8
agents, 1-3
extensible, 1-6
intelligent, 1-7
master, 1-3,
1-6
monolithic, 1-6
sub-, 1-3,
1-6
applAccumulatedInboundAssociations variable, E-8
applAccumulatedOutboundAssociations variable, E-9
applFailedOutboundAssociations variable, E-10
applInboundAssociations variable, E-8
applIndex variable, E-3
applLastChange variable, E-7
applLastInboundActivity variable, E-10
applLastOutboundActivity variable, E-10
applName variable, E-4
applOperStatus variable, E-6
applOutboundAssociations variable, E-8
applRejectedInboundAssociations variable, E-10
applTable, E-1
applUptime variable, E-5
applVersion variable, E-5
B
block changes per transaction
defined, 3-3
block get rate
defined, 3-3
block visits per transaction
defined, 3-3
BYTES in DBA_DATA_FILES, A-28
C
cache hit ratio
defined, 3-3
call rate
defined, 3-4
calls per transaction
defined, 3-4
changed block ratio
defined, 3-4
configuring
SNMP with Enterprise Manager, 1-14
Configuring SNMP on UNIX Platforms, 1-12
Configuring SNMP on Windows NT, 1-10
connectionless communication, 1-9
consistent change ratio
defined, 3-4
CONSISTENT CHANGES in V$SYSSTAT, A-4
CONSISTENT GETS in V$SYSSTAT, A-4
continued row ratio
defined, 3-4
D
database instance performance ratios, 3-3,
3-4
block changes per transaction, 3-3
block get rate, 3-3
cache hit ratio, 3-3
call rate, 3-4
calls per transaction, 3-4
changed block ratio, 3-4
continue row ratio, 3-4
library cache miss ratio, 3-4
most useful, 3-3
presenting graphically, 3-2
recursive to user call ratio, 3-5
redo log space wait ratio, 3-5
row source ratio, 3-5
scaling dynamically, 3-2
sort overflow ratio, 3-5
transaction rate, 3-5
user call rate, 3-5
user calls per parse, 3-6
user rollback ratio, 3-6
using a sufficient sample for, 3-1
DB BLOCK CHANGES in V$SYSSTAT, A-5
DB BLOCK GETS in V$SYSSTAT, A-6
DB_BLOCK_BUFFERS in INIT.ORA, A-47,
A-50
DB_BLOCK_CHECKPOINT_BATCH in INIT.ORA, A-48
DB_BLOCK_SIZE in INIT.ORA, A-30,
A-49
DB_FILE_MULTIBLOCK_READ_COUNT in INIT.ORA, A-50
DB_FILE_SIMULTANEOUS_WRITES in INIT.ORA, A-49
DBA_DATA_FILES, A-26
defined, 1
DBA_FREE_SPACE
defined, 1
dedicated server
defined, B-13
designing management applications, 3-1
dispatcher
defined, B-16
DISTRIBUTED_LOCK_TIMEOUT in INIT.ORA, A-50
DISTRIBUTED_RECOVERY_CONNECTION_HOLD_TIME in INIT.ORA, A-51
DISTRIBUTED_TRANSACTIONS in INIT.ORA, A-52
E
Explanation element
meaning in appendices, 4-1
extensible agents, 1-6
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-35,
A-39
GETS in V$LIBRARYCACHE, A-34,
A-39
I
INIT.ORA configuration file
defined, 2
MTS_LISTENER_ADDRESS parameter, B-20
instance
defined, 2
instrumentation, 1-8
intelligent agents, 1-7
INVALIDATIONS in V$LIBRARYCACHE, A-38,
A-42
L
library
defined, 2
library cache
defined, 2
MIB table for, A-32
library cache miss ratio
defined, 3-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-11
TRACE_FILE parameter, B-8
LOG_ARCHIVE_BUFFER_SIZE in INIT.ORA, A-52
LOG_ARCHIVE_BUFFERS in INIT.ORA, A-53
LOG_BUFFER in INIT.ORA, A-53
LOG_CHECKPOINT_INTERVAL in INIT.ORA, A-54
LOG_DIRECTORY parameter, B-7
LOG_FILES in INIT.ORA, A-55
LOG_INTERVAL_TIMEOUT in INIT.ORA, A-55
LONG_TABLE_THRESHOLD in INIT.ORA, A-18
M
managed elements, 1-3,
1-6
managed nodes, 1-6
management application
defined, 3
management applications, 1-5
tips for designing, 3-1
management consoles, 1-3
management framework
defined, 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-5
master agent
configuring, 1
defined, 3
master agents, 1-3,
1-6
MAX_ROLLBACK_SEGMENTS in INIT.ORA, A-56
Max-Access element
meaning in appendices, 4-1
MIB objects, 1-8
MIB variables
scaling dynamically, 3-2
MIBs, 1-3
defined, 1-8,
3
Listener MIB, B-1
Oracle Database MIB, A-1
Oracle Names MIB, C-1
private, 1-8
public Network Services MIB, E-1
public RDBMS MIB, D-1
reading variable descriptions, 4-1
standard hierarchy, 1-8
structure of, 1-8
variables, 1-8
monolithic agents, 1-6
MTS_LISTENER_ADDRESS parameter, B-20
MTS_MAX_DISPATCHERS in INIT.ORA, A-56
MTS_MAX_SERVERS in INIT.ORA, A-57
MTS_SERVERS in INIT.ORA, A-58
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-34
NAMES.TRACE_LEVEL field, C-2
network listener, B-1
NEXT_EXTANT in DBA_TABLES, A-25
nodes
managed, 1-6
O
Object Identifiers, 1-8
OID
defined, 4
OID subtree
defined, 4
OIDs, 1-8
OPEN_CURSORS in INIT.ORA, A-58
OPEN_LINKS in INIT.ORA, A-59
operating systems
SNMP support and, 1-10
OPTIMIZER_MODE in INIT.ORA, A-59
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-7
relationship with SNMP, 1-7
Oracle Multiprotocol Interchange
defined, 4
Oracle Names
configuration parameters, C-6
defined, 4
operational status, C-17
Oracle Names MIB, C-1
Oracle7 Server
defined, 4
oraDbConfigDbArchiveLogBuffers variable, A-53
oraDbConfigDbBlockBuffers variable, A-47
oraDbConfigDbBlockCkptBatch variable, A-48
oraDbConfigDbBlockSize variable, A-48
oraDbConfigDbFilesSimWrites variable, A-49
oraDbConfigDbMultiBlockReadCount variable, A-50
oraDbConfigDiskLockTimeout variable, A-50
oraDbConfigDistRecoveryConnectHold variable, A-51
oraDbConfigDistTransactions variable, A-51
oraDbConfigLogArchiveBufferSize variable, A-52
oraDbConfigLogBuffer variable, A-53
oraDbConfigLogCheckpointInterval variable, A-54
oraDbConfigLogCheckpointTimeout variable, A-54
oraDbConfigLogFiles variable, A-55
oraDbConfigMaxRollbackSegments variable, A-56
oraDbConfigMTSMaxDispatchers variable, A-56
oraDbConfigMTSMaxServers variable, A-57
oraDbConfigMTSServers variable, A-57
oraDbConfigOpenCursors variable, A-58
oraDbConfigOpenLinks variable, A-59
oraDbConfigOptimizerMode variable, A-59
oraDbConfigProcesses variable, A-60
oraDbConfigSerializable variable, A-61
oraDbConfigSessions variable, A-61
oraDbConfigSharedPool variable, A-62
oraDbConfigSortAreaRetainedSize variable, A-63
oraDbConfigSortAreaSize variable, A-63
oraDbConfigTable, A-45
oraDbConfigTransactions variable, A-64
oraDbConfigTranspactionsPerRollback variable, A-64
oraDbDataFileDiskReadBlocks variable, A-29
oraDbDataFileDiskReads variable, A-28
oraDbDataFileDiskReadTimeTicks variable, A-31
oraDbDataFileDiskWrites variable, A-29
oraDbDataFileDiskWriteTimeTicks variable, A-31
oraDbDataFileDiskWrittenBlocks variable, A-30
oraDbDataFileIndex variable, A-26
oraDbDataFileSizeAllocated variable, A-28
oraDbDatFileName variable, A-27
oraDbDatFileTable, A-25
oraDbLibraryCacheGetHits variable, A-35
oraDbLibraryCacheGets variable, A-34
oraDbLibraryCacheIndex variable, A-33
oraDbLibraryCacheInvalidations variable, A-37
oraDbLibraryCacheNameSpace variable, A-34
oraDbLibraryCachePinHits variable, A-36
oraDbLibraryCachePins variable, A-35
oraDbLibraryCacheReloads variable, A-37
oraDbLibraryCacheSumGetHits variable, A-39
oraDbLibraryCacheSumGets variable, A-38
oraDbLibraryCacheSumInvalidations variable, A-42
oraDbLibraryCacheSumPinHits variable, A-40
oraDbLibraryCacheSumPins variable, A-40
oraDbLibraryCacheSumReloads variable, A-41
oraDbLibraryCacheSumTable, A-38
oraDbLibraryCacheTable, A-32
oraDbSGADatabaseBuffers variable, A-44
oraDbSGAFixedSize variable, A-43
oraDbSGARedoBuffers variable, A-45
oraDbSGATable, A-42
oraDbSGAVariableSize variable, A-44
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-25
oraDbTablespaceName variable, A-22
oraDbTablespaceSizeAllocated variable, A-23
oraDbTablespaceSizeUsed variable, A-23
oraDbTablespaceState variable, A-24
oraDbTablespaceTable, A-21
oraDedicatedSrvEstablishedConnections variable, B-15
oraDedicatedSrvIndex variable, B-14
oraDedicatedSrvRejectedConnections variable, B-15
oraDedicatedSrvTable, B-13
oraDispatcherCurrentConnections variable, B-18
oraDispatcherEstablishedConnections variable, B-17
oraDispatcherIndex variable, B-17
oraDispatcherMaximumConnections variable, B-19
oraDispatcherProtocolInfo variable, B-20
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-9
oraListenerIndex variable, B-2
oraListenerLogFile, B-7
oraListenerName variable, B-3
oraListenerNumberOfServices variable, B-9
oraListenerParameterFile variable, B-6
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-28
oraListenerUptime variable, B-5
oraListenerVersion variable, B-3
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-24
oraPrespawnedSrvProcessorID variable, B-26
oraPrespawnedSrvProtocolInfo variable, B-26
oraPrespawnedSrvRejectedConnections variable, B-23
oraPrespawnedSrvState variable, B-25
oraPrespawnedSrvTable, B-21
oraRepDisabledTriggers variable, A-66
oraRepInvalidPackages variable, A-67
oraRepLinkAdminRequests variable, A-79
oraRepLinkDeferredTransactions variable, A-78
oraRepLinkErrors variable, A-78
oraRepLinkIndex variable, A-76
oraRepLinkName variable, A-77
oraRepLinkTable, A-76
oraRepMasterSchemaOtherMasters, A-74
oraRepMasterSchemaRequestErrors variable, A-72
oraRepMasterSchemaResolvedConflicts variable, A-73
oraRepMasterSchemaTable, A-72
oraRepPending2PhaseCommits variable, A-65
oraRepSchemaIndex variable, A-68
oraRepSchemaLinks, A-71
oraRepSchemaName variable, A-69
oraRepSchemas variable, A-67
oraRepSchemaStatus variable, A-70
oraRepSchemaTable, A-68
oraRepSchemaType variable, A-70
oraRepSnapshotSchemaMaster variable, A-75
oraRepSnapshotSchemaSnapshots variable, A-75
oraRepSnapshotSchemaTable, A-74
oraRepTable, A-65
oraSIDcurrentlyConnectedClients variable, B-12
oraSIDListenerIndex variable, B-11
oraSIDName variable, B-11
oraSIDReservedConnections variable, B-13
oraSIDTable, B-10
P
packets
recovering lost, 1-9
PARSE COUNT in V$SYSSTAT, A-8
PASSWORDS_listener_name parameter, B-6
performance ratios
see database instance performance ratios, 3-1
PGA memory, A-63
PHYBLKRD in V$FILESTAT, A-30
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-29
pin
defined, 4
PINHITS in V$LIBRARYCACHE, A-36,
A-41
PINS in V$LIBRARYCACHE, A-36,
A-40
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-50,
A-60,
A-62,
A-64
protocols
between master and subagents, 1-6
implementing SNMP, 1-10
R
ratios
see database instance performance ratios, 3-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-31,
A-32
recursive to user call ratio
defined, 3-5
REDO ENTRIES in V$SYSSTAT, A-10
REDO LOG SPACE REQUESTS in V$SYSSTAT, A-11
redo log space wait ratio
defined, 3-5
REDO SYNC WRITES in V$SYSSTAT, A-11
Related Variables element
meaning in appendices, 4-2
RELOADS in V$LIBRARYCACHE, A-37,
A-41
replication, A-65
repositories, 1-4
row source ratio
defined, 3-5
S
schemas
replication of, A-65
SERIALIZABLE in INIT.ORA, A-61
server
defined, 5
Server Manager, 1-2
SESSIONS in INIT.ORA, A-60,
A-61
SGA
defined, 5
definition, A-42
Shared Global Area
defined, 5
shared pool
defined, 5
monitoring, A-32
SHARED_POOL_SIZE in INIT.ORA, A-62
SID_NAME parameter, B-11
Significance element
meaning in appendices, 4-2
SMALL_TABLE_THRESHOLD in INIT.ORA, A-17
SNMP
defined, 1-3
operating system support of, 1-10
Oracle products supporting, 1-10
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, 5
SNMP.ORA configuration file
LISTENER_CONTACT parameter, B-10
snmp.index.listener-name parameter, B-2,
B-11
sort overflow ratio
defined, 3-5
SORT_AREA_RETAINED_SIZE in INIT.ORA, A-63
SORT_AREA_SIZE in INIT.ORA, A-63
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, 4-1
Status element
meaning in appendices, 4-1
STATUS in V$TABLESPACE, A-24
subagent
defined, 5
subagents, 1-3,
1-6
Suggested Presentation element
meaning in appendices, 4-2
Syntax element
meaning in appendices, 4-1
sysUpTime
used to derive oraListenerUpTime value, B-5
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-31,
A-32
TRACE_FILE parameter, B-8
transaction rate
defined, 3-5
TRANSACTIONS in INIT.ORA, A-64
TRANSACTIONS_PER_ROLLBACK_SEGMENT in INIT.ORA, A-65
traps, 1-3
tuning database server performance, 3-3
Typical Range element
meaning in appendices, 4-1
U
user call rate
defined, 3-5
USER CALLS in V$SYSSTAT, A-18
user calls per parse
defined, 3-6
USER COMMITS in V$SYSSTAT, A-19
user rollback ratio
defined, 3-6
USER ROLLBACKS in V$SYSSTAT, A-20
V
V$ table
defined, 5
V$DATABASE table
defined, 6
V$FILESTAT table, A-26,
6
V$INSTANCE table
defined, 6
V$LIBRARYCACHE table, A-33
defined, 6
V$LICENSE table
defined, 6
V$PARAMETER table, A-45
V$ROWCACHE table
defined, 6
V$SESSTAT table
defined, 6
V$SGA table, A-43
defined, 7
V$SGASTAT table
defined, 7
V$SYSSTAT table, A-2
defined, 7
V$VERSION table
defined, 7
variables, A-32
reading descriptions of, 4-1
see MIB variables, 3-2
W
WRITE REQUESTS in V$SYSSTAT, A-20
Prev
Copyright © 1998 Oracle Corporation.
All Rights Reserved.
Library
Product
Contents