Hierarchy
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON (Application Component) Monitoring⤷
SAPWL_FRONTEND (Package) SAP: Workload Display, Enjoy & OO Version - ST03N
Basic Data
| Data Element | SWLPHYDBCN |
| Short Description | SAP Workload: Number of Physical Database Accesses |
Data Type
| Category of Dictionary Type | D | Domain |
| Type of Object Referenced | No Information | |
| Domain / Name of Reference Type | SAPWLP30 | |
| Data Type | DEC | Counter or amount field with comma and sign |
| Length | 30 | |
| Decimal Places | 0 | |
| Output Length | 39 | |
| 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 | # Accesses |
| Medium | 20 | # DB Accesses |
| Long | 25 | # Physical DB Accesses |
| Heading | 45 | Number of Physical Database Accesses |
Documentation
Definition
A large portion of the duration of a dialog step is used for processes that perform read and write operations on the database. This type of database access includes all SAP database interface accesses that are passed on to the database. They represent a subset of the logical database accesses, which also includes the requests that were processed by the local SAP buffer. The time behavior of the direct database accesses depends to a significant degree on the run times in the network and the utilization of the database server.
The direct database accesses are classified into PREPARE, DESCRIBE, OPEN, FETCH/EXEC, CLOSE commands. While the actual database operations (reads/writes) are caused by the calls "FETCH" and "EXEC", the other calls are used to provide data description and as utilities for data organization between database and ABAP/4 database interface.
The SAP cursor cache means that most database accesses consist of OPEN and FETCH/EXEC commands, while the other accesses can be buffered. One or more FETCH operations must precede an OPEN.
History
| Last changed by/on | SAP | 20041230 |
| SAP Release Created in |
