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.
Parsed from file ORADB-MIB.txt
Company: oracle
Module: ORADB-MIB
Vendor: Oracle
Module: ORADB-MIB
[Automatically extracted from oidview.com]
oraDbSysEntry OBJECT-TYPE SYNTAX OraDbSysEntry ACCESS not-accessible STATUS mandatory DESCRIPTION "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." INDEX { rdbmsDbIndex } ::= { oraDbSysTable 1 }
OID | Name | Sub children | Sub Nodes Total | Description |
---|---|---|---|---|
1.3.6.1.4.1.111.4.1.1.1.1 | oraDbSysConsistentChanges | 0 | 0 | the 'consistent changes' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.2 | oraDbSysConsistentGets | 0 | 0 | the 'consistent gets' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.3 | oraDbSysDbBlockChanges | 0 | 0 | the 'Db block changes' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.4 | oraDbSysDbBlockGets | 0 | 0 | the 'db block gets' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.5 | oraDbSysFreeBufferInspected | 0 | 0 | the 'free buffer inspected' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.6 | oraDbSysFreeBufferRequested | 0 | 0 | the 'free buffer requested' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.7 | oraDbSysParseCount | 0 | 0 | the 'parse count' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.8 | oraDbSysPhysReads | 0 | 0 | the 'physical reads' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.9 | oraDbSysPhysWrites | 0 | 0 | the 'physical writes' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.10 | oraDbSysRedoEntries | 0 | 0 | the 'redo entries' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.11 | oraDbSysRedoLogSpaceRequests | 0 | 0 | the 'redo log space requests' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.12 | oraDbSysRedoSyncWrites | 0 | 0 | the 'redo synch writes' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.13 | oraDbSysSortsDisk | 0 | 0 | the 'sorts (disk)' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.14 | oraDbSysSortsMemory | 0 | 0 | the 'sorts (memory)' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.15 | oraDbSysSortsRows | 0 | 0 | the 'sorts (rows)' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.16 | oraDbSysTableFetchRowid | 0 | 0 | the 'table fetch by rowid' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.17 | oraDbSysTableFetchContinuedRow | 0 | 0 | the 'table fetch continued row' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.18 | oraDbSysTableScanBlocks | 0 | 0 | the 'table scan blocks gotten' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.19 | oraDbSysTableScanRows | 0 | 0 | the 'table scan rows gotten' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.20 | oraDbSysTableScansLong | 0 | 0 | the 'table scans (long tables)' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.21 | oraDbSysTableScansShort | 0 | 0 | the 'table scans (short tables)' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.22 | oraDbSysUserCalls | 0 | 0 | the 'user calls' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.23 | oraDbSysUserCommits | 0 | 0 | the 'user commits' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.24 | oraDbSysUserRollbacks | 0 | 0 | the 'user rollbacks' parameter from v$sysstat |
1.3.6.1.4.1.111.4.1.1.1.25 | oraDbSysWriteRequests | 0 | 0 | the 'write requests' parameter from v$sysstat |