SAP ABAP Class CL_STUN_ORA_SQL_REQUEST (Data Collector for SQL Request)
Hierarchy
☛ SAP_BASIS (Software Component) SAP Basis Component
   ⤷ BC-DB-ORA-SYS (Application Component) Database Interface/DBMS for Oracle
     ⤷ STUN_ORA (Package) Objects for Performance Analysis (ST04): Oracle DB
Properties
Class CL_STUN_ORA_SQL_REQUEST  
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 STUN_ORA   Objects for Performance Analysis (ST04): Oracle DB 
Created 20050711   SAP 
Last change 20090618   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
# Type group / Object type Type Type Description
1 ABAP Type group use (TYPE-POOLS tp)  Type group use (TYPE-POOLS tp)
Interfaces
Class CL_STUN_ORA_SQL_REQUEST has no interface implemented.
Friends
Class CL_STUN_ORA_SQL_REQUEST 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 20050711
2 CON_REF Static Attribute Private Object reference (TYPE REF TO) CL_SQL_CONNECTION Connection Object for ADBC 20050711
3 SYS_REF Static Attribute Private Object reference (TYPE REF TO) CL_DB6_SYS DB6: Remote System Administration 20130109
4 WA_ORAGV_SQL_S Static Attribute Private Type reference (TYPE) GORASQLAREA Global Work Area for GORASQLAREA 20050711
Methods
# Method Level Visibility Method type Description Created on
1 APPEND_SQLAREA Static method Private Method Add Data to GORASQLAREA 20050711
2 BUILD_STATEMENT_ALL_USERS Static method Private Method Assemble SQL Statement for ALL_USERS 20050711
3 BUILD_STATEMENT_DBA_HIST Static method Private Method Assemble SQL Statement for DBA History 20130109
4 BUILD_STATEMENT_GV_SQL Static method Private Method Assemble SQL Statement for GV$SQL 20050711
5 BUILD_STATEMENT_GV_SQLTEXT Static method Private Method Assemble SQL Statement for GV$SQLTEXT 20050711
6 COLLECT_SQLAREA Static method Private Method Group Data from GV$SQL 20050711
7 COLLECT_SQLAREA_HIST Static method Private Method Group Data from DBA_HIST_SQLAREA 20130109
8 ENHANCE_SQLAREA Static method Private Method 20130109
9 EXECUTE_QUERY_ALL_USERS Static method Private Method Select and Set the User Name in GORASQLAREA 20050711
10 EXECUTE_QUERY_DBA_HIST Static method Private Method Execute Query for DBA History 20130109
11 EXECUTE_QUERY_GV_SQL Static method Private Method Execute Query for GV$SQL 20050711
12 EXECUTE_QUERY_GV_SQLTEXT Static method Private Method Execute Query for GV$SQLTEXT 20050711
13 GET_DATA_SQL_REQUEST Static method Public Method Main Method for Data Extraction from GV$SQL and GV$SQLTEXT 20050711
14 SKIP_SELECT_LIST Static method Private Method Remove Fields from the Select List 20050711
Events
Class CL_STUN_ORA_SQL_REQUEST has no event.
Types
# Type Visibility Typing Associated Type Description Created on Type Source
1 S_DBAH_SQLSTAT Private See coding 20130109 BEGIN OF s_dbah_sqlstat, inst_id TYPE goradbahist-inst_id, sql_id TYPE goradbahist-sql_id, sql_text TYPE goradbahist-sql_text, shar_mem TYPE goradbahist-shar_mem, sqlsorts TYPE goradbahist-sqlsorts, load_versn TYPE goradbahist-load_versn, fetches TYPE goradbahist-fetches, executions TYPE goradbahist-executions, end_of_fetches TYPE goradbahist-end_of_fetches, loads TYPE goradbahist-loads, invalidatn TYPE goradbahist-invalidatn, parse_call TYPE goradbahist-parse_call, disk_reads TYPE goradbahist-disk_reads, buffer_get TYPE goradbahist-buffer_get, recs_proce TYPE goradbahist-recs_proce, modulename TYPE goradbahist-modulename, action TYPE goradbahist-action, parsuserid TYPE goradbahist-parsuserid, cpu_time TYPE goradbahist-cpu_time, elap_time TYPE goradbahist-elap_time, direct_writes TYPE goradbahist-direct_writes, appl_wait_time TYPE goradbahist-appl_wait_time, conc_wait_time TYPE goradbahist-conc_wait_time, clust_wait_time TYPE goradbahist-clust_wait_time, usr_io_wait_time TYPE goradbahist-usr_io_wait_time, plsql_exec_time TYPE goradbahist-plsql_exec_time, END OF s_dbah_sqlstat
2 S_DBA_HIST_SQLSTAT Private See coding 20130109 BEGIN OF s_dba_hist_sqlstat, inst_id TYPE gorasqlarea-inst_id, sharable_mem TYPE gorasqlarea-sharable_mem, sorts TYPE gorasqlarea-sorts, loaded_versions TYPE gorasqlarea-loaded_versions, executions TYPE gorasqlarea-executions, fetches TYPE gorasqlarea-fetches, loads TYPE gorasqlarea-loads, invalidations TYPE gorasqlarea-invalidations, parse_calls TYPE gorasqlarea-parse_calls, disk_reads TYPE gorasqlarea-disk_reads, buffer_gets TYPE gorasqlarea-buffer_gets, rows_processed TYPE gorasqlarea-rows_processed, command_type TYPE gorasqlarea-command_type, optimizer_mode TYPE gorasqlarea-optimizer_mode, parsing_user_id TYPE gorasqlarea-parsing_user_id, parsing_schema_id TYPE gorasqlarea-parsing_schema_id, kept_versions TYPE gorasqlarea-kept_versions, module TYPE gorasqlarea-module, action TYPE gorasqlarea-action, cpu_time TYPE gorasqlarea-cpu_time, elapsed_time TYPE gorasqlarea-elapsed_time, end_fetch_cnt TYPE gorasqlarea-end_fetch_cnt, plsql_exec_time TYPE gorasqlarea-plsql_exec_time, direct_writes TYPE gorasqlarea-direct_writes, sql_id TYPE gorasqlarea-sql_id, application_wait_time TYPE gorasqlarea-application_wait_time, concurrency_wait_time TYPE gorasqlarea-concurrency_wait_time, cluster_wait_time TYPE gorasqlarea-cluster_wait_time, user_io_wait_time TYPE gorasqlarea-user_io_wait_time, sql_fulltext TYPE gorasqlarea-sql_fulltext, END OF s_dba_hist_sqlstat
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 20050711

Method APPEND_SQLAREA on class CL_STUN_ORA_SQL_REQUEST 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 20050711

Method BUILD_STATEMENT_ALL_USERS on class CL_STUN_ORA_SQL_REQUEST has no exception.

Method BUILD_STATEMENT_DBA_HIST 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 20130109

Method BUILD_STATEMENT_DBA_HIST on class CL_STUN_ORA_SQL_REQUEST 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 20050711

Method BUILD_STATEMENT_GV_SQL on class CL_STUN_ORA_SQL_REQUEST 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 20050711

Method BUILD_STATEMENT_GV_SQLTEXT on class CL_STUN_ORA_SQL_REQUEST 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 20050711
2 Importing I_GV_SQL_S Call by reference Type reference (TYPE) GORAV_SQL 20050711

Method COLLECT_SQLAREA on class CL_STUN_ORA_SQL_REQUEST has no exception.

Method COLLECT_SQLAREA_HIST Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_GORASQLAREA Call by reference Type reference (TYPE) GORASQLAREA Struktur ähnlich Oracle-Tabelle GV$SQLAREA 20130109
2 Changing C_ORA_GVSQLAREA_T Call by reference Type reference (TYPE) GORASQLAREA_T 20130109

Method COLLECT_SQLAREA_HIST on class CL_STUN_ORA_SQL_REQUEST has no exception.

Method ENHANCE_SQLAREA Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing C_GORADBAHIST_WA Call by reference Type reference (TYPE) GORADBAHIST Shared Cursor Cache DBA History 20130109
2 Changing C_ORA_GORADBAHIST_T Call by reference Type reference (TYPE) GORADBAHIST_T Shared Cursor Cache DBA History 20130109

Method ENHANCE_SQLAREA on class CL_STUN_ORA_SQL_REQUEST 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 20050711
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20050711

Method EXECUTE_QUERY_DBA_HIST 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 Tabellentyp zu SQLAREA 20130109
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20130109

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 20050711
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20050711

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 20050711
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION 20050711

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 20050711
2 Exporting E_ORA_GVSQLTX_T Call by reference Type reference (TYPE) GORAV_SQLTX_T 20050711
3 Importing I_ABAP_REST Call by reference Type reference (TYPE) GORAVSQLAR_DBC 20050711
4 Importing I_CON_NAME Call by reference Type reference (TYPE) DBCON_NAME 20050711
5 Importing I_SYS_REF Call by reference Object reference (TYPE REF TO) CL_DB6_SYS DB6: Entfernte Systemadministration 20130109

Method GET_DATA_SQL_REQUEST on class CL_STUN_ORA_SQL_REQUEST has no exception.

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 20050711
2 Changing C_ORA_GVSQLTX_T Call by reference Type reference (TYPE) GORAV_SQLTX_T 20050711

Method SKIP_SELECT_LIST on class CL_STUN_ORA_SQL_REQUEST has no exception.
History
Last changed by/on SAP  20090618 
SAP Release Created in 710