SAP ABAP Class CL_ORA_DBH_TOPSQL (Oracle DBH Extractor : Top SQL Statements)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle MonitorsMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_EXTRACTOR | Oracle DBH Extractor (Superclass) | 20090126 |
Properties
| Class | CL_ORA_DBH_TOPSQL | |
| Short Description | Oracle DBH Extractor : Top SQL Statements | |
| Super Class | CL_ORA_DBH_EXTRACTOR | Oracle DBH Extractor (Superclass) |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | P | SAP Standard Production Program |
| Category | 0 | |
| Package | S_ORA_COCKPIT | DBACockpit: Oracle Monitors |
| Created | 20081118 | SAP |
| Last change | 20130531 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_ORA_DBH_TOPSQL has no forward declaration.
Interfaces
Class CL_ORA_DBH_TOPSQL has no interface implemented.
Friends
Class CL_ORA_DBH_TOPSQL has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | SNAP_ID |
Instance attribute | Private | Type reference (TYPE) | I | Oracle data type: Number | 20090126 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | APPENDNEXT |
Instance method | Private | Method | append next | 20090126 |
| 2 | BUILDSTMT |
Instance method | Private | Method | Build stmt | 20090126 |
| 3 | COLUMN_DEF |
Instance method | Private | Method | Define the local HEADER and mapping data | 20090126 |
Events
Class CL_ORA_DBH_TOPSQL has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | TOPSQL_L | Private | See coding | 20090126 | begin of topsql_l,
snap_id type i,
sorted_by type string,
sql_id type string,
module type string,
sql_text(999) type c,
executions type string,
records type string,
value type string,
seconds type string,
end of topsql_l
|
Method Signatures
Method APPENDNEXT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
PINFO | Call by reference | Type reference (TYPE) | DBCOLL_T | 20090126 | |||
| 2 |  Importing |
SNAP_INFO_T | Call by reference | Type reference (TYPE) | SNAP_INFO_T | 20090126 | |||
| 3 | Changing |
WA_TOPSQL | Call by reference | Type reference (TYPE) | TOPSQL_L | 20090126 |
Method APPENDNEXT on class CL_ORA_DBH_TOPSQL has no exception.
Method BUILDSTMT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
NUM_SNAP_ID | Call by reference | Type reference (TYPE) | I | 20090126 | |||
| 2 |  Returning |
SQL_STMT | Value transfer | Type reference (TYPE) | STRING | 20090126 |
Method BUILDSTMT on class CL_ORA_DBH_TOPSQL has no exception.
Method COLUMN_DEF Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20090126 |
Method COLUMN_DEF on class CL_ORA_DBH_TOPSQL has no exception.
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 732 |
