SAP ABAP Function Module DB02_ORA_TABLE_INDEX_ANALYSIS (DB02_ORA_TABLE_INDEX_ANALYSIS)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ STUO (Package) ORACLE Database Monitor

Basic Data

Function Module	DB02_ORA_TABLE_INDEX_ANALYSIS
Function Group	STD4	Oracle DB Statistics Modules (DB02)
Program Name	SAPLSTD4
INCLUDE Name	LSTD4U09

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	DBA_TABLES	TYPE	TABLES_STR		☐	☑
Exporting	INDEX_STATS	TYPE	INDEX_STAT		☐	☑
Exporting	SINGLE_INDEX	TYPE	INDEXES_ST		☐	☑
Exporting	BLOCK_SIZE	TYPE	SEGMENTS_F-KBYTES		☐	☑	KB
Exporting	DBSTATIORA1	TYPE	DBSTATIORA		☐	☑
Exporting	DBSTATTORA1	TYPE	DBSTATTORA		☐	☑
Exporting	DBA_SEGMENTS_TAB	TYPE	SEGMENTS_F		☐	☑	DB02: dba_segments (Oracle)
Importing	SEG_NAME	TYPE	SEGMENTS_F-SN	'*'	☑	☑	Object: Name of table or index
Importing	PARTITION	TYPE	SEGMENTS_F-SN		☑	☑	Object: Name of table or index
Importing	ANALYSIS	TYPE	DBFLAGS-DATA_ONLY		☐	☑
Importing	SEG_TYPE	TYPE	SEGMENTS_F-S_TYPE		☑	☑	Type of database object
Importing	OWNER	TYPE	SEGMENTS_F-OWNER		☑	☑	Owner
Tables	DBA_EXTENTS	TYPE	EXTENTS_ST		☑	☑
Tables	DBA_TAB_COLUMNS	TYPE	COLUMNS_ST		☑	☑
Tables	DD03V_TAB	TYPE	DD03V		☑	☑
Tables	DBA_SEGMENTS	TYPE	SEGMENTS_F		☑	☐	DB02: dba_segments (Oracle)
Exception	NO_SELECTION	TYPE			☐	☑

Processing Type

☐ Normal Function Module
☑ Remote-Enabled Module	☐ BaseXML supported
☐ Update Module	☑ Start immediately
	☐ Immediate Start, No Restart
	☐ Start Delayed
	☐ Coll.run
☐ JAVA Module Callable from ABAP
☐ Remote-Enabled JAVA Module
☐ Module Callable from JAVA

History

Last changed by/on	SAP	19970110
SAP Release Created in