oraDbSysEntry
ORADB-MIB ·
.1.3.6.1.4.1.111.4.1.1.1
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
| Object | Type | Syntax | OID |
|---|---|---|---|
| oraDbSysConsistentChanges mandatory the 'consistent changes' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.1 |
| oraDbSysRedoEntries mandatory the 'redo entries' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.10 |
| oraDbSysRedoLogSpaceRequests mandatory the 'redo log space requests' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.11 |
| oraDbSysRedoSyncWrites mandatory the 'redo synch writes' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.12 |
| oraDbSysSortsDisk mandatory the 'sorts (disk)' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.13 |
| oraDbSysSortsMemory mandatory the 'sorts (memory)' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.14 |
| oraDbSysSortsRows mandatory the 'sorts (rows)' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.15 |
| oraDbSysTableFetchRowid mandatory the 'table fetch by rowid' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.16 |
| oraDbSysTableFetchContinuedRow mandatory the 'table fetch continued row' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.17 |
| oraDbSysTableScanBlocks mandatory the 'table scan blocks gotten' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.18 |
| oraDbSysTableScanRows mandatory the 'table scan rows gotten' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.19 |
| oraDbSysConsistentGets mandatory the 'consistent gets' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.2 |
| oraDbSysTableScansLong mandatory the 'table scans (long tables)' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.20 |
| oraDbSysTableScansShort mandatory the 'table scans (short tables)' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.21 |
| oraDbSysUserCalls mandatory the 'user calls' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.22 |
| oraDbSysUserCommits mandatory the 'user commits' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.23 |
| oraDbSysUserRollbacks mandatory the 'user rollbacks' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.24 |
| oraDbSysWriteRequests mandatory the 'write requests' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.25 |
| oraDbSysDbBlockChanges mandatory the 'Db block changes' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.3 |
| oraDbSysDbBlockGets mandatory the 'db block gets' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.4 |
| oraDbSysFreeBufferInspected mandatory the 'free buffer inspected' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.5 |
| oraDbSysFreeBufferRequested mandatory the 'free buffer requested' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.6 |
| oraDbSysParseCount mandatory the 'parse count' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.7 |
| oraDbSysPhysReads mandatory the 'physical reads' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.8 |
| oraDbSysPhysWrites mandatory the 'physical writes' parameter from v$sysstat | column | RFC1155-SMICounter | .1.3.6.1.4.1.111.4.1.1.1.9 |
Indexes
| Object | Type | Syntax | OID |
|---|---|---|---|
| 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} | column | Integer32 | .1.3.6.1.2.1.39.1.1.1.1 |