DBSTATS - Control for Application Monitor and CBO: Setup

Control for Application Monitor and CBO: Setup information is stored in SAP table DBSTATS.
It is part of development package SDBA in software component BC-DB-ORA-CCM. This development package consists of objects that can be grouped under "DBA: Database-Independent Code".

Fields for table DBSTATS

Field Name	Description	Is Key	Data Element	Data Type	Length
DBOBJ	Name of Database Object	X	AM_DBOBJ	CHAR	30
DOTYP	Type of Database Object	X	AM_DOTYP	CHAR	2
OBJOW	Owner of the Database Object	X	AM_DBOWN	CHAR	30
DBTYP	Database	X	DBSYSTEM	CHAR	10
VWTYP	Type of Usage of Table Entry		AM_VWTYP	CHAR	2
ACTIV	Control Flag for Update of Statistics		AM_ACTVE	CHAR	1
OBJEC	Identification of EDM cluster		UDCLUID	CHAR	10
AEDAT	Change/Insert Date in Control Table		AM_AENDDAT	DATS	8
SIGNI	Significance for Collection of Statistics		AM_SIGNI	INT1	1
AMETH	Analysis Method for Collecting Statistics		AM_AMETH	CHAR	4
OPTIO	Sample Size for Collection of Statistics		AM_OPTIO	CHAR	5
TOBDO	TODO Flag: Create New Statistics		AM_TOBDO	CHAR	1
HISTO	HISTORY Flag: With History		AM_HISTO	CHAR	1
TDDAT	Date on Which the ToDo Flag Was Set		AM_TDDAT	DATS	8
DURAT	Estimated runtime of table analysis		AM_DURAT	TIMS	6
PLAND	Customer Flag: Customer Setting		AM_PLAND	CHAR	1
AENAM	Changed by		AM_AENAME	CHAR	30
AEDES	Description of reason for change and its consequences		AM_AEDES	CHAR	100
AEREL	SAP Release		AM_RELEA	CHAR	4
SYKAT	System category		AM_SYKAT	CHAR	2
SYSIZ	System size		AM_SYSIZ	CHAR	1