SAP ABAP Class CL_ORA_DP_SEGMENT (Data Provider Classes for Segments)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-CCM-MON-ORA (Application Component) Oracle Database Monitors
⤷
S_ORA_COCKPIT (Package) DBACockpit: Oracle Monitors
⤷
⤷
Properties
| Class | CL_ORA_DP_SEGMENT | |
| Short Description | Data Provider Classes for Segments | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | S_ORA_COCKPIT | DBACockpit: Oracle Monitors |
| Created | 20130108 | SAP |
| Last change | 20140121 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_ORA_DP_SEGMENT has no forward declaration.
Interfaces
Class CL_ORA_DP_SEGMENT has no interface implemented.
Friends
Class CL_ORA_DP_SEGMENT has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Instance attribute | Public | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20130108 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | Instance method | Public | Constructor | CONSTRUCTOR | 20130108 | |
| 2 | Instance method | Public | Method | 20130108 | ||
| 3 | Instance method | Public | Method | Method to display top segments per segment statistics | 20130123 | |
| 4 | Instance method | Public | Method | For fetching SQL Data | 20130123 | |
| 5 | Instance method | Public | Method | Method to query statistics for selected table name | 20130123 |
Events
Class CL_ORA_DP_SEGMENT has no event.
Types
Class CL_ORA_DP_SEGMENT has no local type.
Method Signatures
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_CON_NAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20130108 |
Method CONSTRUCTOR on class CL_ORA_DP_SEGMENT has no exception.
Method GET_FCRA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_OBJECT_NAME | Call by reference | Type reference (TYPE) | ORA_S_DBAOBJECTS | structure of objects that exist in the DBA_OBJECTS | 20130108 | |||
| 2 | P_RES_FCRA | Value transfer | Type reference (TYPE) | ORA_T_FCRA | Table type for Fragmentation and chained row analysis | 20130108 |
Method GET_FCRA on class CL_ORA_DP_SEGMENT has no exception.
Method GET_TOP_SEGMENTS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_G_SELECTION | Call by reference | Type reference (TYPE) | ORA_S_TOP_SEGMENTS_SELECTION | 20130123 | ||||
| 2 | P_RES_TOP_SEGMENTS | Value transfer | Type reference (TYPE) | ORA_T_TOP_SEGMENTS_DATA | Returning parameter for the method | 20130123 |
Method GET_TOP_SEGMENTS on class CL_ORA_DP_SEGMENT has no exception.
Method GET_TOP_SEGMENTS_SQL Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_RES_TS_SQL | Value transfer | Type reference (TYPE) | ORA_T_TOP_SEGMENTS_SQL | Table for capturing top sqls for selected Segment | 20130123 | |||
| 2 | SQL_ID | Call by reference | Type reference (TYPE) | STRING | 20130123 |
Method GET_TOP_SEGMENTS_SQL on class CL_ORA_DP_SEGMENT has no exception.
Method GET_TOP_SEGMENTS_STATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_G_SELECTION | Call by reference | Type reference (TYPE) | ORA_S_TOP_SEGMENTS_TABLE | Structure containing info related to selected table | 20130123 | |||
| 2 | P_RES_TOP_SEGMENTS_STATS | Value transfer | Type reference (TYPE) | ORA_T_TOP_SEGMENTS_STATS | Table for quering statistics for the selected table name | 20130123 |
Method GET_TOP_SEGMENTS_STATS on class CL_ORA_DP_SEGMENT has no exception.
History
| Last changed by/on | SAP | 20140121 |
| SAP Release Created in | 740 |