SAP ABAP Class CL_ORA_DBC_SQL_REQUEST_9 (Data Collector for SQL Request)

Hierarchy

☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
     ⤷ S_DBCOCKPIT_ORA (Package) Oracle Monitoring with DBCOCKPIT Framework

Properties

Class	CL_ORA_DBC_SQL_REQUEST_9
Short Description	Data Collector for SQL Request
Super Class
Instantiability of a Class	2	Public
Final	☑

General Data

Message Class
Program status
Category	0
Package	S_DBCOCKPIT_ORA	Oracle Monitoring with DBCOCKPIT Framework
Created	20061127	SAP
Last change	20070911	SAP
Shared Memory-enabled	☐
Fixed point arithmetic	☑
Unicode checks active	☑

Forward declarations

Class CL_ORA_DBC_SQL_REQUEST_9 has no forward declaration.

Interfaces

Class CL_ORA_DBC_SQL_REQUEST_9 has no interface implemented.

Friends

Class CL_ORA_DBC_SQL_REQUEST_9 has no friend class.

Attributes

#	Attribute	Level	Visibility	Read only	Typing	Associated Type	Initial Value	Description	Created on
1	ABAP_REST	Static Attribute	Private	☐	Type reference (TYPE)	GORAVSQLAR_DBC		Selection Criteria	20061127
2	CON_REF	Static Attribute	Private	☐	Object reference (TYPE REF TO)	CL_SQL_CONNECTION		Connection Object for ADBC	20061127
3	ORA_VERSION	Static Attribute	Private	☐	Type reference (TYPE)	STRING		Database Release	20061127
4	WA_ORAGV_SQL_S	Static Attribute	Private	☐	Type reference (TYPE)	GORASQLAREA		Global Work Area for GORASQLAREA	20061127

Methods

#	Method	Level	Visibility	Method type	Description	Created on
1	APPEND_SQLAREA	Static method	Private	Method	Add Data to GORASQLAREA	20061127
2	BUILD_STATEMENT_ALL_USERS	Static method	Private	Method	Assemble SQL Statement for ALL_USERS	20061127
3	BUILD_STATEMENT_GV_SQL	Static method	Private	Method	Assemble SQL Statement for GV$SQL	20061127
4	BUILD_STATEMENT_GV_SQLTEXT	Static method	Private	Method	Assemble SQL Statement for GV$SQLTEXT	20061127
5	COLLECT_SQLAREA	Static method	Private	Method	Group Data from GV$SQL	20061127
6	EXECUTE_QUERY_ALL_USERS	Static method	Private	Method	Select and Set the User Name in GORASQLAREA	20061127
7	EXECUTE_QUERY_GV_SQL	Static method	Private	Method	Execute Query for GV$SQL	20061127
8	EXECUTE_QUERY_GV_SQLTEXT	Static method	Private	Method	Execute Query for GV$SQLTEXT	20061127
9	GET_DATA_SQL_REQUEST	Static method	Public	Method	Main Method for Data Extraction from GV$SQL and GV$SQLTEXT	20061127
10	GET_ORA_VERSION	Static method	Private	Method	Determine the ORACLE Version	20061127
11	SKIP_SELECT_LIST	Static method	Private	Method	Remove Fields from the Select List	20061127

Events

Class CL_ORA_DBC_SQL_REQUEST_9 has no event.

Types

Class CL_ORA_DBC_SQL_REQUEST_9 has no local type.

Method Signatures

Method APPEND_SQLAREA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127

Method APPEND_SQLAREA on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method BUILD_STATEMENT_ALL_USERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20061127

Method BUILD_STATEMENT_ALL_USERS on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method BUILD_STATEMENT_GV_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20061127

Method BUILD_STATEMENT_GV_SQL on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method BUILD_STATEMENT_GV_SQLTEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_SQL	Call by reference	☐	Type reference (TYPE)	STRING			20061127

Method BUILD_STATEMENT_GV_SQLTEXT on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method COLLECT_SQLAREA Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127
2	Importing	I_GV_SQL_S	Call by reference	☐	Type reference (TYPE)	GORAV_SQL			20061127

Method COLLECT_SQLAREA on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method EXECUTE_QUERY_ALL_USERS Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20061127

Method EXECUTE_QUERY_GV_SQL Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20061127

Method EXECUTE_QUERY_GV_SQLTEXT Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLTX_T	Call by reference	☐	Type reference (TYPE)	GORAV_SQLTX_T			20061127

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐		20061127

Method GET_DATA_SQL_REQUEST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Exporting	E_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127
2	Exporting	E_ORA_GVSQLTX_T	Call by reference	☐	Type reference (TYPE)	GORAV_SQLTX_T			20061127
3	Importing	I_ABAP_REST	Call by reference	☑	Type reference (TYPE)	GORAVSQLAR_DBC			20061127
4	Importing	I_CON_NAME	Call by reference	☑	Type reference (TYPE)	DBCON_NAME			20061127

Method GET_DATA_SQL_REQUEST on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

Method GET_ORA_VERSION Signature

Method GET_ORA_VERSION on class CL_ORA_DBC_SQL_REQUEST_9 has no parameter.

#	Exception	Resumable	Description	Created on
1	CX_SQL_EXCEPTION	☐	Exception Class for SQL Error	20061127

Method SKIP_SELECT_LIST Signature

#	Type	Parameter	Pass Value	Optional	Typing Method	Associated Type	Default value	Description	Created on
1	Changing	C_ORA_GVSQLAREA_T	Call by reference	☐	Type reference (TYPE)	GORASQLAREA_T			20061127
2	Changing	C_ORA_GVSQLTX_T	Call by reference	☐	Type reference (TYPE)	GORAV_SQLTX_T			20061127

Method SKIP_SELECT_LIST on class CL_ORA_DBC_SQL_REQUEST_9 has no exception.

History

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