SAP ABAP Data Element STA_PREPS (Number of prepares)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-TUN (Application Component) Performance Monitors (TCC)
     ⤷ STUN (Package) DBA: All the rest in English

Basic Data

Data Element	STA_PREPS
Short Description	Number of prepares

Data Type

Category of Dictionary Type	D	Domain
Type of Object Referenced		No Information
Domain / Name of Reference Type	STAT_CNTP0
Data Type	DEC	Counter or amount field with comma and sign
Length	15
Decimal Places	0
Output Length	19
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	Prepare
Medium	15	Prepare
Long	20	Prepare
Heading	7	Prepare

Documentation

Definition

For reading accesses (SELECT *, SELECT SINGLE *) the number of PREPARES shows how often the ORACLE function 'prepare' was called. The user process transfers a SELECT statement as a parameter which can contain variables.

This is then compiled by the shadow process and stored for the later execution. Through the cursor cache (statement cache), the information contains which SQL statements have recently been prepared, the total of all PREPAREs can be reduced and therefore the number of the DB requests is also reduced.

History

Last changed by/on	SAP	20130604
SAP Release Created in