SAP ABAP Class CL_ORA_SRV_JSEL (ORA: Arbitrary monitoring services)
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
Properties
Class CL_ORA_SRV_JSEL  
Short Description ORA: Arbitrary monitoring services    
Super Class    
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 20060116   SAP 
Last change 20130531   SAP 
Shared Memory-enabled    
Fixed point arithmetic    
Unicode checks active    
Forward declarations
Class CL_ORA_SRV_JSEL has no forward declaration.
Interfaces
Class CL_ORA_SRV_JSEL has no interface implemented.
Friends
Class CL_ORA_SRV_JSEL has no friend class.
Attributes
# Attribute Level Visibility Read only Typing Associated Type Initial Value Description Created on
1 GC_CTYPE_DBFIELD Constant Private Type reference (TYPE) DSQLPCOLTYPE 1 Column type "database field" 20060117
2 GC_CTYPE_EXPR Constant Private Type reference (TYPE) DSQLPCOLTYPE 2 Column type "expression" 20060117
3 GC_CTYPE_TABCASTLINE Constant Private Type reference (TYPE) DSQLPCOLTYPE 3 Column type "table cast line" 20060228
4 G_DBCON Instance attribute Private Type reference (TYPE) DBCON_NAME Logical name for a database connection 20060116
5 G_DBNAVSYST Instance attribute Private Type reference (TYPE) DB6NAVSYST System Registration Table 20060116
Methods
# Method Level Visibility Method type Description Created on
1 CALC_TSTATS_DIFFERENCE Static method Public Method Calculate the difference of 2 runtime statistics tables 20060131
2 CHANGE_SYST Instance method Public Method Change system reference 20060130
3 CHECK_TABLES Instance method Public Method Check existence and owner of tables (content allowed...) 20060117
4 CLEANUP_END_OF_STATEMENT_TAB Static method Public Method Clean up the end of an oracle SQL statement 20060116
5 CONSTRUCTOR Instance method Public Constructor CONSTRUCTOR 20060116
6 CONVERT_STMT_TAB_TO_STRING Static method Public Method Convert an oracle SQL statement from table to string 20060116
7 CREATE_ADBC_CONNECTION Instance method Public Method Create ADBC connection for use in different DB accesses 20060118
8 CREATE_SUBROUTINE_POOL Instance method Public Method Create + generate a subroutine pool containing the SQL query 20060117
9 CREATE_SUBROUTINE_POOL_SQLC Instance method Public Method Create + generate a subroutine pool containing the SQL query 20080125
10 DECODE_FILE_ID Static method Public Method Decode a file ID into a number 20060130
11 GET_ORASID_OF_WORKPROCESS Instance method Public Method Get oracle SID of the current workprocess 20060117
12 GET_SAP_CPUTIME Instance method Public Method Get SAP CPU time 20060228
13 GET_TIME_STATS Instance method Public Method Get time statistics data for a give Oracle SID 20060131
14 MAKE_FIELDNAME Static method Public Method Create a valid ABAP field name (for use within an structure) 20060116
Events
Class CL_ORA_SRV_JSEL has no event.
Types
Class CL_ORA_SRV_JSEL has no local type.
Method Signatures

Method CALC_TSTATS_DIFFERENCE Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_STATS_DIFF Value transfer Type reference (TYPE) ORA_JSEL_STATTAB Time statistics table for ORA arbitrary join monitor 20060131
2 Importing IT_STATS_T1 Call by reference Type reference (TYPE) ORA_JSEL_STATTAB Time statistics table for time t1 20060131
3 Importing IT_STATS_T2 Call by reference Type reference (TYPE) ORA_JSEL_STATTAB Time statistics table for time t2 (>t1) 20060131
4 Importing I_RUNTIME Call by reference Type reference (TYPE) I Runtime to be added in the result table 20060131

Method CALC_TSTATS_DIFFERENCE on class CL_ORA_SRV_JSEL has no exception.

Method CHANGE_SYST Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_DBCON Value transfer Type reference (TYPE) DBCON_NAME Logical name for a database connection 20060130
2 Importing I_DBNAVSYST Value transfer Type reference (TYPE) DB6NAVSYST DB6: System Registration Table 20060130

Method CHANGE_SYST on class CL_ORA_SRV_JSEL has no exception.

Method CHECK_TABLES Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_CONTENT_NOT_ALLOWED Call by reference Type reference (TYPE) XFELD Display of content is not allowed (due to owner of tab) 20060117
2 Exporting E_MSG Call by reference Type reference (TYPE) DBA_MSG Message in case of returncode <> 0 20060117
3 Exporting E_RC Call by reference Type reference (TYPE) I Result: <>0 if at least one table is unkknown or not allowed 20060117
4 Importing IT_TABLES Call by reference Type reference (TYPE) TSQLPTABLES Table: tables / views within a parsed sql statement 20060117
5 Importing I_CONTENT_REQUESTED Call by reference Type reference (TYPE) XFELD User selected to display content 20060117
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20060117

Method CLEANUP_END_OF_STATEMENT_TAB Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Changing CT_STATEMENT Call by reference Type reference (TYPE) ORA_JSEL_TEXTTAB Text table containing an Oracle SQL statement 20060116

Method CLEANUP_END_OF_STATEMENT_TAB on class CL_ORA_SRV_JSEL has no exception.

Method CONSTRUCTOR Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_DBCON Value transfer Type reference (TYPE) DBCON_NAME Logical name for a database connection 20060116
2 Importing I_DBNAVSYST Value transfer Type reference (TYPE) DB6NAVSYST DB6: System Registration Table 20060116

Method CONSTRUCTOR on class CL_ORA_SRV_JSEL has no exception.

Method CONVERT_STMT_TAB_TO_STRING Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning E_STATEMENT Value transfer Type reference (TYPE) STRING String containing the Oracle SQL statement 20060116
2 Importing IT_STATEMENT Call by reference Type reference (TYPE) ORA_JSEL_TEXTTAB Text table containing an Oracle SQL statement 20060116

Method CONVERT_STMT_TAB_TO_STRING on class CL_ORA_SRV_JSEL has no exception.

Method CREATE_ADBC_CONNECTION Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Returning R_CONNECTION Value transfer Object reference (TYPE REF TO) CL_SQL_CONNECTION Reference to created connection 20060118
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20060118

Method CREATE_SUBROUTINE_POOL Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_MSG Call by reference Type reference (TYPE) DBA_MSG Message in case of returncode <> 0 20060117
2 Exporting E_RC Call by reference Type reference (TYPE) I <> 0 if error occured 20060117
3 Exporting E_SQL_REPORT Call by reference Type reference (TYPE) PROGNAME ABAP Program Name, generated report 20060117
4 Importing IT_COLUMNS Call by reference Type reference (TYPE) TSQLPCOL list of columns to read in the statement 20060117
5 Importing IT_TABLES Call by reference Type reference (TYPE) TSQLPTABLES list of tables used in the statement 20060117
6 Importing I_BATCH_ALV_LIST Call by reference Type reference (TYPE) XFELD Flag: Create routine for classic ALV output list 20060117
7 Importing I_SQL_STATEMENT Call by reference Type reference (TYPE) STRING SQL statement 20060117
8 Importing P_IDENTIFIER Call by reference Type reference (TYPE) STRING Identifier of table ORA_SQLC_DATA 20081209
9 Importing P_MAX_COUNT Call by reference Type reference (TYPE) I Max ID_COUNT for given ID of table ORA_SQLC_DATA 20081209
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20060117

Method CREATE_SUBROUTINE_POOL_SQLC Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_MSG Call by reference Type reference (TYPE) DBA_MSG Message in case of returncode <> 0 20080125
2 Exporting E_RC Call by reference Type reference (TYPE) I <> 0 if error occured 20080125
3 Exporting E_SQL_REPORT Call by reference Type reference (TYPE) PROGNAME ABAP Program Name, generated report 20080125
4 Importing IT_COLUMNS Call by reference Type reference (TYPE) TSQLPCOL list of columns to read in the statement 20080125
5 Importing IT_TABLES Call by reference Type reference (TYPE) TSQLPTABLES list of tables used in the statement 20080125
6 Importing I_BATCH_ALV_LIST Call by reference Type reference (TYPE) XFELD Flag: Create routine for classic ALV output list 20080125
7 Importing I_SQL_STATEMENT Call by reference Type reference (TYPE) STRING SQL statement 20080125
8 Importing P_IDENTIFIER Call by reference Type reference (TYPE) STRING Identifier of table ORA_SQLC_DATA 20080125
9 Importing P_MAX_COUNT Call by reference Type reference (TYPE) I Max ID_COUNT for given ID of table ORA_SQLC_DATA 20080125
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20080125

Method DECODE_FILE_ID Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_DECODED_FID Call by reference Type reference (TYPE) I Decoded file ID, -1 in case of error 20060130
2 Importing I_ENCODED_FID Call by reference Type reference (TYPE) CHAR3 Encoded file ID 20060130

Method DECODE_FILE_ID on class CL_ORA_SRV_JSEL has no exception.

Method GET_ORASID_OF_WORKPROCESS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting E_MSG Call by reference Type reference (TYPE) DBA_MSG Message in case of returncode <> 0 20060117
2 Exporting E_ORASID Call by reference Type reference (TYPE) ORA_SID Oracle monitoring: SID (Session ID) 20060117
3 Exporting E_RC Call by reference Type reference (TYPE) I Result: <>0 if at least one table is unkknown or not allowed 20060117
4 Importing I_ADBC_CONNECTION Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION ADBC connection for db access 20060118
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20060117

Method GET_SAP_CPUTIME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TIME_STATS Call by reference Type reference (TYPE) ORA_JSEL_STATTAB Time statistics data 20060228

Method GET_SAP_CPUTIME on class CL_ORA_SRV_JSEL has no exception.

Method GET_TIME_STATS Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Exporting ET_TIME_STATS Call by reference Type reference (TYPE) ORA_JSEL_STATTAB Time statistics data 20060131
2 Exporting E_MSG Call by reference Type reference (TYPE) DBA_MSG Message in case of returncode <> 0 20060131
3 Exporting E_RC Call by reference Type reference (TYPE) I Result: <>0 if at least one table is unkknown or not allowed 20060131
4 Importing I_ADBC_CONNECTION Call by reference Object reference (TYPE REF TO) CL_SQL_CONNECTION Reference to ADBC connection for DB access 20060131
5 Importing I_ORASID Call by reference Type reference (TYPE) ORA_SID Oracle monitoring: SID of current WP 20060131
# Exception Resumable Description Created on
1 CX_SQL_EXCEPTION Ausnahmeklasse für SQL Fehler 20060131

Method MAKE_FIELDNAME Signature

# Type Parameter Pass Value Optional Typing Method Associated Type Default value Description Created on
1 Importing I_COLUMN_ALIAS Call by reference Type reference (TYPE) DSQLPCOLALIAS Alias (or unchecked field) name 20060116
2 Returning R_FIELDNAME Value transfer Type reference (TYPE) DSQLPCOLALIAS valid field name 20060116

Method MAKE_FIELDNAME on class CL_ORA_SRV_JSEL has no exception.
History
Last changed by/on SAP  20130531 
SAP Release Created in 710