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
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 FrameworkProperties
| 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 |
