SAP ABAP Class CL_ORA_DBH_EXTRACTOR (Oracle DBH Extractor (Superclass))
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_DBA_DBH_EXTRACTOR | DBA-DBH: Generic Extractor | 20090126 |
Meta Relationship - Used By
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_CPU | Oracle DBH Extractor : System Stats CPU | 20120104 |
| 2 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_DISKREADS | Oracle DBH Extractor : System Stats CPU | 20120123 |
| 3 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_GENERIC | Oracle DBH Extractor : Database Size | 20100420 |
| 4 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PARAEXEC | Oracle DBH Extractor : System Stats CPU | 20120222 |
| 5 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PARSING | Oracle DBH Extractor : System Stats CPU | 20120208 |
| 6 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PERFKF | Oracle DBH Extractor : Performance Key Figures | 20090126 |
| 7 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_REDOWRITE | Oracle DBH Extractor : System Stats Redowrites | 20111121 |
| 8 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_SQLWORKAREAS | Oracle DBH Extractor : System Stats CPU | 20120209 |
| 9 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_TABLESCANS | Oracle DBH Extractor : System Stats CPU | 20120125 |
| 10 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_TOPSQL | Oracle DBH Extractor : Top SQL Statements | 20090126 |
| ... | Click here to see Used By full list (11 items) | |||
Properties
| Class | CL_ORA_DBH_EXTRACTOR | |
| Short Description | Oracle DBH Extractor (Superclass) | |
| Super Class | CL_DBA_DBH_EXTRACTOR | DBA-DBH: Generic Extractor |
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | S_ORA_COCKPIT | DBACockpit: Oracle Monitors |
| Created | 20080822 | SAP |
| Last change | 20130531 | 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_ORA_DBH_EXTRACTOR has no interface implemented.
Friends
Class CL_ORA_DBH_EXTRACTOR has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | COMP_CNT |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of cube row count | 20090126 | ||
| 2 | COMP_CUSTOM |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of first custom column | 20090126 | ||
| 3 | COMP_DBNAME |
Instance attribute | Protected | Type reference (TYPE) | I | 20090126 | |||
| 4 | COMP_DBREL |
Instance attribute | Protected | Type reference (TYPE) | I | 20090126 | |||
| 5 | COMP_DELTA |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of time delta | 20090126 | ||
| 6 | COMP_RHOST |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of current cluster node hostname | 20090126 | ||
| 7 | COMP_SHOST |
Instance attribute | Protected | Type reference (TYPE) | I | 20090126 | |||
| 8 | COMP_SPHHHOST |
Instance attribute | Protected | Type reference (TYPE) | I | 20100318 | |||
| 9 | COMP_TIME |
Instance attribute | Protected | Type reference (TYPE) | I | Component index of time column | 20090126 | ||
| 10 | CONNECT_DB_HOST |
Instance attribute | Protected | Type reference (TYPE) | STRING | 20110902 | |||
| 11 | EXTRACTOR_NAME |
Instance attribute | Protected | Type reference (TYPE) | STRING | 20090126 | |||
| 12 | MAPTAB |
Instance attribute | Protected | Type reference (TYPE) | COLL_BI_T | Standard table of COLL_BI_L | 20090126 | ||
| 13 | PREFIX |
Instance attribute | Protected | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | 20090126 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | ADDMAP |
Instance method | Protected | Method | Add a line to the column mapping table MAPTAB | 20090126 |
| 2 | CONSTRUCTOR |
Instance method | Public | Constructor | CONSTRUCTOR | 20090126 |
| 3 | FIXED_COMPS |
Instance method | Protected | Method | Set the global characteristics and key figures | 20090126 |
| 4 | GET_SNAP_INFO |
Instance method | Protected | Method | Get SNAPSHOT Info | 20090126 |
| 5 | INIT_HEADER |
Instance method | Protected | Method | Initialize the standard dimensions in the header structure | 20090126 |
| 6 | READ_COLL |
Instance method | Protected | Method | Read the collector data | 20090126 |
Events
Class CL_ORA_DBH_EXTRACTOR has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | COLL_BI_L | Protected | See coding | Mapping between Collector and BI technical names | 20090126 | BEGIN OF coll_bi_l ,
obj_name TYPE string,
bi_desc TYPE string,
bi_name TYPE string,
compno TYPE i,
END OF coll_bi_l
|
|
| 2 | COLL_BI_T | Protected | See coding | Standard table of COLL_BI_L | 20090126 | coll_bi_t TYPE STANDARD TABLE OF coll_bi_l
|
|
| 3 | DBCOLL_L | Protected | See coding | 20090126 | BEGIN OF dbcoll_l ,
timestmp(14) TYPE c ,
obj_name TYPE string,
bi_desc TYPE string,
cntr_value TYPE string,
END OF dbcoll_l
|
||
| 4 | DBCOLL_T | Protected | See coding | 20090126 | dbcoll_t TYPE STANDARD TABLE OF dbcoll_l
|
||
| 5 | SNAP_INFO_L | Protected | See coding | Snap ID/Timestamp DBA_HIST_SNAPSHOT | 20090126 | BEGIN OF snap_info_l,
snap_id TYPE i,
timestmp_end_utc(14) TYPE c,
END OF snap_info_l
|
|
| 6 | SNAP_INFO_T | Protected | See coding | 20090126 | snap_info_t TYPE STANDARD TABLE OF snap_info_l
|
Method Signatures
Method ADDMAP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
BI_DESC | Call by reference | Type reference (TYPE) | COLL_BI_L-BI_DESC | Mapping between Collector and BI technical names | 20090126 | ||
| 2 | Importing |
BI_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-BI_NAME | Mapping between Collector and BI technical names | 20090126 | ||
| 3 |  Changing |
HEADER | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | DBA-DBH: Header Date (245 Data; 10 Long Fields) | 20090126 | ||
| 4 | Importing |
OBJ_NAME | Call by reference | Type reference (TYPE) | COLL_BI_L-OBJ_NAME | Mapping between Collector and BI technical names | 20090126 |
Method ADDMAP on class CL_ORA_DBH_EXTRACTOR has no exception.
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
BI_SERVER | Call by reference | Type reference (TYPE) | DBA_DBH_BI_SERVER | DBA-DBH: BI Server | 20090126 | ||
| 2 | Importing |
CONFIGSTRING | Call by reference | Type reference (TYPE) | DBA_DBH_CONFIG_STRING | DBA-DBH: Configuration String | 20090126 | ||
| 3 | Importing |
DBCNAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical Name for a Database Connection | 20090126 | ||
| 4 | Importing |
PREFIX | Call by reference | Type reference (TYPE) | DB6_DBH_ROUTINE_NAME | 20090126 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090126 | |
| 2 | CX_DBA_DBH_SETUP |
DBA-DBH: Setup Corrupted | 20090616 |
Method FIXED_COMPS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
TIMESTMP | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | 20090126 | |||
| 2 | Changing |
XDATA | Call by reference | Type reference (TYPE) | DBA_DBH_LOADER_HEADER | 20090126 |
Method FIXED_COMPS on class CL_ORA_DBH_EXTRACTOR has no exception.
Method GET_SNAP_INFO Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
END_TS | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Interval end time | 20090126 | ||
| 2 |  Exporting |
SNAP_INFO_T | Value transfer | Type reference (TYPE) | SNAP_INFO_T | Snap ID and Timestamp | 20090126 | ||
| 3 | Importing |
START_TS | Call by reference | Type reference (TYPE) | DBCOLL_L-TIMESTMP | Interval start time | 20090126 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090126 |
Method INIT_HEADER 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 INIT_HEADER on class CL_ORA_DBH_EXTRACTOR has no exception.
Method READ_COLL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
PINFO | Call by reference | Type reference (TYPE) | DBCOLL_T | Return table | 20090126 | ||
| 2 | Importing |
SNAP_INFO_T | Call by reference | Type reference (TYPE) | SNAP_INFO_T | 20090126 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_DBA_DBH_EXTRACTOR |
DBA-DBH: Extractor Exception | 20090126 |
Meta Relationship - Used By (full list)
| # | Relationship type | Used by | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_CPU | Oracle DBH Extractor : System Stats CPU | 20120104 |
| 2 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_DISKREADS | Oracle DBH Extractor : System Stats CPU | 20120123 |
| 3 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_GENERIC | Oracle DBH Extractor : Database Size | 20100420 |
| 4 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PARAEXEC | Oracle DBH Extractor : System Stats CPU | 20120222 |
| 5 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PARSING | Oracle DBH Extractor : System Stats CPU | 20120208 |
| 6 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_PERFKF | Oracle DBH Extractor : Performance Key Figures | 20090126 |
| 7 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_REDOWRITE | Oracle DBH Extractor : System Stats Redowrites | 20111121 |
| 8 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_SQLWORKAREAS | Oracle DBH Extractor : System Stats CPU | 20120209 |
| 9 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_TABLESCANS | Oracle DBH Extractor : System Stats CPU | 20120125 |
| 10 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_TOPSQL | Oracle DBH Extractor : Top SQL Statements | 20090126 |
| 11 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_DBH_WAITEVENTS | Oracle DBH Extractor : Wait Events | 20090126 |
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 732 |
