Oracle SNMP Support Reference Guide
Release 8.1.7

Part Number A85249-01

Library

Product

Contents

Index

Go to previous page Go to next page

A
Interpreting Variables of the Oracle Database MIB

This appendix provides information to help you interpret individual variables in the private Oracle Database MIB. Specifically, it includes sections covering SNMP variables in the following tables:

For information about the database instance performance ratios listed in this appendix, see the section, "Most Useful Database Instance Performance Ratios," in Chapter 3, "Designing Management Applications Based on Oracle MIBs." For more information about the Oracle database server and specific topics covered in this appendix, see the ORACLE Server Reference, the Oracle Server Application Developer's Guide, and the Oracle Server Concepts Manual specific to your system.

oraDbSysTable

The oraDbSysTable contains various measurements used to support database activities of current sessions on the managed node. This information has been found to be particularly useful for monitoring global database instance performance.

Each entry in the oraDbSysTable represents a current database instance on the node. Each entry is indexed by rdbmsDb Index. However, because rdbmsDbTable contains an entry for each database configured for SNMP support, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. (For details about this index, see Appendix D, "Interpreting Variables of the Public RDBMS MIB.") The value of each oraDbSysTable variable is retrieved directly from a corresponding field in the V$SYSSTAT table for that database instance on the managed node.

In many cases, a variable is meaningful only when considered in conjunction with other variables, often as a ratio. For more information on the ratios mentioned in the following variable descriptions, and for their significance in tuning the Oracle database server, see the Oracle Tuning Guide specific to your system.

Table A-1 oraDbSysTable Variables and Corresponding Object IDs
Variable Name  Object ID 

oraDbSysConsistentChanges 

1.3.6.1.4.1.111.4.1.1.1.1 

oraDbSysConsistentGets 

1.3.6.1.4.1.111.4.1.1.1.2 

oraDbSysDbBlockChanges 

1.3.6.1.4.1.111.4.1.1.1.3 

oraDbSysDbBlockGets 

1.3.6.1.4.1.111.4.1.1.1.4 

oraDbSysFreeBufferInspected 

1.3.6.1.4.1.111.4.1.1.1.5 

oraDbSysFreeBufferRequested 

1.3.6.1.4.1.111.4.1.1.1.6 

oraDbSysParseCount 

1.3.6.1.4.1.111.4.1.1.1.7 

oraDbSysPhysReads 

1.3.6.1.4.1.111.4.1.1.1.8 

oraDbSysPhysWrites 

1.3.6.1.4.1.111.4.1.1.1.9 

oraDbSysRedoEntries 

1.3.6.1.4.1.111.4.1.1.1.10 

oraDbSysRedoLogSpaceRequests  

1.3.6.1.4.1.111.4.1.1.1.11 

oraDbSysRedoSyncWrites 

1.3.6.1.4.1.111.4.1.1.1.12 

oraDbSysSortsDisk 

1.3.6.1.4.1.111.4.1.1.1.13 

oraDbSysSortsMemory 

1.3.6.1.4.1.111.4.1.1.1.14 

oraDbSysSortsRows 

1.3.6.1.4.1.111.4.1.1.1.15 

oraDbSysTableFetchRowid 

1.3.6.1.4.1.111.4.1.1.1.16 

oraDbSysTableFetchContinuedRow 

1.3.6.1.4.1.111.4.1.1.1.17 

oraDbSysTableScanBlocks 

1.3.6.1.4.1.111.4.1.1.1.18 

oraDbSysTableScanRows 

1.3.6.1.4.1.111.4.1.1.1.19 

oraDbSysTableScansLong 

1.3.6.1.4.1.111.4.1.1.1.20 

oraDbSysTableScansShort 

1.3.6.1.4.1.111.4.1.1.1.21 

oraDbSysUserCalls  

1.3.6.1.4.1.111.4.1.1.1.22 

oraDbSysUserCommits 

1.3.6.1.4.1.111.4.1.1.1.23 

oraDbSysUserRollbacks 

1.3.6.1.4.1.111.4.1.1.1.24 

oraDbSysWriteRequests 

1.3.6.1.4.1.111.4.1.1.1.25 

Table A-1 lists each variable of the oraDbSysTable and its corresponding object ID.

A description of each of these variables follows.

oraDbSysConsistentChanges

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for CONSISTENT CHANGES in V$SYSSTAT. It is incremented each time that a consistent get operation cannot accept the block in its current state, owing to a change made since the query consistency point.

oraDbSysConsistentChanges is used to calculate the following database instance performance ratio: the consistent change ratio.

Typical Range

two or more orders of magnitude less than the value of oraDbSysConsistentGets

Significance

important

Related Variables

oraDbSysConsistentGets

Suggested Presentation

counter

oraDbSysConsistentGets

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for CONSISTENT GETS in V$SYSSTAT. This value is incremented each time that the Oracle Buffer Manager is requested to locate a database block as part of a read consistent operation (a query). Only if the requested block is not found in Oracle's Buffer Cache will consistent get result in physical I/O.

oraDbSysConsistentGets is used to calculate the following database instance performance ratios: block get rate, block visits per transaction, cache hit ratio, changed block ratio, and the consistent change ratio.

Typical Range

0 - 4294967295; can increment at several thousand per second in the largest systems, so this variable is definitely a "wraparound" candidate

Significance

very important

Related Variables

oraDbSysUserCommits, oraDbSysConsistentChanges, oraDbSysPhysReads, oraDbSysDbBlockChanges, oraDbSysDbBlockGets

Suggested Presentation

counter

oraDbSysDbBlockChanges

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for DB BLOCK CHANGES in V$SYSSTAT. It is incremented each time that a database block is in memory to create a "dirty block." This statistic is a rough indication of total database work.

oraDbSysDbBlockChanges is used to calculate the following database instance performance ratios: block changes per transaction, and the changed block ratio.

Typical Range

0 - 4294967295; can increment at several thousand per second in the largest systems, so this variable is definitely a "wraparound" candidate; value tends to be lower than that for oraDbSysConsistentGets

Significance

one of the lesser measures of work rate or throughput

Related Variables

oraDbSysBlockGets, oraDbSysConsistentGets, oraDbSysUserCalls

Suggested Presentation

counter

oraDbSysDbBlockGets

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for DB BLOCK GETS in V$SYSSTAT. It is incremented each time the buffer manager is asked for a database block in current mode, that is, regardless of read consistency. This mode is used to locate blocks which are to be updated, and also to access control information such as segment headers. Only if the requested block is not found in Oracle's Buffer cache will a db block get result in physical I/O.

oraDbSysBlockGets is used to calculate the following database instance performance ratios: block get rate, block visits per transaction, the cache hit ratio, and the changed block ratio.

Typical Range

0 - 4294967295; can increment at several thousand per second in the largest systems, so this variable is definitely a "wraparound" candidate.

Significance

very important

Related Variables

oraDbSysDbBlockChanges, oraDbSysConsistentGets, oraDbSysPhysReads, oraDbSysUserCalls

Suggested Presentation

counter

oraDbSysFreeBufferInspected

Syntax

Counter32

Max-Access

read-only

Explanation

The "free buffer inspected" parameter from V$SYSTAT.

Typical Range

0 - 4294967295

Significance

This indicates the number of reusable buffers skipped over from the end of the Least Recently Used (LRU) queue in order to find a buffer. The difference between this and "dirty buffers inspected" equals the number of buffers that could not be used beause they were busy or needed to be written after rapid aging out. They may have a user, a waiter, or be being read or written.

Related Variables

oraDbSysFreeBufferRequested

Suggested Presentation

counter

oraDbSysFreeBufferRequested

Syntax

Counter32

Max-Access

read-only

Explanation

The "free buffer requested" parameter from V$SYSTAT.

Typical Range

0 - 4294967295

Significance

This is the count of the number of times a free buffer was requested to create or load a block.

Related Variables

oraDbSysFreeBufferInspected

Suggested Presentation

counter

oraDbSysParseCount

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for PARSE COUNT(total) in V$SYSSTAT. It counts the number of parse calls received by the RDBMS from both connected applications and recursive calls. In Oracle7 and Oracle8, parse calls are frequently satisfied by reference to the Shared SQL area and this statistic does not measure the number of parses which have taken place, only the number of calls.

oraDbSysParseCount is used to calculate the following database instance performance ratio: user calls per parse.

Typical Range

0 - 4294967295; unlikely to increment at a rate greater than a few hundred per second

Significance

important

Related Variables

oraDbLibraryCacheTable variables, oraDbSysUserCalls

Suggested Presentation

counter

oraDbSysPhysReads

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for PHYSICAL READS in V$SYSSTAT. It increments each time a DB Block is retrieved from the disk subsystem, but is not necessarily equal to the number of I/O requests made to the host operating system, as multiblock I/O may be used. A physical read can be viewed as an SGA Buffer Cache miss, hampering throughput (contention induction) and CPU (code pathlength) processing.

oraDbSysPhysReads is used to calculate the following database instance performance ratio: the cache hit ratio.

Typical Range

0 - 4294967295; unlikely to increment at a rate greater than a few hundred per second

Significance

very important

Related Variables

oraDbSysConsistentGets, oraDbSysDbBlockGets

Suggested Presentation

counter

oraDbSysPhysWrites

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for PHYSICAL WRITES in V$SYSSTAT. It increments each time a DB Block is written to disk. All writes are performed either by DBWR or LGWR, two background processes responsible for getting Blocks out of the SGA and back on disk.

Typical Range

0 - 4294967295; can increment at several thousand per second in the largest systems, so this variable is definitely a "wraparound" candidate

Significance

important

Related Variables

oraDbSysRedo family

Suggested Presentation

counter

oraDbSysRedoEntries

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for REDO ENTRIES in V$SYSSTAT. Each time that REDO data is copied into the log buffer, this counter is incremented. The value varies in relation to how many changes are being made.

oraDbSysRedoEntries is used to calculate the following database instance performance ratio: redo log space wait ratio.

Typical Range

0 - 4294967295; can increment at several thousand per second in the largest systems, so this variable is definitely a "wraparound" candidate.

Significance

important

Related Variables

oraDbSysRedoLogSpaceRequests, oraDbSysRedoSyncWrites, oraDbSysUserCommits

Suggested Presentation

counter

oraDbSysRedoLogSpaceRequests

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for REDO LOG SPACE REQUESTS in V$SYSSTAT. This counts the number of times that a server process had to wait to acquire an entry in the redo log.

oraDbSysRedoLogSpaceRequests is used to calculate the following database instance performance ratios: redo log space wait ratio.

Typical Range

0 - 10,000,000 (a value of 0 is ideal, but an increment of 1 or 2 per second might be acceptable)

Significance

important

Related Variables

oraDbSysRedoEntries

Suggested Presentation

counter

oraDbSysRedoSyncWrites

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for REDO SYNC WRITES parameter in V$SYSSTAT. It increments when a process waits for a ReDo write to complete, typically as a result of a Commit.

Typical Range

0 - 10,000,000 (typically increments at less than 1 per second)

Significance

less important

Related Variables

oraDbSysRedoEntries, oraDbSysRedoLogSpaceRequest, oraDbSysUserCommits

Suggested Presentation

counter

oraDbSysSortsDisk

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for SORTS DISKS in V$SYSSTAT. It increments for each sort which has to allocate disk work space.

oraDbSysSortsDisks is used to calculate the following database instance performance ratio: the sort overflow ratio.

Typical Range

for OLTP it should be 0

Significance

important

Related Variables

oraDbSysRedoEntries, oraDbSysRedoLogSpaceRequest, oraDbSyncWrites, oraDbSysSortsMemory, oraDbUserCommits

Suggested Presentation

counter

oraDbSysSortsMemory

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for SORTS MEMORY in V$SYSSTAT. It is incremented for each sort which does not require the allocation of work space on disk.

oraDbSysSortsMemory is used to calculate the following database instance performance ratio: the sort overflow ratio.

Typical Range

0 - 4294967295; unlikely to increment faster than tens per second, except in the largest systems

Significance

important

Related Variables

oraDbSysRedoEntries, oraDbSysRedoLogSpaceRequest, oraDbSyncWrites, oraDbSysSortsDisks, oraDbUserCommits

Suggested Presentation

counter

oraDbSysSortsRows

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for SORTS ROWS in V$SYSSTAT. It is incremented for each sort, regardless of whether the allocation of disk space was required.

Typical Range

0 - 4294967295

Significance

important

Related Variables

oraDbSysRedoEntries, oraDbSysRedoLogSpaceRequest, oraDbSyncWrites, oraDbSysSortsMemory, oraDbSortsDisks, oraDbUserCommits

Suggested Presentation

counter

oraDbSysTableFetchRowid

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE FETCH BY ROWID in V$SYSSTAT. This counter increments when a row is fetched using a RowID (usually recovered from an index). It should be noted that this statistic records all rows visited by the database engine, whether or not they were return to the application.

oraDbSysTableFetchRowid is used to calculate the following database instance performance ratios: the continued row ratio and the row source ratio.

Typical Range

0 - 4294967295; can increment at several tens of thousands per second in the largest systems, so this variable is definitely a "wraparound" candidate

Significance

important

Related Variables

oraDbSysRedoEntries, oraDbSysRedoLogSpaceRequest, oraDbSyncWrites, oraDbSysSortsDisks, oraDbSysTableFetchContinuedRow, oraDbSysTableScanRows, oraDbUserCommits

Suggested Presentation

counter

oraDbSysTableFetchContinuedRow

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE FETCH CONTINUED ROW in V$SYSSTAT. It may be incremented either because a row has been encountered which spans more than a DB block, or because a migrated row has been retrieved by rowid.

oraDbSysTableFetchContinuedRow is used to calculate the following database instance performance ratio: the continued row ratio.

Typical Range

close to 0 unless long LONG values are in use.

Significance

important

Related Variables

oraDbSysTable FetchRowid, oraDbSysTableScanRows

Suggested Presentation

counter

oraDbSysTableScanBlocks

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE SCAN BLOCKS GOTTEN in V$SYSSTAT. During scanning operations, the RDBMS retrieves each row sequentially. This counter increments each time the RDBMS steps into a new DB Block during the scan. oraDbSysTableScanBlocks indicates how many DB Blocks were Consistently Read from the Buffer Cache for the purpose of scanning. Comparing this to the value of oraDbSysConsistentGets suggests how much Consistent Read activity can be attributed to scanning.

Typical Range

0 - 3 billion; in OLTP very low; in DSS applications, a few thousand per second, so this variable is definitely a "wraparound" candidate.


Significance

important

Related Variables

oraDbSysConsistentGets

Suggested Presentation

counter

oraDbSysTableScanRows

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE SCAN ROWS GOTTEN in V$SYSSTAT. This counter increases each time a row is processed during a Scan operation. Note that the row need not be parsed back to the calling application in order for it to be counted here.

oraDbSysTableScanRows is used to calculate the following database instance performance ratio: the row source ratio, and the continued row ratio.

Typical Range

0 - 100,000,000 per day

Significance

important

Related Variables

oraDbSysTableFetchContinuedRow, oraDbSysTableFetchRowid

Suggested Presentation

counter

oraDbSysTableScansLong

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE SCANS LONG TABLES in V$SYSSTAT. Long tables are those whose number of data blocks below the high water mark exceeds the value of the initialization parameter SMALL _TABLE_THRESHOLD. DB Blocks visited in Long Full Table Scans are not prompted in the LRS List.

Typical Range

in OLTP, typically 0

Significance

important

Related Variables

oraDbSysTableScansShort

Suggested Presentation

counter

oraDbSysTableScansShort

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for TABLE SCANS SHORT TABLES in V$SYSSTAT. Short tables can be defined as tables that do not meet the long table criteria, as defined by oraDbSysTableScansLong. Short tables are those whose number of data blocks above the low water mark is low than the value of the initialization parameter LONG_TABLE_THRESHOLD.

Typical Range

0 - 4294967295; can increment at a few hundred per second

Significance

important

Related Variables

oraDbSysTableScansLong

Suggested Presentation

counter

oraDbSysUserCalls

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for USER CALLS in V$SYSSTAT. A user call is a Parse, an Execute, or a Fetch. With the Oracle server's deferred and bundled execution capabilities, this statistic will not necessarily correlate well with client/server message traffic.

oraDbSysUserCalls is used to calculate the following database instance performance ratios: block changes per transaction, the call rate, calls per transaction, the recursive-to-user call ratio, the user call rate, and user calls per parse.

Typical Range

0 - 10,000,000 per day

Significance

very important

Related Variables

oraDbSysDbBlockChanges, oraDbSysParseCount, oraDbSysRecursiveCalls, oraDbSysUserCommits

Suggested Presentation

counter

oraDbSysUserCommits

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for USER COMMITS in V$SYSSTAT. It records the number of database transactions successfully completed and records the number of aborted database transactions.

oraDbSysUserCommits is used to calculate the following database instance performance ratios: block visits per transaction, calls per transaction, and the transaction rate.

Typical Range

In most real world applications, the value is less the 1 per second.

Significance

In OLTP, very important

Related Variables

oraDbBlockGets, oraDbSysConsistentGets, oraDbUserCalls

Suggested Presentation

counter

oraDbSysUserRollbacks

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for USER ROLLBACKS in V$SYSSTAT. It records the number of aborted database transactions.

oraDbSysUserRollbacks is used to calculate the following database instance performance ratio: the user rollback ratio.

Typical Range

0 - 4294967295

Significance

important

Related Variables

oraDbSysUserCommits

Suggested Presentation

counter

oraDbSysWriteRequests

Syntax

Counter32

Max-Access

read-only

Explanation

This variable is retrieved directly from the value for WRITE REQUESTS in V$SYSSTAT. It records the number of write requests made to the host operating system.

Typical Range

0 - 4294967295; unlikely to increment at a rate greater than a few hundred per second

Significance

less important

Related Variables

oraDbSysPhysWrites

Suggested Presentation

counter

oraDbTablespaceTable

The oraDbTablespaceTable contains information on tablespaces within a current Oracle database instance. A tablespace is a logical portion of an Oracle database used to allocate storage for table and index data. In a production environment, tables can fill up as transaction activity mounts. Monitoring tablespace activity is important to avoid exhausting the tablespaces and causing spaces.

Each entry in the oraDbTablespaceTable represents a given tablespace within a current database instance. Each entry is indexed first by rdbmsDbIndex, and then oraDbTablespaceIndex; thus, there will normally be a one-to-many relationship between an rdbmsDbTable entry and corresponding oraDbTablespaceTable entries. (For details about rdbmsDbIndex, see Appendix D, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbTablespaceTable variable is retrieved directly from a join of DBA_TABLESPACES, DBA_DATA_FILES, and DBA_FREE_SPACE selecting for the tablespace in question.

Table A-2 lists each of these variables and its corresponding object.

Table A-2 oraDbTablespaceTable Variables and Corresponding Object IDs.
Variable Name  Object ID 
oraDbTablespaceIndex  1.3.6.1.4.1.111.4.1.2.1.1 
oraDbTablespaceName  1.3.6.1.4.1.111.4.1.2.1.2 
oraDbTablespaceSizeAllocated  1.3.6.1.4.1.111.4.1.2.1.3 
oraDbTablespaceSizeUsed  1.3.6.1.4.1.111.4.1.2.1.4 
oraDbTablespaceState  1.3.6.1.4.1.111.4.1.2.1.5 
oraDbTablespaceLargestAvailableChunk  1.3.6.1.4.1.111.4.1.2.1.6 
oraDbTablespaceIndex

Syntax

INTEGER (1..2147483647)

Max-Access

not-accessible

Explanation

A numeric index, unique among tablespaces within a single Oracle database instance. This index is assigned to these tablespaces based on the alphabetical order of their names. On most platforms, a hard file limit of 1023 database files exists, so this number is the practical upper limit. Although some administrators prefer a one-to-one relationship between tablespaces and database files, multiple files can comprise a tablespace.

Typical Range

1 - 1,000

Significance

very important

Related Variables

oraDbTablespaceName, rdbmsDbIndex

Suggested Presentation

not applicable

oraDbTablespaceName

Syntax

DisplayString

Max-Access

read-only

Explanation

Indicates the name of this tablespace, as retrieved from the value for TABLESPACE-NAME in DBA_TABLESPACES.

Typical Range

0 - 30 characters

Significance

important

Related Variables

oraDbTablespaceIndex

Suggested Presentation

simple string

oraDbTablespaceSizeAllocated

Syntax

Integer32

Max-Access

read-only

Explanation

Indicates the amount of disk space (in kilobytes) allocated for this tablespace. This is the sum of the sizes of the data files associated with the tablespace.

Typical Range

0 - 10 gigabytes

Significance

important

Related Variables

oraDbTablespaceSizeUsed

Suggested Presentation

simple string

oraDbTablespaceSizeUsed

Syntax

Integer32

Max-Access

read-only

Explanation

Indicates the amount of disk space (in kilobytes) which is actually in use for storing data. This is the difference between the sum of the size of the datafiles associated with the tablespace and the sum of the size of the free spaces associated with the tablespace.

Typical Range

0 - value of oraDbTablespaceSizeAllocated
Significance

Very important

Related Variables

oraDbTablespaceSizeAllocated

Suggested Presentation

gauge

oraDbTablespaceState

Syntax

INTEGER (1) online (2) offline, or (3) invalid

Max-Access

read-only

Explanation

Indicates the current accessibility of this tablespace, as retrieved from the value for STATUS in DBA_TABLESPACES. If a tablespace is offline (2), then SQL statements cannot reference objects contained in the tablespace. An invalid (3) tablespace is one that has been dropped.

Typical Range

enumerated 1 - 3

Significance

very important

Related Variables

none

Suggested Presentation

simple string or icon

oraDbTablespaceLargestAvailableChunk

Syntax

Integer32

Max-Access

read-only

Explanation

Indicates the size (in kilobytes) of the largest contiguous set of free data blocks in the tablespace. This variable is retrieved directly from the value for NEXT_EXTENT in DBA_TABLES. If there is any object in the tablespace whose NEXT_EXTENT value is greater than the layout chunk, that object will be unable to expand. This might cause a major problem, or it might not matter.

Typical Range

Less than or equal to (oraDbTablespaceSizeAllocated minus oraDbTablespaceSizeUsed)

Significance

important

Related Variables

oraDbTablespaceSizeAllocated, oraDbTablespaceSizeUsed

Suggested Presentation

gauge

oraDbDataFileTable

oraDbDataFileTable contains information on the data files within a current database instance on the managed node. A data file denotes an area of disk allocated for database data. Monitoring data files is important for two reasons; first, to determine whether space in files is being exhausted, and second to determine O/S response time in accessing data on disk, especially on platforms where there is no other way to measure disk queue length.

Each entry in the oraDbDataFileTable represents a given data file within a current database instance on the node. Each entry is indexed first by rdbmsDbIndex, and then by oraDbDataFileIndex; thus, there will normally be a one-to-many relationship between an rdbmsDbTable entry and corresponding oraDbDataFileTable entries. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbDataFileTable variable is retrieved directly from a corresponding field in either V$FILESTAT or DBA_DATA_FILES for that data file within that database instance.

Table A-3 lists each variable of the oraDbDataFileTable and its corresponding object ID

Table A-3 oraDbDataFileTable Variables and Corresponding Object IDs.
Variable Name  Object ID 
oraDbDataFileIndex  1.3.6.1.4.1.111.4.1.3.1.1 
oraDbDataFileName  1.3.6.1.4.1.111.4.1.3.1.2 
oraDbDataFileSizeAllocated  1.3.6.1.4.1.111.4.1.3.1.3 
oraDbDataFileDiskReads  1.3.6.1.4.1.111.4.1.3.1.4 
oraDbDataFileDiskWrites  1.3.6.1.4.1.111.4.1.3.1.5 
oraDbDataFileDiskReadBlocks  1.3.6.1.4.1.111.4.1.3.1.6 
oraDbDataFileDiskWrittenBlocks  1.3.6.1.4.1.111.4.1.3.1.7 
oraDbDataFileDiskReadTimeTicks  1.3.6.1.4.1.111.4.1.3.1.8 
oraDbDataFileDiskWriteTimeTicks  1.3.6.1.4.1.111.4.1.3.1.9 

oraDbDataFileIndex

Syntax

INTEGER (1..214748364)

Max-Access

not-accessible

Explanation

A numeric index, unique among data files associated with a single tablespace. The value of oraDbDataFileIndex is retrieved directly from the value of FILE_ID in DBA_DATA_FILES. For a small database, a tablespace typically contains 1 data file; for a large database (80 Gbytes), a tablespace typically contains 200 datafiles in a tablespace. The upper limit is hard coded as 1023.

Typical Range

1 - 400

Significance

very important

Related Variables

rdbmsDbIndex

Suggested Presentation

not applicable

oraDbDataFileName

Syntax

DisplayString

Max-Access

read-only

Explanation

Indicates the fully-qualified name of this data file. The value is retrieved from the value of FILE_NAME in DBA_DATA_FILES.

Typical Range

10 - 100 characters; about 15 for raw partitions.

Significance

important

Related Variables

oraDbTablespaceName, because the file is a member of a tablespace.

Suggested Presentation

simple string

oraDbDataFileSizeAllocated

Syntax

Integer32

Max-Access

read-only

Explanation

Indicates the allocated size (in kilobytes) of this data file, as retrieved from the value of BYTES in DBA_DATA_FILES. Indicates how much space has been used so far. Monitoring this variable is very important, because running out of space can require taking the database down, depending on which table this file supports. Normally, however, adding another data file to the Tablespace solves the problem.

Typical Range

100 Mbytes - 2 Gbytes

Significance

very important

Related Variables

none

Suggested Presentation

simple string

oraDbDataFileDiskReads

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of reads issued against this data file since database instance startup, as retrieved from the value of PHYRDS in V$FILESTAT.

Typical Range

10,000 - 100,000 or much more, depending on the life of the instance

Significance

less important

Related Variables

oraDbDataFileDiskReadBlocks, oraDbDataFileDiskReadTimeTicks

Suggested Presentation

counter

oraDbDataFileDiskWrites

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of writes issued against this data file since database instance startup, as retrieved from the value of PHYWRTS in V$FILESTAT.

Typical Range

10,000 - 100,000 or much more, depending on the life of the instance

Significance

less important

Related Variables

oraDbDataFileDiskWriteBlocks, oraDbDataFileDiskWriteTimeTicks

Suggested Presentation

counter

oraDbDataFileDiskReadBlocks

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of physical blocks read from this data file since database instance startup. The value is retrieved from the value of PHYBLKRD in V$FILESTAT. The number of bytes read can be determined by multiplying this value by the value of oraDbConfigDbBlockSize, typically 2Kbytes.

Typical Range

10,000 - 100,000 or much more, depending on the life of the instance

Significance

important

Related Variables

oraDbConfigDbBlockSize, oraDbDataFileDiskReads

Suggested Presentation

counter

oraDbDataFileDiskWrittenBlocks

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the total number of physical blocks written to this data file since database instance startup. The value is retrieved from the value of PHYBLKWRT in V$FILESTAT. The number of bytes written can be determined by multiplying this value by the value of the INIT.ORA parameter, DB_BLOCK_SIZE, typically 2Kbytes.

Typical Range

10,000 - 100,000 or much more, depending on the life of the instance

Significance

important

Related Variables

oraDbDataFileDiskWrites

Suggested Presentation

counter

oraDbDataFileDiskReadTimeTicks

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the time spent writing to this data file since database instance startup IF the INIT.ORA parameter TIMED_STATISTICS is TRUE. (The unit of measurement on a UNIX platform is time ticks of 10 ms.) If TIMED_STATISTICS is FALSE, then a value of 0 is returned. The value of oraDbDataFileDiskReadTimeTicks is retrieved from the value of READTIM in V$FILESTAT.

Because knowing how long it takes to perform I/O per block is the important statistic, knowing this aggregate measure is not very significant. If the average time to do reads is generally exceeding a couple of ticks, then an I/O sybsystem response time problem exists. Most high performance disk drives can easily locate any sector on the disk in 10 ms.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

oraDbDataFileDiskReads

Suggested Presentation

clock

oraDbDataFileDiskWriteTimeTicks

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the time spent writing to this data file since database instance startup IF the INIT.ORA parameter TIMED_STATISTICS is TRUE. (The unit of measurement on a UNIX platform is time ticks of 10 ms.) If TIMED_STATISTICS is FALSE, then a value of 0 is returned. The value of oraDbDataFileDiskWriteTimeTicks is retrieved from the value of WRITETIM in V$FILESTAT.

Because knowing how long it takes to perform I/O per block is the important statistic, knowing this aggregate measure is not very significant. If the average time to do writes is generally exceeding three ticks on non-mirrored data, then an I/O subsystem response time problem exists. Most high performance disk drives can easily perform a write in 15 ms.

Typical Range

Can wrap around the upper limit of 2147483647 in about three days of continuous instance operation for a busy database

Significance

less important

Related Variables

oraDbDataFileDiskWrites

Suggested Presentation

clock

oraDbLibraryCacheTable

The oraDbLibraryCacheTable contains variables measuring library cache activity since the most recent database instance startup. A library cache is a memory structure containing shared SQL and PL/SQL areas. Monitoring the library cache is important to determine whether it is necessary to resize Oracle's shared pool.

Each entry in the oraDbLibraryCacheTable represents a given library cache within a current database instance on the node. Each entry is indexed first by rdbmsDbIndex, and then by oraDbLibraryCacheIndex; thus, there will normally be a one-to-many relationship between an rdbmsDbTable entry and corresponding oraDbLibraryCacheTable entries. (For details about rdbmsDbIndex, see Appendix E, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbLibraryCacheTable variable is retrieved directly from a corresponding field in the V$LIBRARYCACHE table for that library cache within that database instance.

Table A-4 lists each variable of the oraDbLibraryCacheTable and its corresponding object ID.

Table A-4 oraDbLibraryCacheTable Variables and Corresponding Object IDs
Variable Name  Object ID 

oraDbLibraryCacheIndex 

1.3.6.1.4.1.111.4.1.4.1.1 

oraDbLibraryCacheNameSpace 

1.3.6.1.4.1.111.4.1.4.1.2 

oraDbLibraryCacheGets 

1.3.6.1.4.1.111.4.1.4.1.3 

oraDbLibraryCacheGetHits 

1.3.6.1.4.1.111.4.1.4.1.4 

oraDbLibraryCachePins 

1.3.6.1.4.1.111.4.1.4.1.5 

oraDbLibraryCachePinHits 

1.3.6.1.4.1.111.4.1.4.1.6 

oraDbLibraryCacheReloads 

1.3.6.1.4.1.111.4.1.4.1.7 

oraDbLibraryCacheInvalidations 

1.3.6.1.4.1.111.4.1.4.1.8 

oraDbLibraryCacheIndex

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

A unique integer for each row of the oraDbLibraryCacheTable.

Typical Range

8 (only)

Significance

very important

Related Variables

oraDbLibraryCacheNameSpace

Suggested Presentation

not applicable

oraDbLibraryCacheNameSpace

Syntax

DisplayString

Max-Access

read-only

Explanation

Indicates the namespace of the V$LIBRARYCACHE table to which this row is related. The value is retrieved from the value of NAMESPACE in V$LIBRARYCACHE.

Typical Range

0 - 30 characters

Significance

important

Related Variables

oraDbLibraryCacheIndex

Suggested Presentation

simple string

oraDbLibraryCacheGets

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the system requests handles to library objects in this namespace. The value of oraDbLibraryCacheGets is retrieved from the value of GETS in V$LIBRARYCACHE.

Typical Range

0 - 500,00 per day

Significance

important

Related Variables

oraDbLibraryCacheGetHits

Suggested Presentation

counter

oraDbLibraryCacheGetHits

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the handles are already allocated in the cache. The value of oraDbLibraryCacheGetHits is retrieved from the value of GETHITS in V$LIBRARYCACHE.


Typical Range

0 - 4294967295

Significance

less important

Related Variables

oraDbLibraryCacheGets

Suggested Presentation

counter

oraDbLibraryCachePins

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the system issues pin requests in order to access objects in the cache. The value of oraDbLibraryCachePins is retrieved from the value of PINS in V$LIBRARYCACHE.

oraDbLibraryCachePins is used to calculate the following database instance performance ratio: library cache miss ratio.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

oraDbLibraryPinHits, oraDbLibraryCacheReloads

Suggested Presentation

counter

oraDbLibraryCachePinHits

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the objects the system is pinning are already allocated and initialized in the cache. The value of oraDbLibraryCachePinHits is retrieved from the value of PINHITS in V$LIBRARYCACHE.

Typical Range

0 - 4294967295

Significance

important

Related Variables

oraDbLibraryCachePins

Suggested Presentation

counter

oraDbLibraryCacheReloads

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated. The value of oraDbLibraryCacheReloads is retrieved from the value of RELOADS in V$LIBRARYCACHE.

oraDbLibraryCacheReloads is used to calculate the following database instance performance ratio: library cache miss ratio.

Typical Range

0 - 4294967295

Significance

important

Related Variables

oraDbLibraryCachePins

Suggested Presentation

counter

oraDbLibraryCacheInvalidations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that non-persistent library objects (like shared SQL areas) have been invalidated. The value of oraDbLibraryCacheInvalidations is retrieved from the value of INVALIDATIONS in V$LIBRARYCACHE.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

none

Suggested Presentation

counter

oraDbLibraryCacheSumTable

The LibraryCacheSum table tracks for all library caches in a database instance as a whole the same information that the LibraryCache table tracks for the caches individually. It is primarily a convenience.

Table A-5 oraDBLibraryCacheSum Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraDbLibraryCacheSumGets 

1.3.6.1.4.1.111.4.1.5.1.1 

oraDbLibraryCacheSumGetHits 

1.3.6.1.4.1.111.4.1.5.1.2 

oraDbLibraryCacheSumPins 

1.3.6.1.4.1.111.4.1.5.1.3 

oraDbLibraryCacheSumPinHits 

1.3.6.1.4.1.111.4.1.5.1.4 

oraDbLibraryCacheSumReloads 

1.3.6.1.4.1.111.4.1.5.1.5 

oraDbLibraryCacheSumInvalidations 

1.3.6.1.4.1.111.4.1.5.1.6 

oraDbLibraryCacheSumGets

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the system requests handles to library objects in this namespace. The value of oraDbLibraryCacheSumGets is derived from the value of GETS in V$LIBRARYCACHE.

Typical Range

0 - 500,00 per day

Significance

important

Related Variables

oraDbLibraryCacheSumGetHits

Suggested Presentation

counter

oraDbLibraryCacheSumGetHits

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the handles are already allocated in the cache. The value of oraDbLibraryCacheSumGetHits is derived from the value of GETHITS in V$LIBRARYCACHE.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

oraDbLibraryCacheSumGets

Suggested Presentation

counter

oraDbLibraryCacheSumPins

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the system issues pin requests in order to access objects in the cache. The value of oraDbLibraryCacheSumPins is derived from the value of PINS in V$LIBRARYCACHE.

oraDbLibraryCacheSumPins is used to calculate the following database instance performance ratio: library cache miss ratio.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

oraDbLibraryPinHits, oraDbLibraryCacheSumReloads

Suggested Presentation

counter

oraDbLibraryCacheSumPinHits

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that the objects the system is pinning are already allocated and initialized in the cache. The value of oraDbLibraryCacheSumPinHits is derived from the value of PINHITS in V$LIBRARYCACHE.

Typical Range

0 - 4294967295

Signifcance

important

Related Variables

oraDbLibraryCacheSumPins

Suggested Presentation

counter

oraDbLibraryCacheSumReloads

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that library objects have to be reinitialized and reloaded with data because they have been aged out or invalidated. The value of oraDbLibraryCacheSumReloads is derived from the value of RELOADS in V$LIBRARYCACHE.

oraDbLibraryCacheSumReloads is used to calculate the following database instance performance ratio: library cache miss ratio.

Typical Range

0 - 4294967295

Significance

important

Related Variables

oraDbLibraryCacheSumPins

Suggested Presentation

counter

oraDbLibraryCacheSumInvalidations

Syntax

Counter32

Max-Access

read-only

Explanation

Indicates the number of times, since database instance startup, that non-persistent library objects (like shared SQL areas) have been invalidated. The value of oraDbLibraryCacheSumInvalidations is derived from the value of INVALIDATIONS in V$LIBRARYCACHE.

Typical Range

0 - 4294967295

Significance

less important

Related Variables

none

Suggested Presentation

counter

oraDbSGATable

The oraDbSGATable contains storage allocation information on the current System Global Area (SGA). The SGA is a common database storage area for information that supports current sessions. As the values of its attributes are configured in the INIT.ORA file, they do not change while the database instance is running, thus, the SGA at this aggregate level is not as important to monitor as other database structures.

Each entry in the oraDbSGATable represents the SGA for a current database instance on the node. Each entry is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each installed database configured for SNMP support, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. (For details about rdbmsDbIndex, see Appendix D, "Interpreting Variables of the Public RDBMS MIB.") The current value of each oraDbSGATable variable is retrieved directly from a corresponding field in the V$SGA table for that database instance.

Table A-6 lists each variable of the oraDbSGATable and its corresponding object ID.

Table A-6 oraDbSGATable Variables and Corresponding Object IDs
Variable Name  Object ID 

oraDbSGAFixedSize 

1.3.6.1.4.1.111.4.1.6.1.1 

oraDbSGAVariableSize 

1.3.6.1.4.1.111.4.1.6.1.2 

oraDbSGADatabaseBuffers 

1.3.6.1.4.1.111.4.1.6.1.3 

oraDbSGARedoBuffers 

1.3.6.1.4.1.111.4.1.6.1.4 

oraDbSGAFixedSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The size in kilobytes of the fixed-size portion of the SGA as shown in V$SGASTAT.

Typical Range

1 - 2147483647

Significance

less important

Related Variables

oraDbSGAVariableSize

Suggested Presentation

as a simple integer value

oraDbSGAVariableSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The size in kilobytes of the variable-size portion of the SGA as shown in V$SGASTAT.

Typical Range

1 - 2147483647


Significance

less important

Related Variables

oraDbSGAFixedSize

Suggested Presentation

as a simple integer value

oraDbSGADatabaseBuffers

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The number of database buffers allocated in the SGA as shown in V$SGASTAT.

Typical Range

4 Kbytes - 2 Gbytes

Significance

less important

Related Variables

oraDbSGARedoBuffers

Suggested Presentation

as a simple integer value

oraDbSGARedoBuffers

Syntax

INTEGER (1..2147483647)

Max-Access

read-write

Explanation

The number of redo buffers allocated in the SGA as shown in V$SGASTAT.

Typical Range

1 - 2147483647

Significance

less important

Related Variables

oraDbSGADatabaseBuffers

Suggested Presentation

as a simple integer value

oraDbConfigTable

The oraDbConfigTable contains variables whose values are retrieved directly from the V$PARAMETER table. These parameters control systemwide resources and can impact the values of variables in the rest of this MIB. This table includes those initialization parameters that closely relate to the task of monitoring database instance performance. By assigning these parameters easy-to-use, fixed object IDs, it is easier to graph them together with the dynamic performance values they impact. For more information on these parameters, see the ORACLE Server Reference, and also the ORACLE Server Concepts Manual specific to your system.

Each entry in the oraDbConfigTable is indexed by rdbmsDbIndex. However, because rdbmsDbTable contains an entry for each installed database, whether or not it is actively open, there may or may not be a one-to-one correspondence between entries in the two tables at any point in time. (For details about rdbmsDbIndex, see Appendix D, "Interpreting Variables of the Public RDBMS MIB.")

Table A-7 lists each variable of the oraDbConfigTable and its corresponding object ID

Table A-7 oraDbConfigTable Variables and Corresponding Object IDs
Variable Name  Object ID 

oraDbConfigDbBlockBuffers 

1.3.6.1.4.1.111.4.1.7.1.1 

oraDbConfigDbBlockCkptBatch 

1.3.6.1.4.1.111.4.1.7.1.2 

oraDbConfigDbBlockSize 

1.3.6.1.4.1.111.4.1.7.1.3 

oraDbConfigDbFileSimWrites 

1.3.6.1.4.1.111.4.1.7.1.4 

oraDbConfigDbMultiBlockReadCount 

1.3.6.1.4.1.111.4.1.7.1.5 

oraDbConfigDbWriters 

1.3.6.1.4.1.111.4.1.7.1.6 

oraDbConfigDistLockTimeout 

1.3.6.1.4.1.111.4.1.7.1.7 

oraDbConfigDistRecoveryConnectHold 

1.3.6.1.4.1.111.4.1.7.1.8 

oraDbConfigDistTransactions 

1.3.6.1.4.1.111.4.1.7.1.9 

oraDbConfigLogArchiveBufferSize 

1.3.6.1.4.1.111.4.1.7.1.10 

oraDbConfigLogArchiveBuffers 

1.3.6.1.4.1.111.4.1.7.1.11 

oraDbConfigLogBuffer 

1.3.6.1.4.1.111.4.1.7.1.12 

oraDbConfigLogCheckpointInteval 

1.3.6.1.4.1.111.4.1.7.1.13 

oraDbConfigLogCheckpointTimeout 

1.3.6.1.4.1.111.4.1.7.1.14 

oraDbConfigLogFiles 

1.3.6.1.4.1.111.4.1.7.1.15 

oraDbConfigLogSmallEntryMax 

1.3.6.1.4.1.111.4.1.7.1.16 

oraDbConfigMaxRollbackSegments 

1.3.6.1.4.1.111.4.1.7.1.17 

oraDbConfigMaxDispatchers 

1.3.6.1.4.1.111.4.1.7.1.18 

oraDbConfigMTSMaxServers 

1.3.6.1.4.1.111.4.1.7.1.19 

oraDbConfigMTSServers 

1.3.6.1.4.1.111.4.1.7.1.20 

oraDbConfigOpenCursors 

1.3.6.1.4.1.111.4.1.7.1.21 

oraDbConfigOpenLinks 

1.3.6.1.4.1.111.4.1.7.1.22 

oraDbConfigOptimizerMode 

1.3.6.1.4.1.111.4.1.7.1.23 

oraDbConfigProcesses 

1.3.6.1.4.1.111.4.1.7.1.24 

oraDbConfigSerializable 

1.3.6.1.4.1.111.4.1.7.1.25 

oraDbConfigSessions 

1.3.6.1.4.1.111.4.1.7.1.26 

oraDbConfigSharedPool 

1.3.6.1.4.1.111.4.1.7.1.27 

oraDbConfigSortAreaSize 

1.3.6.1.4.1.111.4.1.7.1.28 

oraDbConfigSortAreaRetainedSize 

1.3.6.1.4.1.111.4.1.7.1.29 

oraDbConfigTransactions 

1.3.6.1.4.1.111.4.1.7.1.30 

oraDbConfigTransactionsPerRollback 

1.3.6.1.4.1.111.4.1.7.1.31 

oraDbConfigDbBlockBuffers

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DB_BLOCK_BUFFERS parameter of the INIT.ORA file. Indicates the number of database blocks cached in memory of the SGA. This parameter is the most significant determinant of the SGA size and database instance performance. The size of each block can be determined using oraDbConfigDbBlockSize.

Typical Range

1 - 2147483647

Significance

very important

Related Variables

oraDbConfigDbBlockSize

Suggested Presentation

gauge or simple string

oraDbConfigDbBlockCkptBatch

Syntax

INTEGER (0..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DB_BLOCK_ CHECKPOINT_BATCH parameter of the INIT.ORA file. Indicates the maximum number of blocks that the DBWR process will write in one batch devoted to checkpoints.

Typical Range

0 - 2147483647

Significance

less important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigDbBlockSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DB_BLOCK_SIZE parameter of the INIT.ORA file. Indicates the size, in bytes, of database blocks for this database. This information has significance for a number of other variables.

Typical Range

1024 - 8192 (O/S dependent)

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigDbFileSimWrites

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DB_FILE_SIMULTANEOUS_WRITES parameter of the INIT.ORA file. Indicates the number of simultaneous writes (batches) for each database file when written by DBWR.

Typical Range

1 - 2147483647

Significance

less important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigDbMultiBlockReadCount

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DB_FILE_MULTIBLOCK_READ_COUNT parameter of the INIT.ORA file. Indicates the maximum number of blocks read in one I/O operation during a sequential scan. The default is a function of the DB_BLOCK_BUFFERS and PROCESSES parameters in the INIT.ORA file.

Typical Range

Values in the range of 4 to 32 are reasonable. Actual maximums vary by operating system

Significance

important

Related Variables

oraDbConfigDbBlockBuffers, oraDbConfigDbProcesses

Suggested Presentation

gauge or simple string

oraDbConfigDistLockTimeout

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DISTRIBUTED_LOCK_TIMEOUT parameter of the INIT.ORA file. Indicates the amount of time (in seconds) that distributed transactions must wait for locked resources.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

clock or simple string

oraDbConfigDistRecoveryConnectHold

Syntax

INTEGER (0..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DISTRIBUTED_ RECOVERY_CONNECTION_HOLD_ TIME parameter of the INIT.ORA file. Indicates the length of time (in seconds) to hold a remote connection open after a distributed transaction fails, in hopes that communication will be restored without having to reestablish the connection. Any value above 1800 means the connection never closes.

Typical Range

1 - 1800

Significance

important

Related Variables

none

Suggested Presentation

clock or simple string

oraDbConfigDistTransactions

Syntax

INTEGER (0..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the DISTRIBUTED_ TRANSACTIONS parameter of the INIT.ORA file. Indicates the maximum number of distributed transactions in which this database can concurrently participate.

Typical Range

0 - 2147483647

Significance

none

Related Variables

oraDbConfigDistTransactions

Suggested Presentation

gauge or simple string

oraDbConfigLogArchiveBufferSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_ARCHIVE_BUFFER_SIZE parameter of the INIT.ORA file. Indicates the size of each archival buffer, in redo log blocks (operating system blocks). The default should be adequate for most applications.

Typical Range

1 - 2147483647

Significance

less important

Related Variables

oraDbConfigLogArchiveBuffers, oraDbConfigLogBuffer

Suggested Presentation

gauge or simple string

oraDbConfigLogArchiveBuffers

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_ARCHIVE_BUFFERS parameter from the INIT.ORA file. Indicates the number of buffers allocated for archiving.

Typical Range

1 - 2147483647

Significance

important

Related Variables

oraDbConfigLogArchiveBufferSize, oraDbConfigLogBuffer

Suggested Presentation

gauge or simple string

oraDbConfigLogBuffer

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_BUFFER parameter of the INIT.ORA file. Indicates the number of bytes allocated to the redo log buffer in the SGA. In a busy system, a value of 65536 or higher would not be unreasonable.

Typical Range

1,000 - 100,000

Significance

important

Related Variables

oraDbConfigLogArchiveBuffers, oraDbConfigLogArchiveBufferSize

Suggested Presentation

gauge or simple string

oraDbConfigLogCheckpointInterval

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_CHECKPOINT_ INTERVAL parameter of the INIT.ORA file. Indicates the amount of time (in seconds) to pass before another checkpoint occurs. A value of 0 disables time-based checkpoints.

Typical Range

1 - 2147483647

Significance

important

Related Variables

oraDbConfigLogCheckpointTimeout

Suggested Presentation

clock or simple string

oraDbConfigLogCheckpointTimeout

Syntax

INTEGER (0..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_CHECKPOINT_TIMEOUT parameter of the INIT.ORA file. The amount of time (in seconds) to pass between checkpoints. A value of 0 disables time-based checkpoints.

Typical Range

0 - 2147483647

Significance

important

Related Variables

oraDbConfigLogCheckpointInterval

Suggested Presentation

clock or simple string

oraDbConfigLogFiles

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the LOG_FILES parameter of the INIT.ORA file. Indicates the maximum log group number. This value specifies the maximum number of redo log files that can be opened at database instance run time.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigMaxRollbackSegments

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the MAX_ROLLBACK_SEGMENTS parameter of the INIT.ORA file. Indicates the maximum size of the rollback segment cache in the SGA.

Typical Range

1 - 65536

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigMTSMaxDispatchers

Syntax

INTEGER (1..2147483647)

Explanation

The value of this variable is retrieved directly from the MTS_MAX_ DISPATCHERS parameter of the INIT.ORA file. Indicates the maximum number of dispatcher processes allowed to be running simultaneously.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigMTSMaxServers

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the MTS_MAX_SERVERS parameter of the INIT.ORA file. Indicates the maximum number of shared server processes allowed to be running simultaneously.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigMTSServers

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the MTS_SERVERS parameter of the INIT.ORA file. Indicates the number of server processes that are created when an instance is started.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigOpenCursors

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the OPEN_CURSORS parameter of the INIT.ORA file. Indicates the maximum number of open cursors (context areas) a single-user process can have at once.

Typical Range

1 - 2147483647

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigOpenLinks

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the OPEN_LINKS parameter of the INIT.ORA file. Indicates the maximum number of concurrent open connections to remote database instances per user process. This parameter refers only to connections used for distributed transactions; direct connections to a remote database instance specified as an application connects are not counted. If set to 0, then no distributed transactions are allowed.

Typical Range

0 - 255

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigOptimizerMode

Syntax

DisplayString

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the OPTIMIZER_MODE parameter of the INIT.ORA file. When set to RULE, this parameter causes rule-based optimization to be used, unless hints are specified in the query. When set to COST, the optimizer uses a cost-based approach for an SQL statement, if there are statistics in the dictionary for at least one table accessed in the statement. (Otherwise, the rule-based approach is used.)

Typical Range

RULE/COST

Significance

important

Related Variables

oraDbConfigSessions

Suggested Presentation

icon or simple string

oraDbConfigProcesses

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the PROCESSES parameter of the INIT.ORA file. For a multiple-process operation, this parameter specifies the maximum number of user processes that can simultaneously connect to an Oracle server. The PROCESSES parameter is used to derive the SESSIONS INIT.ORA parameter. The default is 50.

Typical Range

6 - O/S dependent

Significance

important

Related Variables

oraDbConfigSessions, oraDbConfigTransactions

Suggested Presentation

gauge or simple string

Suggested Presentation

gauge or simple string

oraDbConfigSerializable

Syntax

TruthValue

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the SERIALIZABLE parameter of the INIT.ORA file. A value of TRUE indicates that queries acquire table-level read locks, preventing any update of objects read until the transaction containing the query is committed.

Typical Range

true/false

Significance

important

Related Variables

none

Suggested Presentation

icon or simple string

oraDbConfigSessions

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the SESSIONS parameter of the INIT.ORA file. Indicates the total number of user and system sessions. The default for parameter is derived as the value of the INIT.ORA PROCESSES parameter multiplied by 1.1.

Typical Range

1 - 2147483647

Significance

important

Related Variables

oraDbConfigProcesses

Suggested Presentation

gauge or simple string

oraDbConfigSharedPool

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the SHARED_POOL_SIZE parameter of the INIT.ORA file. Indicates the size (in bytes) of the shared pool. The shared pool contains shared cursors and stored procedures. The default is 3.5 Mbytes.

Typical Range

300 Kbytes - O/S dependent

Significance

important

Related Variables

none

Suggested Presentation

gauge or simple string

oraDbConfigSortAreaSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the SORT_AREA_SIZE parameter of the INIT.ORA file. Indicates the maximum amount of PGA memory to use for an exterrnal (disk) sort (in bytes). The default (O/S dependent) is adequate for most DB operations.

Typical Range

1 - 2147483647

Significance

none

Related Variables

oraDbConfigRetainedSize, oraDbConfigSortSpaceMapSize

Suggested Presentation

gauge or simple string

oraDbConfigSortAreaRetainedSize

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the SORT_AREA_RETAINED_SIZE parameter of the INIT.ORA file. Indicates the maximum amount of session memory (in bytes) that will be used for an in-memory sort. The default value is equal to that assigned for the SORT_AREA_SIZE INIT.ORA parameter.

Typical Range

0..value of oraDbConfigSortAreaSize

Significance

important

Related Variables

oraConfigSortAreaSize

Suggested Presentation

gauge or simple string

oraDbConfigTransactions

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the TRANSACTIONS parameter of the INIT.ORA file. Indicates the maximum number of concurrent transactions. The default is the value of the PROCESSES INIT.ORA parameter multiplied by 1.1.

Typical Range

1 - 2147483647

Significance

important

Related Variables

oraDbConfigProcesses

Suggested Presentation

gauge or simple string

oraDbConfigTransactionsPerRollback

Syntax

INTEGER (1..2147483647)

Max-Access

read-only

Explanation

The value of this variable is retrieved directly from the TRANSACTIONS_PER_ROLLBACK_SEGMENT parameter of the INIT.ORA file. Indicates the number of concurrent transactions allowed per rollback segment. The default is 30.

Typical Range

1..O/S dependent

Significance

important

Related Variables

oraDbConfigTransactions

Suggested Presentation

gauge or simple string

oraRepTable

The oraRep Table contains general information about the replicated schemas in the current database. Besides providing a count of the number of schemas being replicated to remote sites, it reports problems with the current node. These problems include the inability to propagate or receive replicated data.

Table A-8 oraRep Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraRepPending2PhaseCommits 

1.3.6.1.4.1.111.4.3.1.1.1 

oraRepDisabledTriggers 

1.3.6.1.4.1.111.4.3.1.1.2 

oraRepInvalidPackages 

1.3.6.1.4.1.111.4.3.1.1.3 

oraRepSchemas 

1.3.6.1.4.1.111.4.3.1.1.4 

oraRepPending2PhaseCommits

Syntax

Gauge32

Max-Access

read-only

Explanation

This indicates the number of failed distributed transactions in a PREPARED state. Used for monitoring configurations where databases are communicating synchronously.

Typical Range

0

Significance

This indicates the number of distributed transactions that remain unresolved because of a failure during the commit process. It can help measure the impact of failures.

Related Variables

oraRepLinkErrors

Suggested Presentation

error indicator

oraRepDisabledTriggers

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of replication triggers that have been disabled. As triggers are the mechanism by which local changes are propogated to remote databases, disabled replication triggers cause databases in the replication environment to go out of sync.

Typical Range

0

Significance

Changes applied to replicated tales with a disabled replication trigger will not be propagated to remote sites.

Related Variables

oraRepInvalidPackages

Suggested Presentation

guage or error indicator (if >0)

oraRepInvalidPackages

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of replication packages that have been invalidated. As these packages are the mechanism by which remote changes are propogated to the local database, invalidated replication packages cause databases in the replication environment to go out of sync.

Typical Range

0

Significance

Invalid replication packages may cause transactions to build up in the error queue.

Related Variables

oraRepDisabledTriggers

Suggested Presentation

guage or error indicator (if >0)

oraRepSchemas

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of schemas at the local node that are involved in replication.

Typical Range

configuration dependent

Significance

The number of database schema invoved in replication at the local site.

Related Variables

oraRepSchemaName

Suggested Presentation

gauge or simple string

oraRepSchemaTable

The oraRepSchema Table contains information about the replicated database schemas at the current site. For each such replicated schema, there exists one instance of this table.

The values of these variables are retrieved directly from the replication catalog. The current replication environment's status (normal, quiescing, quiesced) and configuration (type of replication site and database link to remote replication sites) are useful for displaying a visual representation of the replication environment.

Table A-9 oraRepSchema Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraRepSchemaIndex 

1.3.6.1.4.1.111.4.3.2.1.1 

oraRepSchemaName 

1.3.6.1.4.1.111.4.3.2.1.2 

oraRepSchemaType 

1.3.6.1.4.1.111.4.3.2.1.3 

oraRepSchemaStatus 

1.3.6.1.4.1.111.4.3.2.1.4 

oraRepSchemaLinks 

1.3.6.1.4.1.111.4.3.2.1.5 

oraRepSchemaIndex

Syntax

INTEGER32

Max-Access

read-only

Explanation

This is a numeric index unique among replication schemas contained in this database.

Typical Range

not applicable

Significance

Provides a unique identifier for the schema.

Related Variables

none

Suggested Presentation

simple string

oraRepSchemaName

Syntax

DisplayString

Max-Access

read-only

Explanation

This is the name of the replicated schema. This name must be the same at all sites involved in the replication of the schema.

Typical Range

valid Oracle identifier

Significance

Identifies replicated schemas. Useful in displaying a visual representation of the replication environment.

Related Variables

oraRepSchemaType

Suggested Presentation

simple string

oraRepSchemaType

Syntax

INTEGER{masterdef(1), master(2), snapshot(3)}

Max-Access

read-only

Explanation

This indicates whether the replicated schema is a master definition schema, a master schema, or a snapshot schema.

Typical Range

not applicable

Significance

Most replication administration tasks can be performed only at the master definition sites.

Related Variables

oraRepSchemaName

Suggested Presentation

color indicator or simple string

oraRepSchemaStatus

Syntax

INTEGER{normal(1), quiescing(2), quiesced(3)}

Max-Access

read-only

Explanation

This indicates the state of the replicated schema. Replication activity is suspended in the quiesced state and the schema can then be altered.

Typical Range

1 - 3

Significance

The meanings of the values are as follows:

  1. Normal operational state of a replication environment.

  2. Replication activity is in the process of being suspended

  3. Replication activity has been disabled. This is usually done to perform administrative actions.

Snapshot sites are always in state 1 (normal).

Related Variables

oraRepSchemaType

Suggested Presentation

color indicator or simple string

oraRepSchemaLinks

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of database links used in the schema for replication.

Typical Range

configuration dependent

Significance

For masters there must be at least one database link from the local site to each remote master.

For snapshots there must be at least one database link from the snapshot site to its master.

Related Variables

oraRepLinkName

Suggested Presentation

simple string

oraRepMasterSchema Table

The oraRepMasterSchema Table contains specific information for replicated schemas at the current master or master definition site. There exists one instance of this table for each replicated schema at the current site. These values are retrieved from the replication catalog.

The values in this table are useful for displaying a visual representation of multi-master configurations. Master and master definition sites are not required to have database links to their snapshot sites. Snapshot schemas are currently not registered in the replication catalog at their associated master site. Given an oraRepMasterSchema Table in an arbitrary replication environment, it is not be possible to locate all snapshot sites based solely on the information in this table.

Information is also provided for the detection of replication administration request errors and a relative count of the number of conflicts encountered at the current site. The table provides a count of the number of resolved conflicts. Not all conflicts may be resolved (the DBA did not declare the appropriate conflict resolution method(s) or a conflict was unable to be resolved due to other problems.

Table A-10 oraRepMasterSchema Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraRepMasterSchemaRequestErrors 

1.3.6.1.4.1.111.4.3.3.1.1 

oraRepMasterSchemaResolvedConflicts 

1.3.6.1.4.1.111.4.3.3.1.2 

oraRepMasterSchemaOtherMasters 

1.3.6.1.4.1.111.4.3.3.1.3 

oraRepMasterSchemaRequestErrors

Syntax

Gauge32

Max-Access

read-only

Explanation

This indicates the number of administration requests that have encountered errors. The errors themselves are stored in the administration queue at the source database of the request.

Typical Range

0

Significance

If the variable is > 0, then 1 or more administration commands failed at 1 or more remote sites.

Related Variables

oraRepLinkAdminRequests

Suggested Presentation

gauge or warning indicator

oraRepMasterSchemaResolvedConflicts

Syntax

Gauge32

Max-Access

read-only

Explanation

This indicates the number of conflicts that were successfully resolved at the local database. For this variable to be valid, the DBA must activate statistics collection for conflict resolution.

Typical Range

configuration dependent

Significance

If the environment is configured to be conflict-free, this value always should be 0. Otherwise, this value gives the adminsdtrator a rough count of the conflicts that are occuring, although it is imprecise because it does not include any conflicts that have not been resolved.

Related Variables

none

Suggested Presentation

gauge or simple string

oraRepMasterSchemaOtherMasters

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of remote master databases involved in the replication of the schema.

Typical Range

configuration dependent

Significance

useful for displaying a map of the replication environment.

Related Variables

oraRepSchemaLinks

Suggested Presentation

simple string

oraRepSnapshotSchemaTable

The oraRepSnapshotSchema Table contains specific information for snapshot schemas at the current snapshot site. One instance of this table exists for each snapshot schema at the current site. These values are retrieved from the replication catalog.

The values in this table are useful for displaying a visual representation of Master- Snapshot configurations. Snapshot sites are required to have database links to their master sites, but a master site is not required to have database links to its associated snapshot sites.

Table A-11 oraRepSnapshotSchema Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraRepSnapshotSchemaMaster 

1.3.6.1.4.1.111.4.3.4.1.1 

oraRepSnapshotSchemaSnapshots 

1.3.6.1.4.1.111.4.3.4.1.2 

oraRepSnapshotSchemaMaster

Syntax

DisplayString

Max-Access

read-only

Explanation

This provides the name of the master database from which the snapshot schema is refreshed. A snapshot schema can be owned by only one master database at a time, but that ownership is dynamic.

Typical Range

valid Oracle identifier

Significance

useful for displaying a map of the replication environment.

Related Variables

oraRepLinkName

Suggested Presentation

simple string

oraRepSnapshotSchemaSnapshots

Syntax

INTEGER32

Max-Access

read-only

Explanation

This indicates the number of snapshots in the schema.

Typical Range

configuration dependent

Significance

Useful in displaying a visual representation of the replication environment.

Related Variables

Suggested Presentation

gauge or simple string

oraRepLinkTable

The oraRepLink Table contains information for each database link used for replication at the current site. One instance of this table exists for each database link used for replication at the current site. These values are retrieved from both the replication catalog and the Deferred RPC tables.

All information is reported on a per-database link basis. For example, oraRepLinkError counts all errors from the database link oraRepLinkName within the instance of the oraRepLink Table that identifies that link. This is also true for oraRepLinkDeferredTransactions and oraRepLinkAdminRequests.

Administration requests are only made from the master definition sites to remote master sites. Snapshot sites neither send nor receive replication administration requests.

Table A-12 oraRepLink Table Variables and Corresponding Object IDs
Variable Name  Object ID 

oraRepLinkIndex 

1.3.6.1.4.1.111.4.3.5.1.1 

oraRepLinkName 

1.3.6.1.4.1.111.4.3.5.1.2 

oraRepLinkDeferredTransactions 

1.3.6.1.4.1.111.4.3.5.1.3 

oraRepLinkErrors 

1.3.6.1.4.1.111.4.3.5.1.4 

oraRepLinkAdminRequests 

1.3.6.1.4.1.111.4.3.5.1.5 

oraRepLinkIndex

Syntax

INTEGER32

Max-Access

read-only

Explanation

This is a numeric index whose value is unique among the replication links associated with a particular schema.

Typical Range

not applicable

Significance

This provides a unique identifier for the link.

Related Variables

none

Suggested Presentation

simple string

oraRepLinkName

Syntax

DisplayString

Max-Access

read-only

Explanation

This provides the name of the database link.

Typical Range

valid Oracle database link name

Significance

This shows the destination to which transactions will be replicated.

Related Variables

none

Suggested Presentation
simple string

oraRepLinkDeferredTransactions

Syntax

Gauge32

Max-Access

read-only

Explanation

This is the number of deferred transactions queued for propagation to the destination of the dblink. The transactions in the queue are stored, organized by destination, at the database originating the transaction.

Typical Range

configuration dependent

Significance

As a general rule, there should not be a large backlog of queued transactions. A moderate queue size reduces poential problems with conflicts, integrity constraints, and cascading errors. This value is one measure of the cost of replication in terms of data traffic.

Related Variables

none

Suggested Presentation

gauge or simple string

oraRepLinkErrors

Syntax

Gauge32

Max-Access

read-only

Explanation

This is the number of errors at the local database that were caused by deferred transactions from the dblink in question. These errors are caused by incorrectly formed transactions or by conflicts. The errors in the queue are stored by source at the database at which the errors occurred.

Typical Range

0

Significance

Errors indicate unresolved conflicts or other problems with the replication environment (for example, replication users do not have the correct privileges or the database links were not created correctly).

Related Variables

none

Suggested Presentation

gauge or warning indicator

oraRepLinkAdminRequests

Syntax

Gauge32

Max-Access

read-only

Explanation

This is the number of administration requests queued for the local database from the dblink in question. The items in the queue are stored by the source of the requests.

Typical Range

configuration dependent

Significance

A large backlog of requests may indicate a problem in the background process which periodically pushes the queue. A gauge would be useful for displaying the percent completion of a single or of a set of adminstration requests (i.e., when the value reaches zero, all requests are complete)

Related Variables

none

Suggested Presentation

gauge or simple string


Go to previous page Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Product

Contents

Index