SAP ABAP Data Element AM_ACTVE (Control Flag for Update of Statistics)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
     ⤷ SDBA (Package) DBA: Database-Independent Code
Basic Data
Data Element AM_ACTVE
Short Description Control Flag for Update of Statistics  
Data Type
Category of Dictionary Type D   Domain
Type of Object Referenced     No Information
Domain / Name of Reference Type AM_ACTIVE    
Data Type CHAR   Character String 
Length 1    
Decimal Places 0    
Output Length 1    
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 Active 
Medium 15 Active Flag 
Long 20 Active Flag 
Heading 3 Act 
Documentation

Definition

This control flag (ACTIVE flag) specifies how statistics for a database are updated.

Possible settings:

  • A: Active (Default Setting)
    Statistics are checked and then updated, if necessary
  • I: Ignore

    This object is ignored. Statistics are neither update nor deleted

  • N: No Statistics (Negative)
    Statistics are deleted. All pool and cluster tables are handled this way by default. You should only use this setting for objects with usage type 'O' is SAP recommends that you do so.
  • P: Priority
    Statistics are checked and, if necessary, updated before objects with the default setting "A". Use this setting if you are using the time-limited update of statistics and want to ensure that this object is preferentially processed.
    Die zeitlich begrenzte Aktualisierung ist z.B. für Oracle-Datenbanken als BRCONNECT-Option verfügbar.
  • U: Unconditional
    The statistics are updated every time without being checked. You should
    only use this setting if SAP recommends that you do so, as it extends the update runtime.
  • R: Restrictive
    Statistics are only temporarily created, stored in tables for the application monitor (for example, for Oracle databases in DBSTATTORA and DBSTATIORA), and then immediately deleted. You should only use this setting for objects with usage type 'A'.

History
Last changed by/on SAP  20020827 
SAP Release Created in