SAP ABAP Class CL_ORA_ACTION_ASH (ORA: Active Session History Monitor)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBMON_ORA_COCKPIT (Package) Database Monitor for Oracle in Cockpit Framework

Meta Relationship - Using

#	Relationship type	Using	Short Description	Created on
1	Inheritance (c INHERITING FROM c_ref)	CL_ORA_ACTION_CONTROLLER	ORA: Abstract Action Controller	20060308

Properties

Class	CL_ORA_ACTION_ASH
Short Description	ORA: Active Session History Monitor
Super Class	CL_ORA_ACTION_CONTROLLER	ORA: Abstract Action Controller
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	S_DBMON_ORA_COCKPIT	Database Monitor for Oracle in Cockpit Framework
Created	20050908	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_ORA_ACTION_ASH has no forward declaration.

Interfaces

Class CL_ORA_ACTION_ASH has no interface implemented.

Friends

Class CL_ORA_ACTION_ASH has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GC_DATASOURCE_DBA	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_DATASOURCE	'2'	Datasource dba view	20050923
2	GC_DATASOURCE_GV	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_DATASOURCE	'1'	Datasource gv$view	20050923
3	GC_KEYFIGURE_ACTSESS	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_KEYFIGURE	'1'	Key figure "active sessions"	20050923
4	GC_KEYFIGURE_TIMWT	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_KEYFIGURE	'2'	Key figure "time waited"	20050923
5	GC_OKCODE_EXPLAIN_PLAN	Constant	Public	☐	Type reference (TYPE)	UI_FUNC	'EXPLPLAN'	OK Code function "Explain plan"	20060220
6	GC_SERIESTYPE_WECLASS	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_SERIESTYPE	'1'	Series type "wait event classes"	20050923
7	GC_SERIESTYPE_WEVENT	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_SERIESTYPE	'2'	Series type "wait events"	20050923
8	GC_TIMEINTERVAL_10MIN	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_TIMEINTERVAL	'5'	Time interval 10 minutes	20050926
9	GC_TIMEINTERVAL_10SEC	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_TIMEINTERVAL	'3'	Time interval 10 sec.	20050926
10	GC_TIMEINTERVAL_MILLI	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_TIMEINTERVAL	'1'	Time interval 1 millisec.	20051006
11	GC_TIMEINTERVAL_MIN	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_TIMEINTERVAL	'4'	Time interval 1 minute	20050926
12	GC_TIMEINTERVAL_SEC	Constant	Public	☐	Type reference (TYPE)	ORA_ASH_TIMEINTERVAL	'2'	Time interval 1 sec	20050926
13	GC_WAITCLASSNAME_IDLE	Constant	Public	☐	Type reference (TYPE)	ORA_WAIT_CLASS_NAME	'Idle'	Wait class name for idle events	20051010
14	GS_4016_LAYOUT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV layout structure for wait events	20051130
15	GS_4017_LAYOUT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV layout structure for file stats	20051130
16	GS_4018_LAYOUT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV layout structure for SQL info	20051130
17	GS_LAYOUT1	Instance attribute	Private	☐	Type reference (TYPE)	LVC_S_LAYO		ALV: Layout	20051018
18	GT_4016_FIELDCAT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldatalog for wait events	20051213
19	GT_4017_FIELDCAT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldatalog for file stats	20051213
20	GT_4018_FIELDCAT	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldatalog for SQL info	20051213
21	GT_FIELDCAT1	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_FCAT		ALV: Field Catalog	20051018
22	GT_SORT1	Instance attribute	Private	☐	Type reference (TYPE)	LVC_T_SORT		ALV: Sort Criteria	20051025
23	G_CE_VIEWER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Graphics: Chart Engine viewer	20050922
24	G_CONTRL_ALV1	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_ALV_GRID		Control ALV grid on tab 1 (List)	20050922
25	G_CONT_4011_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container in tab 1 (list)	20050922
26	G_CONT_4012_GRAPH	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container in tab 2 (graphic)	20050922
27	G_CONT_4016_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Detail info: Wait events	20051130
28	G_CONT_4017_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Detail info: File stats	20051130
29	G_CONT_4018_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Detail info: SQL info	20051130
30	G_CONT_ASH	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container in ASH monitor main screen	20050922
31	G_CTRL_4016_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_ALV_GRID		ALV Control for detail info: Wait events	20051130
32	G_CTRL_4017_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_ALV_GRID		ALV Control for detail info: File stats	20051130
33	G_CTRL_4018_ALV	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_GUI_ALV_GRID		ALV Control for detail info: SQL info	20051130
34	G_DESIGN_MODE	Instance attribute	Private	☐	Type reference (TYPE)	XFELD		Flag design mode active	20050926
35	G_INFSRV_ASH	Instance attribute	Private	☐	Object reference (TYPE REF TO)	CL_ORA_INFOSRV_ACTSESSHIST		Infoservice Service: Active Session History	20050922
36	G_SELECTION	Instance attribute	Private	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051024
37	G_SEL_BACKUP	Instance attribute	Private	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings, last valid view	20051024
38	G_XML_DATA_SERVER	Instance attribute	Private	☐	Object reference (TYPE REF TO)	LCL_BG_XML_SERVER		Reference to XML data server instance	20050922
39	TAB_4010_1	Constant	Public	☐	Type reference (TYPE)	SYUCOMM	'ASH_TABSTRIP_FC1'	Tabstrip 4010_1	20080125
40	TAB_4010_2	Constant	Public	☐	Type reference (TYPE)	SYUCOMM	'ASH_TABSTRIP_FC2'	Tabstrip 4010_2	20080125
41	TAB_4015_1	Constant	Public	☐	Type reference (TYPE)	SYUCOMM	'ASHDET_TABSTRIP_FC1'	Tabstrip 4015_1	20080125
42	TAB_4015_2	Constant	Public	☐	Type reference (TYPE)	SYUCOMM	'ASHDET_TABSTRIP_FC2'	Tabstrip 4015_2	20080125
43	TAB_4015_3	Constant	Public	☐	Type reference (TYPE)	SYUCOMM	'ASHDET_TABSTRIP_FC3'	Tabstrip 4015_3	20080125
44	VIEW_DATA	Instance attribute	Public	☐	Type reference (TYPE)	ORACC_ACTION_ASH		Data for action "active session history" (oracle monitor)	20050908

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	ADD_SECONDS_TO_TIMESTAMP	Static method	Public	Method	Add a number of seconds (pos. or neg!) to a timestamp	20051011
2	CALC_TIMEFRAME_LENGTH_SEC	Static method	Public	Method	Calculate length of a time frame in seconds	20051011
3	CHECK_GSELECTION_VOLUME	Instance method	Private	Method	Check the graphic selection range, return error if too large	20051010
4	CREATE_ASH_DETAILPOPUP	Instance method	Public	Method	Details popup for oracle "active session history" monitor	20051129
5	DETAIL_BUILD_FIELDCATS	Instance method	Private	Method	Build field catalogs for detail ALV lists	20051213
6	DETAIL_FREE_RESSOURCES	Instance method	Public	Method	Free ressources of details popup	20051130
7	DET_FILE_HANDLE_BEFORE_UCOMM	Instance method	Private	Event handling method	Show block list for a selected file list row (+ help)	20060216
8	DET_FILE_HANDLE_DOUBLE_CLICK	Instance method	Private	Event handling method	Show block list for a selected file list row	20060216
9	DET_FILE_POPUP_BLOCKNUMBERS	Instance method	Private	Method	show numbers of blocks that are accessed (timefr.+file)	20060217
10	DET_SQL_HANDLE_BEFORE_UCOMM	Instance method	Private	Event handling method	Show time stamps for a selected SQL statement (+ help)	20060216
11	DET_SQL_HANDLE_DOUBLE_CLICK	Instance method	Private	Event handling method	Show time stamps for a selected SQL statement	20060216
12	DET_SQL_HANDLE_TOOLBAR	Instance method	Private	Event handling method	Extend toobar for SQL ALV (explain SQL button)	20060220
13	DET_SQL_HANDLE_USER_COMMAND	Instance method	Private	Event handling method	Handle user command caused by ALV buttons	20060220
14	DET_SQL_POPUP_TIMESTAMPS	Instance method	Private	Method	Show timestamps for a selected SQL statement	20060217
15	DET_WE_HANDLE_BEFORE_UCOMM	Instance method	Private	Event handling method	(+ eventually online help on info button)	20060223
16	FORMAT_TIMESTAMP_FOR_DISPLAY	Static method	Public	Method	format a timestamp for screen output	20051129
17	GET_ADOPTED_ALV_FIELDCAT	Instance method	Private	Method	adopt ALV field catalog for database release	20060308
18	GET_ASH_INFOSERVICE	Instance method	Public	Method	Get reference to ASH infoservice instance	20051124
19	GET_FULL_SQL_TEXT	Instance method	Private	Method	Get the full sql text out of V$SQLTEXT	20061122
20	GET_GENERAL_SELECTION	Instance method	Public	Method	Get the general selection and settings data	20051024
21	GET_GRAPH_SELECTION	Instance method	Public	Method	Get the graphic selection and settings data	20050923
22	GET_INITIAL_ALV_SETTINGS	Instance method	Private	Method	get initial ALV settings (field cat. + layout)	20051024
23	GET_INITIAL_DISPLAY_DATA	Instance method	Private	Method	get initial data for display (ASH, Events, Evt. Classes)	20051006
24	GRAPHIC_EVENT_ON_CLICK	Instance method	Private	Event handling method	Handle Graphic (chart engine) event "click"	20060407
25	MAKE_TIMESTAMP	Static method	Public	Method	Make a timestamp out of a date and a time	20051024
26	OKC_G_DELE_CUSTOMIZING_SAP	Instance method	Private	Method	Delete graphic settings from SAP database	20051020
27	OKC_G_LOAD_CUSTOMIZING_SAP	Instance method	Private	Method	Load graphic settings from SAP database	20051019
28	OKC_G_LOAD_CUSTOMIZING_WIN	Instance method	Private	Method	Load graphic settings from frontend file	20051019
29	OKC_G_PAGE_LEFT	Instance method	Private	Method	set time frame selection for "shift one page left"	20051011
30	OKC_G_PAGE_RIGHT	Instance method	Private	Method	set time frame selection for "shift one page right"	20051011
31	OKC_G_PRINT_CHART	Instance method	Private	Method	Print graphic (on frontend printer)	20060313
32	OKC_G_REFRESH	Instance method	Private	Method	refresh graphic display according to selections	20051011
33	OKC_G_SAVE_CHART	Instance method	Private	Method	Save graphics / chart to a frontend file	20060313
34	OKC_G_SAVE_CUSTOMIZING_SAP	Instance method	Private	Method	Save current graphic settings to SAP database	20051019
35	OKC_G_SAVE_CUSTOMIZING_WIN	Instance method	Private	Method	Save current graphic settings to frontend file	20051019
36	OKC_G_SHIFT_LEFT	Instance method	Private	Method	set time frame selection for "shift (simple) left"	20051011
37	OKC_G_SHIFT_RIGHT	Instance method	Private	Method	set time frame selection for "shift (simple) right"	20051011
38	OKC_G_TOTAL_LEFT	Instance method	Private	Method	set time frame selection for "shift total left"	20051011
39	OKC_G_TOTAL_RIGHT	Instance method	Private	Method	set time frame selection for "shift total right"	20051011
40	OKC_G_ZOOM_IN	Instance method	Private	Method	set time frame selection for "zoom in"	20051011
41	OKC_G_ZOOM_OUT	Instance method	Private	Method	set time frame selection for "zoom out"	20051011
42	OKC_LOADDATA	Instance method	Private	Method	Load data pool according to selections	20051024
43	OKC_MONITOR_DOCU	Instance method	Private	Method	Display online documentation for this monitor	20060315
44	OKC_SELECT_EVENTS_OR_CLASSES	Instance method	Private	Method	select wait events or wait event classes for display (popup)	20051011
45	OKC_SET_TF_DEFAULT	Instance method	Private	Method	Set data pool time frame to default	20051026
46	OKC_SHOW_TIMEFRAMEINFO	Instance method	Private	Method	Show information about available max. timeframes (+ use)	20051027
47	OKC_TOGGLE_DESIGN_MODE	Instance method	Private	Method	toggle graphic design mode (OK-Code function)	20051011
48	RESTRICT_CHARTTYPES	Instance method	Private	Method	Restrict charttypes to time-Charts	20051209
49	SEL_EVENTS_FOR_CLASS	Instance method	Public	Method	Set graphic selection: all wait events of a w. evt. class	20051025
50	SET_GENERAL_SELECTION	Instance method	Public	Method	Set the general selection and settings data	20051024
51	SET_GRAPH_SELECTION	Instance method	Public	Method	Set the graphic selection and settings data	20050923
52	SWITCH_TO_ENGLISH	Instance method	Private	Method	Switch to english if necessary	20060221
53	UNPACK_TIMESTAMP	Static method	Public	Method	Unpack a timestamp into data, time and millisecond fields	20051027

Events

Class CL_ORA_ACTION_ASH has no event.

Types

Class CL_ORA_ACTION_ASH has no local type.

Method Signatures

Method ADD_SECONDS_TO_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SECONDS	Value transfer	☐	Type reference (TYPE)	I		Number of seconds to be added	20051011
2	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Original timestamp	20051011
3	Returning	R_TIMESTAMP	Value transfer	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Calculated new timestamp	20051011

Method ADD_SECONDS_TO_TIMESTAMP on class CL_ORA_ACTION_ASH has no exception.

Method CALC_TIMEFRAME_LENGTH_SEC Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FROM_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		From timestamp	20051011
2	Importing	I_TO_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		To timestamp	20051011
3	Returning	R_SECONDS	Value transfer	☐	Type reference (TYPE)	I		Length in seconds	20051011

#	Exception	Resumable	Description	Created on
1	NOT_A_VALID_TIMEFRAME	☐	Parameter values describe not a valid time frame	20051201

Method CHECK_GSELECTION_VOLUME Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SUBRC	Value transfer	☐	Type reference (TYPE)	SYSUBRC		Returncode (<>0 if check failed)	20051201
2	Importing	I_GRAPH_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_GRAPH_SELECTION1		Selections / Settings for Oracle ASH Monitor graphic	20051010

#	Exception	Resumable	Description	Created on
1	NOT_A_VALID_TIMEFRAME	☐	Parameter values describe not a valid time frame	20051201

Method CREATE_ASH_DETAILPOPUP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	IS_ASH_GDATA	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_GRAPHDATA		Selected ASH graphic data point	20051129
2	Importing	I_ASH_INFOSERVICE	Call by reference	☐	Object reference (TYPE REF TO)	CL_ORA_INFOSRV_ACTSESSHIST		Information Service: Active Session History	20051129
3	Importing	I_SERIESTYPE	Call by reference	☐	Type reference (TYPE)	ORA_ASH_SERIESTYPE		Current series type	20051129
4	Importing	I_TO_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		End of considered timestamp interval	20051130

Method CREATE_ASH_DETAILPOPUP on class CL_ORA_ACTION_ASH has no exception.

Method DETAIL_BUILD_FIELDCATS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_FIELDCAT_4016	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldcatalog for wait events	20051213
2	Exporting	ET_FIELDCAT_4017	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldcatalog for file stats	20051213
3	Exporting	ET_FIELDCAT_4018	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		ALV fieldcatalog for SQL requests	20051213

Method DETAIL_BUILD_FIELDCATS on class CL_ORA_ACTION_ASH has no exception.

Method DETAIL_FREE_RESSOURCES Signature

Method DETAIL_FREE_RESSOURCES on class CL_ORA_ACTION_ASH has no parameter.
Method DETAIL_FREE_RESSOURCES on class CL_ORA_ACTION_ASH has no exception.

Method DET_FILE_HANDLE_BEFORE_UCOMM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	E_UCOMM	Call by reference	☐	Attribute reference (LIKE)				20060216
2	Importing	SENDER	Call by reference	☐	Attribute reference (LIKE)				20060216

Method DET_FILE_HANDLE_BEFORE_UCOMM on class CL_ORA_ACTION_ASH has no exception.

Method DET_FILE_HANDLE_DOUBLE_CLICK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ES_ROW_NO	Call by reference	☐	Attribute reference (LIKE)				20060216
2	Importing	E_COLUMN	Call by reference	☐	Attribute reference (LIKE)				20060216
3	Importing	E_ROW	Call by reference	☐	Attribute reference (LIKE)				20060216

Method DET_FILE_HANDLE_DOUBLE_CLICK on class CL_ORA_ACTION_ASH has no exception.

Method DET_FILE_POPUP_BLOCKNUMBERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_FILE_HASH	Call by reference	☐	Type reference (TYPE)	ORA_FILE		File#	20060217
2	Importing	I_FILE_NAME	Call by reference	☐	Type reference (TYPE)	ORA_NAME_DF		File name	20060217
3	Importing	I_TIMESTAMP_FROM	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp (from)	20060217
4	Importing	I_TIMESTAMP_TO	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp (to)	20060217

Method DET_FILE_POPUP_BLOCKNUMBERS on class CL_ORA_ACTION_ASH has no exception.

Method DET_SQL_HANDLE_BEFORE_UCOMM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	E_UCOMM	Call by reference	☐	Attribute reference (LIKE)				20060216
2	Importing	SENDER	Call by reference	☐	Attribute reference (LIKE)				20060216

Method DET_SQL_HANDLE_BEFORE_UCOMM on class CL_ORA_ACTION_ASH has no exception.

Method DET_SQL_HANDLE_DOUBLE_CLICK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ES_ROW_NO	Call by reference	☐	Attribute reference (LIKE)				20060216
2	Importing	E_COLUMN	Call by reference	☐	Attribute reference (LIKE)				20060216
3	Importing	E_ROW	Call by reference	☐	Attribute reference (LIKE)				20060216

Method DET_SQL_HANDLE_DOUBLE_CLICK on class CL_ORA_ACTION_ASH has no exception.

Method DET_SQL_HANDLE_TOOLBAR Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	E_INTERACTIVE	Call by reference	☐	Attribute reference (LIKE)				20060220
2	Importing	E_OBJECT	Call by reference	☐	Attribute reference (LIKE)				20060220

Method DET_SQL_HANDLE_TOOLBAR on class CL_ORA_ACTION_ASH has no exception.

Method DET_SQL_HANDLE_USER_COMMAND Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	E_UCOMM	Call by reference	☐	Attribute reference (LIKE)				20060220

Method DET_SQL_HANDLE_USER_COMMAND on class CL_ORA_ACTION_ASH has no exception.

Method DET_SQL_POPUP_TIMESTAMPS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_ID	Call by reference	☐	Type reference (TYPE)	ORA_SQL_ID		SQL ID	20060217
2	Importing	I_SQL_TEXT	Call by reference	☐	Type reference (TYPE)	ORA_SQL_TEXT		SQL Text	20060217
3	Importing	I_TIMESTAMP_FROM	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp (from)	20060217
4	Importing	I_TIMESTAMP_TO	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp (to)	20060217

Method DET_SQL_POPUP_TIMESTAMPS on class CL_ORA_ACTION_ASH has no exception.

Method DET_WE_HANDLE_BEFORE_UCOMM Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	E_UCOMM	Call by reference	☐	Attribute reference (LIKE)				20060223
2	Importing	SENDER	Call by reference	☐	Attribute reference (LIKE)				20060223

Method DET_WE_HANDLE_BEFORE_UCOMM on class CL_ORA_ACTION_ASH has no exception.

Method FORMAT_TIMESTAMP_FOR_DISPLAY Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_INTERNAL	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		timestamp in internal format yyyymmdd;hhmmssmmm	20051129
2	Returning	R_EXTERNAL	Value transfer	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		timestamp in external format (depending on user settings)	20051129

Method FORMAT_TIMESTAMP_FOR_DISPLAY on class CL_ORA_ACTION_ASH has no exception.

Method GET_ADOPTED_ALV_FIELDCAT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	CT_FIELDCAT	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for ALV	20060308

Method GET_ADOPTED_ALV_FIELDCAT on class CL_ORA_ACTION_ASH has no exception.

Method GET_ASH_INFOSERVICE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_ASH_INFOSERVICE	Value transfer	☐	Object reference (TYPE REF TO)	CL_ORA_INFOSRV_ACTSESSHIST		Active Session History information service	20051124

Method GET_ASH_INFOSERVICE on class CL_ORA_ACTION_ASH has no exception.

Method GET_FULL_SQL_TEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SQL_FULL_TEXT	Call by reference	☐	Type reference (TYPE)	STRING			20061122
2	Importing	P_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20061122
3	Importing	P_SQL_ID	Call by reference	☐	Type reference (TYPE)	ORA_SQL_ID			20061122

Method GET_FULL_SQL_TEXT on class CL_ORA_ACTION_ASH has no exception.

Method GET_GENERAL_SELECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_GENERAL_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_GENERAL_SELECTION		General selections / settings for Oracle ASH Monitor	20051024

Method GET_GENERAL_SELECTION on class CL_ORA_ACTION_ASH has no exception.

Method GET_GRAPH_SELECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_GRAPH_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_GRAPH_SELECTION1		Selections / Settings for Oracle ASH Monitor graphic	20050923

Method GET_GRAPH_SELECTION on class CL_ORA_ACTION_ASH has no exception.

Method GET_INITIAL_ALV_SETTINGS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ES_LAYOUT	Call by reference	☐	Type reference (TYPE)	LVC_S_LAYO		Layout structure for ALV	20051024
2	Exporting	ET_FIELDCAT	Call by reference	☐	Type reference (TYPE)	LVC_T_FCAT		Field Catalog for ALV	20051024
3	Exporting	ET_SORT	Call by reference	☐	Type reference (TYPE)	LVC_T_SORT		Sort Criteria for ALV	20051025

Method GET_INITIAL_ALV_SETTINGS on class CL_ORA_ACTION_ASH has no exception.

Method GET_INITIAL_DISPLAY_DATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	ET_ASH	Call by reference	☐	Type reference (TYPE)	ORA_T_GV_ACTIVE_SESSION_HIS		Complete ASH data	20051006
2	Exporting	ET_SEL_WAITEVCLS	Call by reference	☐	Type reference (TYPE)	ORA_T_SEL_WAITEVCLS		selected wait event classes	20051006
3	Exporting	ET_SEL_WAITEVENTS	Call by reference	☐	Type reference (TYPE)	ORA_T_SEL_WAITEVENTS		selected wait events	20051006
4	Exporting	E_SAMPLE_TIME_MAX	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Latest timestamp	20051006
5	Exporting	E_SAMPLE_TIME_MIN	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Earliest timestamp	20051006
6	Importing	I_INFSRV_ASH	Call by reference	☐	Object reference (TYPE REF TO)	CL_ORA_INFOSRV_ACTSESSHIST		Infoservice "Active Session History"	20051006
7	Importing	I_INST_ID	Call by reference	☐	Type reference (TYPE)	ORA_INST_ID		Instance ID	20051006

Method GET_INITIAL_DISPLAY_DATA on class CL_ORA_ACTION_ASH has no exception.

Method GRAPHIC_EVENT_ON_CLICK Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	ELEMENT	Call by reference	☐	Attribute reference (LIKE)				20060407
2	Importing	POINT	Call by reference	☐	Attribute reference (LIKE)				20060407
3	Importing	SERIES	Call by reference	☐	Attribute reference (LIKE)				20060407

Method GRAPHIC_EVENT_ON_CLICK on class CL_ORA_ACTION_ASH has no exception.

Method MAKE_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_DATE	Call by reference	☐	Type reference (TYPE)	SYDATS		date	20051024
2	Importing	I_MILLI	Call by reference	☑	Type reference (TYPE)	CHAR3		milliseconds	20051024
3	Importing	I_TIME	Call by reference	☐	Type reference (TYPE)	SYTIME		time	20051024
4	Returning	R_TIMESTAMP	Value transfer	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp ( format yyyymmdd;hhmmssmmm)	20051024

Method MAKE_TIMESTAMP on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_DELE_CUSTOMIZING_SAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20051020

Method OKC_G_DELE_CUSTOMIZING_SAP on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_LOAD_CUSTOMIZING_SAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20051019

Method OKC_G_LOAD_CUSTOMIZING_SAP on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_LOAD_CUSTOMIZING_WIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20051019

Method OKC_G_LOAD_CUSTOMIZING_WIN on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_PAGE_LEFT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_PAGE_LEFT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_PAGE_RIGHT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_PAGE_RIGHT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_PRINT_CHART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20060313

Method OKC_G_PRINT_CHART on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_REFRESH Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_REFRESH on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_SAVE_CHART Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20060313

Method OKC_G_SAVE_CHART on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_SAVE_CUSTOMIZING_SAP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20051019

Method OKC_G_SAVE_CUSTOMIZING_SAP on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_SAVE_CUSTOMIZING_WIN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Reference to chart engine	20051019

Method OKC_G_SAVE_CUSTOMIZING_WIN on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_SHIFT_LEFT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_SHIFT_LEFT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_SHIFT_RIGHT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_SHIFT_RIGHT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_TOTAL_LEFT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_TOTAL_LEFT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_TOTAL_RIGHT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_TOTAL_RIGHT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_ZOOM_IN Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_ZOOM_IN on class CL_ORA_ACTION_ASH has no exception.

Method OKC_G_ZOOM_OUT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_G_ZOOM_OUT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_LOADDATA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor	20051024
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051024

Method OKC_LOADDATA on class CL_ORA_ACTION_ASH has no exception.

Method OKC_MONITOR_DOCU Signature

Method OKC_MONITOR_DOCU on class CL_ORA_ACTION_ASH has no parameter.
Method OKC_MONITOR_DOCU on class CL_ORA_ACTION_ASH has no exception.

Method OKC_SELECT_EVENTS_OR_CLASSES Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051011

Method OKC_SELECT_EVENTS_OR_CLASSES on class CL_ORA_ACTION_ASH has no exception.

Method OKC_SET_TF_DEFAULT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor	20051026
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051026

Method OKC_SET_TF_DEFAULT on class CL_ORA_ACTION_ASH has no exception.

Method OKC_SHOW_TIMEFRAMEINFO Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor	20051027
2	Returning	R_SELECTION	Value transfer	☐	Type reference (TYPE)	ORA_S_ASH_SELECTION		Selections / Settings for Oracle ASH Monitor graphic	20051027

Method OKC_SHOW_TIMEFRAMEINFO on class CL_ORA_ACTION_ASH has no exception.

Method OKC_TOGGLE_DESIGN_MODE Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_CHART_ENGINE	Call by reference	☐	Object reference (TYPE REF TO)	CL_GUI_CHART_ENGINE		Chart Engine	20051011
2	Importing	I_DESIGN_MODE	Call by reference	☐	Type reference (TYPE)	XFELD		Old design mode flag	20051011
3	Returning	R_DESIGN_MODE	Value transfer	☐	Type reference (TYPE)	XFELD		New design mode flag	20051011

Method OKC_TOGGLE_DESIGN_MODE on class CL_ORA_ACTION_ASH has no exception.

Method RESTRICT_CHARTTYPES Signature

Method RESTRICT_CHARTTYPES on class CL_ORA_ACTION_ASH has no parameter.
Method RESTRICT_CHARTTYPES on class CL_ORA_ACTION_ASH has no exception.

Method SEL_EVENTS_FOR_CLASS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_WECLASS	Call by reference	☐	Type reference (TYPE)	ORA_EVENT_NAME		Name of a wait event class	20051025

Method SEL_EVENTS_FOR_CLASS on class CL_ORA_ACTION_ASH has no exception.

Method SET_GENERAL_SELECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_GENERAL_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_GENERAL_SELECTION		General selections / settings for Oracle ASH Monitor	20051024

Method SET_GENERAL_SELECTION on class CL_ORA_ACTION_ASH has no exception.

Method SET_GRAPH_SELECTION Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_GRAPH_SELECTION	Call by reference	☐	Type reference (TYPE)	ORA_S_ASH_GRAPH_SELECTION1		Selections / Settings for Oracle ASH Monitor graphic	20050923

Method SET_GRAPH_SELECTION on class CL_ORA_ACTION_ASH has no exception.

Method SWITCH_TO_ENGLISH Signature

Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_ASH has no parameter.
Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_ASH has no exception.

Method UNPACK_TIMESTAMP Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_DATE	Call by reference	☐	Type reference (TYPE)	SYDATS		date	20051027
2	Exporting	E_MILLI	Call by reference	☐	Type reference (TYPE)	CHAR3		milliseconds (SPACE if undefined)	20051027
3	Exporting	E_TIME	Call by reference	☐	Type reference (TYPE)	SYTIME		time	20051027
4	Importing	I_TIMESTAMP	Call by reference	☐	Type reference (TYPE)	ORA_SAMPLE_TIME		Sample timestamp ( format yyyymmdd;hhmmssmmm)	20051027

Method UNPACK_TIMESTAMP on class CL_ORA_ACTION_ASH has no exception.

History

Last changed by/on	SAP	20130531
SAP Release Created in	710