SAP ABAP Function Module GET_DB_ORA_UNDOSTAT (retrieves data from view V$UNDOSTAT.)

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	GET_DB_ORA_UNDOSTAT	retrieves data from view V$UNDOSTAT.
Function Group	STD9	Oracle Monitoring (New features)
Program Name	SAPLSTD9	Update Statistics for Certain Index
INCLUDE Name	LSTD9U02

Parameters

Type	Parameter Name	Typing	Associated Type	Default value	Optional	Pass Value	Short text
Exporting	CURR_TIME	TYPE	SYST-UZEIT		☐	☐	Date and Time, Current Application Server Time
Exporting	CURR_DATE	TYPE	SYST-DATUM		☐	☐	Date and time, current (application server) date
Exporting	CURR_SYSTEM	TYPE	SYST-SYSID		☐	☐	Database instance (OPS)
Importing	IS_GV	TYPE	DATA_TYPE		☑	☐	datatype of the column
Tables	UNSTTAB	TYPE	UNSTTAB		☐	☐	structure representing the db view V$UNDOSTAT.
Tables	UNSTTAB_GV	TYPE	UNSTTAB_GV		☐	☐	structure representing the db view GV$UNDOSTAT.
Exception	WRONG_DATABASE	TYPE			☐	☐	non Oracle DB.
Exception	WRONG_ORACLE_RELEASE	TYPE			☐	☐	wrong oracle release.
Exception	NOT_FOUND	TYPE			☐	☐	no lines in the DB view.
Exception	ERROR	TYPE			☐	☐	any error that causes the SQL not to work.
Exception	DB_RELEASE_UNKNOWN	TYPE			☐	☐	unknown database release.

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	20040312
SAP Release Created in	640