SAP ABAP Class CL_ORA_ACTION_AWR_REPORT (ORA: AWR Report Generation)
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 FrameworkMeta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_ACTION_CONTROLLER | ORA: Abstract Action Controller | 20060308 |
Properties
| Class | CL_ORA_ACTION_AWR_REPORT | |
| Short Description | ORA: AWR Report Generation | |
| Super Class | CL_ORA_ACTION_CONTROLLER | ORA: Abstract Action Controller |
| 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 | 20060206 | SAP |
| Last change | 20110908 | 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_ACTION_AWR_REPORT has no interface implemented.
Friends
Class CL_ORA_ACTION_AWR_REPORT has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ADBC_CONNECTION |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | ADBC / SQL connection | 20060206 | ||
| 2 | AWR_CONTAINER |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for editor (display) or HTML viewer | 20060206 | ||
| 3 | AWR_EDITOR |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_TEXTEDIT | Text editor (display mode) | 20060206 | ||
| 4 | AWR_HTMLVIEWER |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_HTML_VIEWER | HTML Viewer | 20060206 | ||
| 5 | C_ADDM_REPORT |
Instance attribute | Private | Type reference (TYPE) | I | 4 | Identifier for ADDM report | 20060215 | |
| 6 | C_ASHR_REPORT |
Instance attribute | Private | Type reference (TYPE) | I | 5 | Identifier for ASH report | 20061023 | |
| 7 | C_AWRDIFF_REPORT |
Instance attribute | Private | Type reference (TYPE) | I | 2 | Identifier for AWR Difference report | 20060224 | |
| 8 | C_AWR_REPORT |
Instance attribute | Private | Type reference (TYPE) | I | 1 | Identifier for AWR report | 20060209 | |
| 9 | C_AWR_SQL_REPORT |
Instance attribute | Private | Type reference (TYPE) | I | 3 | Identifier for AWR SQL report | 20060209 | |
| 10 | G_PATH |
Instance attribute | Public | Type reference (TYPE) | STRING | ' |
Path to download html-file | 20090428 | |
| 11 | NAV_REF |
Instance attribute | Private | Attribute reference (LIKE) | 20100810 | ||||
| 12 | VIEW_DATA |
Instance attribute | Public | Type reference (TYPE) | ORA_AWR_ASH_REPORT | Data to be displayed (table with text strings) | 20060206 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | CALL_DOWNLOAD_POPUP |
Instance method | Private | Method | Call popup for html download | 20090428 |
| 2 | CHECK_BROWSER_IS_ACTIVE |
Instance method | Public | Method | Check if browser is active | 20060209 |
| 3 | CHECK_SELECT_VALUES |
Instance method | Public | Method | Check and set selection values (Snapshot IDs) | 20060207 |
| 4 | CHECK_SQLID |
Instance method | Private | Method | check SQL ID for existence | 20060210 |
| 5 | CREATE_ADBC_CONNECTION |
Instance method | Private | Method | create an ADBC connection for current (remote) system ID | 20060206 |
| 6 | DOWNLOAD_AS_HTML |
Instance method | Private | Method | Downlad html data to local file | 20090428 |
| 7 | GET_DBIO_EXPECTED_DEFAULT |
Instance method | Private | Method | Get default value for parameter DBIO_EXPECTED | 20060224 |
| 8 | GET_DB_ID |
Instance method | Private | Method | Get DB ID of connected database | 20060207 |
| 9 | GET_INST_ID |
Instance method | Private | Method | Get currently selected instance ID | 20060207 |
| 10 | GET_MINMAX_SNAPID |
Instance method | Private | Method | Get minimum and maximum SNAP IDs | 20100702 |
| 11 | GET_REMOTE_SYSTEM |
Instance method | Private | Method | Get currently selected remote system name | 20060207 |
| 12 | OKCODE_DISPLAY_HTML |
Instance method | Private | Method | Display a specific report as web page | 20060209 |
| 13 | OKCODE_DISPLAY_TEXT |
Instance method | Private | Method | Display a specific report as text in an editor | 20060209 |
| 14 | OKCODE_MONITOR_DOCU |
Instance method | Private | Method | Display online documentation for this monitor | 20060315 |
| 15 | READ_REPORT |
Instance method | Private | Method | Read report data into view_data | 20060209 |
| 16 | READ_REPORT_ADDM |
Instance method | Private | Method | Read ADDM report data into view_data | 20060215 |
| 17 | READ_SNAPSHOT_TIME |
Instance method | Private | Method | Read the time stamp for a given snapshot ID | 20060209 |
| 18 | REPAIR_REPORT_LINE |
Instance method | Private | Method | Clean NULL-Bytes in a given report data line | 20060208 |
| 19 | SET_DATA |
Instance method | Public | Method | Copy data from popup screen 4311 to attributes | 20090428 |
| 20 | SET_DEFAULT_SNAPIDS |
Instance method | Private | Method | Set default values for SNAPIDs | 20100702 |
| 21 | SWITCH_TO_ENGLISH |
Instance method | Private | Method | Switch to english if necessary | 20060222 |
| 22 | VALUE_HELP_SNAPSHOT_ID |
Instance method | Public | Method | Input help for snapshot ID | 20060207 |
| 23 | VALUE_HELP_SQLID |
Instance method | Public | Method | Input help for SQL ID | 20060209 |
Events
Class CL_ORA_ACTION_AWR_REPORT has no event.
Types
Class CL_ORA_ACTION_AWR_REPORT has no local type.
Method Signatures
Method CALL_DOWNLOAD_POPUP Signature
Method CALL_DOWNLOAD_POPUP on class CL_ORA_ACTION_AWR_REPORT has no parameter.
Method CALL_DOWNLOAD_POPUP on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method CHECK_BROWSER_IS_ACTIVE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
R_BROWSER_ACTIVE | Value transfer | Type reference (TYPE) | ABAP_BOOL | Flag: Browser is active | 20060209 |
Method CHECK_BROWSER_IS_ACTIVE on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method CHECK_SELECT_VALUES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_DATE_FROM | Call by reference | Type reference (TYPE) | ORA_HIST_BEG_INT_T | Oracle mon: Time at the beginning of the snapshot interval | 20061024 | ||
| 2 | Importing |
I_DATE_TO | Call by reference | Type reference (TYPE) | ORA_HIST_END_INT_T | Oracle mon.: Time at the end of the snapshot interval | 20061024 | ||
| 3 | Importing |
I_DBIO_EXPECTED | Call by reference | Type reference (TYPE) | ORA_DBIO_EXPECTED | DBIO_EXPECTED (avg. time to read block) | 20060224 | ||
| 4 | Importing |
I_SNAPID_FROM | Call by reference | Type reference (TYPE) | ORA_HIST_SNAPID_FROM | From oracle snapshot ID (dba_hist_snapshot) | 20060207 | ||
| 5 | Importing |
I_SNAPID_FROM2 | Call by reference | Type reference (TYPE) | ORA_HIST_SNAPID_FROM2 | ID of 2n "begin snapshot" (dba_hist_snapshot) | 20060224 | ||
| 6 | Importing |
I_SNAPID_TO | Call by reference | Type reference (TYPE) | ORA_HIST_SNAPID_TO | To oracle snapshot ID (dba_hist_snapshot) | 20060207 | ||
| 7 | Importing |
I_SNAPID_TO2 | Call by reference | Type reference (TYPE) | ORA_HIST_SNAPID_TO2 | ID of 2nd "end snapshot" (dba_hist_snapshot) | 20060224 | ||
| 8 | Importing |
I_SQLID | Call by reference | Type reference (TYPE) | ORA_SQL_ID | SQL ID | 20060209 |
Method CHECK_SELECT_VALUES on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method CHECK_SQLID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_SQLID | Call by reference | Type reference (TYPE) | ORA_SQL_ID | Oracle SQL ID that has to be checked | 20060210 | ||
| 2 | Returning |
R_SUBRC | Value transfer | Type reference (TYPE) | SYSUBRC | Return code, <> 0 if not existing | 20060210 |
Method CHECK_SQLID on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method CREATE_ADBC_CONNECTION Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_NEW_CONNECTION_NAME | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a new database connection | 20060207 | ||
| 2 | Importing |
I_OLD_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Old ADBC database connection | 20060207 | ||
| 3 | Returning |
R_CONNECTION | Value transfer | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | ADBC database connection | 20060207 |
Method CREATE_ADBC_CONNECTION on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method DOWNLOAD_AS_HTML Signature
Method DOWNLOAD_AS_HTML on class CL_ORA_ACTION_AWR_REPORT has no parameter.
Method DOWNLOAD_AS_HTML on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method GET_DBIO_EXPECTED_DEFAULT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_ADBC_CONNECTION | Call by reference | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | ADBC / SQL connection | 20060224 | ||
| 2 | Returning |
R_DBIO_EXPECTED | Value transfer | Type reference (TYPE) | ORA_DBIO_EXPECTED | Default value for DBIO_EXPECTED (Avg. time to read DB block) | 20060224 |
Method GET_DBIO_EXPECTED_DEFAULT on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method GET_DB_ID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
E_DBID | Call by reference | Type reference (TYPE) | ORA_DBID | Oracle monitoring: database id | 20060207 | ||
| 2 | Exporting |
E_DBNAME | Call by reference | Type reference (TYPE) | ORA_NAME_DB | Oracle monitoring: database name | 20060207 |
Method GET_DB_ID on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method GET_INST_ID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
R_INST_ID | Value transfer | Type reference (TYPE) | ORA_INST_ID | Currently selected instance ID | 20060207 |
Method GET_INST_ID on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method GET_MINMAX_SNAPID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
P_DATE_FROM | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20130122 | ||
| 2 | Exporting |
P_DATE_TO | Value transfer | Type reference (TYPE) | ORA_SAMPLE_TIME | Oracle monitoring: Sample timestamp | 20130122 | ||
| 3 | Exporting |
P_MAX_SNAPID | Value transfer | Type reference (TYPE) | ORA_HIST_SNAPID | Oracle snapshot ID (dba_hist_snapshot) | 20100702 | ||
| 4 | Exporting |
P_MIN_SNAPID | Value transfer | Type reference (TYPE) | ORA_HIST_SNAPID | Oracle snapshot ID (dba_hist_snapshot) | 20100702 | ||
| 5 | Importing |
P_REMSYS | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20100702 |
Method GET_MINMAX_SNAPID on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method GET_REMOTE_SYSTEM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
R_REMOTE_SYSTEM | Value transfer | Type reference (TYPE) | DBCON_NAME | Currently selected remote system | 20060207 |
Method GET_REMOTE_SYSTEM on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method OKCODE_DISPLAY_HTML Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_REPORT_TYPE | Call by reference | Type reference (TYPE) | I | Identifier for the report type that has to be displayed | 20060209 |
Method OKCODE_DISPLAY_HTML on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method OKCODE_DISPLAY_TEXT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_REPORT_TYPE | Call by reference | Type reference (TYPE) | I | Identifier for the report type that has to be displayed | 20060209 |
Method OKCODE_DISPLAY_TEXT on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method OKCODE_MONITOR_DOCU Signature
Method OKCODE_MONITOR_DOCU on class CL_ORA_ACTION_AWR_REPORT has no parameter.
Method OKCODE_MONITOR_DOCU on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method READ_REPORT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_AS_TEXT | Call by reference | Type reference (TYPE) | XFELD | Flag: Read as text or HTML ('X' for text) | 20060209 | ||
| 2 | Importing |
I_REPORT_TYPE | Call by reference | Type reference (TYPE) | I | Identifier for the report type that has to be read | 20060209 |
Method READ_REPORT on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method READ_REPORT_ADDM Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_AS_TEXT | Call by reference | Type reference (TYPE) | XFELD | Flag: Read as text or HTML ('X' for text) | 20060215 |
Method READ_REPORT_ADDM on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method READ_SNAPSHOT_TIME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
B_TIMESTAMP | Call by reference | Type reference (TYPE) | ORA_HIST_BEG_INT_T | Timestamp for the snapshot (YYYY-MM-DD HH:MM:SS) | 20061030 | ||
| 2 | Exporting |
E_TIMESTAMP | Call by reference | Type reference (TYPE) | ORA_HIST_END_INT_T | Timestamp for the snapshot (YYYY-MM-DD HH:MM:SS) | 20060209 | ||
| 3 | Importing |
I_SNAPID | Call by reference | Type reference (TYPE) | ORA_HIST_SNAPID | Oracle snapshot ID (dba_hist_snapshot) | 20060209 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  SNAPSHOT_ID_NOT_FOUND |
Snapshot ID not found in the database | 20060209 |
Method REPAIR_REPORT_LINE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_REPLINE | Call by reference | Type reference (TYPE) | ORA_S_STRING | report line that has to be repaired | 20060208 | ||
| 2 | Returning |
R_REPLINE | Value transfer | Type reference (TYPE) | ORA_S_STRING | repaired report line | 20060208 |
Method REPAIR_REPORT_LINE on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method SET_DATA Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
P_PATH | Call by reference | Type reference (TYPE) | STRING | Path to download html file | 20090428 |
Method SET_DATA on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method SET_DEFAULT_SNAPIDS Signature
Method SET_DEFAULT_SNAPIDS on class CL_ORA_ACTION_AWR_REPORT has no parameter.
Method SET_DEFAULT_SNAPIDS on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method SWITCH_TO_ENGLISH Signature
Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_AWR_REPORT has no parameter.
Method SWITCH_TO_ENGLISH on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method VALUE_HELP_SNAPSHOT_ID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DYNPFIELD | Call by reference | Type reference (TYPE) | DYNFNAM | ABAP dynpro field name | 20060207 | ||
| 2 | Importing |
DYNPFIELD2 | Call by reference | Type reference (TYPE) | DYNFNAM | ABAP dynpro field for date | 20061026 | ||
| 3 | Importing |
DYNPNR | Call by reference | Type reference (TYPE) | SYDYNNR | ABAP dynpro number | 20060207 | ||
| 4 | Importing |
DYNPPROG | Call by reference | Type reference (TYPE) | SYREPID | ABAP dynpro's program name | 20060207 |
Method VALUE_HELP_SNAPSHOT_ID on class CL_ORA_ACTION_AWR_REPORT has no exception.
Method VALUE_HELP_SQLID Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
DYNPFIELD | Call by reference | Type reference (TYPE) | DYNFNAM | ABAP dynpro field name | 20060209 | ||
| 2 | Importing |
DYNPNR | Call by reference | Type reference (TYPE) | SYDYNNR | ABAP dynpro number | 20060209 | ||
| 3 | Importing |
DYNPPROG | Call by reference | Type reference (TYPE) | SYREPID | ABAP dynpro's program name | 20060209 |
Method VALUE_HELP_SQLID on class CL_ORA_ACTION_AWR_REPORT has no exception.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 710 |
