SAP ABAP Class CL_ORA_ACTION_SQL_ADVISOR (ORA: SQL Advisor 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	20080125

Properties

Class	CL_ORA_ACTION_SQL_ADVISOR
Short Description	ORA: SQL Advisor 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	20070801	SAP
Last change	20130531	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

#	Type group / Object type	Type	Type Description
1	ORACC	Type group use (TYPE-POOLS tp)	Type group use (TYPE-POOLS tp)

Interfaces

Class CL_ORA_ACTION_SQL_ADVISOR has no interface implemented.

Friends

Class CL_ORA_ACTION_SQL_ADVISOR has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	GS_REPORT	Instance attribute	Private	☐	Type reference (TYPE)	STRING		report result	20080125
2	GT_REPORT	Instance attribute	Public	☐	Type reference (TYPE)	ORACC_ACTION_SQL_ADVISOR_WD			20080125
3	GT_RESULT_REPORT	Instance attribute	Private	☐	Type reference (TYPE)	GT_TXT_TEXTTABLE			20080125
4	GT_RESULT_TXT	Instance attribute	Private	☐	Type reference (TYPE)	GT_TXT_TEXTTABLE			20080125
5	G_RESULT_TXT	Instance attribute	Private	☐	Type reference (TYPE)	G_TXT_TEXTROW			20080125
6	G_SQL_ADVISOR_SELECTION	Instance attribute	Public	☐	Type reference (TYPE)	ORACC_ACTION_SQL_ADVISOR			20080125
7	SPOOL_CONTAINER	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GUI_CUSTOM_CONTAINER		Container for Custom Controls in the Screen Area	20080125
8	SPOOL_TEXTEDIT	Instance attribute	Public	☐	Object reference (TYPE REF TO)	CL_GUI_TEXTEDIT		SAP TextEdit Control	20080125
9	VIEW_DATA	Instance attribute	Public	☐	Type reference (TYPE)	ORACC_ACTION_SQL_ADVISOR_WD			20080125

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	FIND_SQL_ID	Instance method	Private	Method	make sure sqlid entered exists	20080125
2	GET_SQL_ID	Instance method	Public	Method	set the sqlid on the screen	20080125
3	RUN_BACKGROUND_JOB	Instance method	Public	Method	schedule a background job to execute the sql advisor	20080125
4	SET_SQL_ID	Instance method	Public	Method	get sqlid from dynpro	20080125
5	VERIFY_SQL_ID	Instance method	Private	Method	make sure sqlid entered exists	20080125

Events

Class CL_ORA_ACTION_SQL_ADVISOR has no event.

Types

#	Type	Visibility	Typing	Associated Type	Description	Created on	Type Source
1	GT_TXT_TEXTTABLE	Private	See coding			20080125	GT_TXT_TEXTTABLE type STANDARD TABLE OF G_TXT_TEXTrow
2	G_TXT_TEXTROW	Private	See coding			20080125	G_TXT_TEXTROW(1000) type C

Method Signatures

Method FIND_SQL_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
2	Importing	I_SQLTEXT	Call by reference	☐	Type reference (TYPE)	STRING			20080125
3	Returning	I_SQL_ID	Value transfer	☐	Type reference (TYPE)	ORA_SQL_ID		Oracle monitoring: SQL_ID	20080125

Method FIND_SQL_ID on class CL_ORA_ACTION_SQL_ADVISOR has no exception.

Method GET_SQL_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Returning	R_SQL_AD_SELECTION	Value transfer	☐	Type reference (TYPE)	ORACC_ACTION_SQL_ADVISOR			20080125

Method GET_SQL_ID on class CL_ORA_ACTION_SQL_ADVISOR has no exception.

Method RUN_BACKGROUND_JOB Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_ISBATCH	Call by reference	☐	Type reference (TYPE)	ORA_FAILED_OVER	'YES'	Oracle monitoring: FAILED_OVER: Sess. in Failover Mode	20080125
2	Importing	I_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
3	Importing	I_SQLID	Call by reference	☐	Type reference (TYPE)	ORA_SQL_ID		Oracle monitoring: SQL_ID	20080125

Method RUN_BACKGROUND_JOB on class CL_ORA_ACTION_SQL_ADVISOR has no exception.

Method SET_SQL_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_SQL_AD_SELECTION	Call by reference	☐	Type reference (TYPE)	ORACC_ACTION_SQL_ADVISOR			20080125

Method SET_SQL_ID on class CL_ORA_ACTION_SQL_ADVISOR has no exception.

Method VERIFY_SQL_ID Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Importing	I_REMOTE_SYSTEM	Call by reference	☐	Type reference (TYPE)	DBCON_NAME		Logical name for a database connection	20080125
2	Importing	I_SQL_ID	Call by reference	☐	Type reference (TYPE)	ORA_SQL_ID		Oracle monitoring: SQL_ID	20080125
3	Exporting	R_FOUND	Value transfer	☐	Type reference (TYPE)	SYSUBRC		Return Value of ABAP Statements	20080125

Method VERIFY_SQL_ID on class CL_ORA_ACTION_SQL_ADVISOR has no exception.

History

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