oraDbSysEntry

ORADB-MIB · .1.3.6.1.4.1.111.4.1.1.1
MIB view Table view

Object

row mandatory 
Selected info from the v$sysstat table on instance performance.
Variables are included here
because they have been found particularly useful in 
tuning an Oracle instance.  In many cases, the variable should
only be considered in conjunction with other variables, often
as a ratio.  Frequently, hints on these are given in the 
descriptions, but Oracle tuning documentation should always
be consulted, particularly the Oracle University course on 
tuning V7 applications.

Context

MIB
ORADB-MIB
OID
.1.3.6.1.4.1.111.4.1.1.1
Type
row
Status
mandatory
Parent
oraDbSysTable
Table
oraDbSysTable
Children
25

Syntax

No syntax metadata recorded.

Values & Constraints

No enumerated values or constraints recorded.

Related Objects

Child Objects
ObjectTypeSyntaxOID
oraDbSysConsistentChanges mandatory
the 'consistent changes' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.1
oraDbSysRedoEntries mandatory
the 'redo entries' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.10
oraDbSysRedoLogSpaceRequests mandatory
the 'redo log space requests' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.11
oraDbSysRedoSyncWrites mandatory
the 'redo synch writes' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.12
oraDbSysSortsDisk mandatory
the 'sorts (disk)' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.13
oraDbSysSortsMemory mandatory
the 'sorts (memory)' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.14
oraDbSysSortsRows mandatory
the 'sorts (rows)' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.15
oraDbSysTableFetchRowid mandatory
the 'table fetch by rowid' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.16
oraDbSysTableFetchContinuedRow mandatory
the 'table fetch continued row' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.17
oraDbSysTableScanBlocks mandatory
the 'table scan blocks gotten' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.18
oraDbSysTableScanRows mandatory
the 'table scan rows gotten' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.19
oraDbSysConsistentGets mandatory
the 'consistent gets' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.2
oraDbSysTableScansLong mandatory
the 'table scans (long tables)' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.20
oraDbSysTableScansShort mandatory
the 'table scans (short tables)' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.21
oraDbSysUserCalls mandatory
the 'user calls' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.22
oraDbSysUserCommits mandatory
the 'user commits' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.23
oraDbSysUserRollbacks mandatory
the 'user rollbacks' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.24
oraDbSysWriteRequests mandatory
the 'write requests' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.25
oraDbSysDbBlockChanges mandatory
the 'Db block changes' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.3
oraDbSysDbBlockGets mandatory
the 'db block gets' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.4
oraDbSysFreeBufferInspected mandatory
the 'free buffer inspected' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.5
oraDbSysFreeBufferRequested mandatory
the 'free buffer requested' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.6
oraDbSysParseCount mandatory
the 'parse count' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.7
oraDbSysPhysReads mandatory
the 'physical reads' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.8
oraDbSysPhysWrites mandatory
the 'physical writes' parameter from v$sysstat
columnRFC1155-SMICounter.1.3.6.1.4.1.111.4.1.1.1.9
Indexes
ObjectTypeSyntaxOID
RDBMS-MIBrdbmsDbIndex
A numeric index, unique among all the databases from all products on this host. This value is a surrogate for the conceptually unique key, which is {PrivateMibOID, databasename}
columnInteger32.1.3.6.1.2.1.39.1.1.1.1