SAP ABAP Data Element ORA_DBIO_EXPECTED (Oracle mon.: Average Block Read time (ms))
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework
Basic Data
| Data Element | ORA_DBIO_EXPECTED |
| Short Description | Oracle mon.: Average Block Read time (ms) |
Data Type
| Category of Dictionary Type | Direct Type Entry | |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | ||
| Data Type | INT4 | 4-byte integer, integer number with sign |
| Length | 10 | |
| Decimal Places | 0 | |
| Output Length | 11 | |
| Value Table |
Further Characteristics
| Search Help: Name | ||
| Search Help: Parameters | ||
| Parameter ID | ||
| Default Component name | ||
| Change document | ||
| No Input History | ||
| Basic direction is set to LTR | ||
| No BIDI Filtering |
Field Label
| Length | Field Label | |
| Short | 10 | AvgBlReadT |
| Medium | 15 | AvgBlReadT (ms) |
| Long | 20 | AvgBlckReadTime (ms) |
| Heading | 22 | Avg.BlockReadTime (ms) |
Documentation
Definition
The average time to read a single database block in milliseconds
This parameter is used for the ADDM report as value for the parameter DBIO_EXPECTED (see also oracle's documentation for this parameter). Oracle uses 10 milliseconds (10000 microsec.) as default. This monitor suggests the quotient
"GV$SYSTEM_EVENT-TIME_WAITED_MICRO / GV$SYSTEM_EVENT-TOTAL_WAITS"
as proposal.
Please note: Enter a value in milliseconds (NOT: microseconds).
Use
Dependencies
Example
History
| Last changed by/on | SAP | 20070813 |
| SAP Release Created in | 710 |
