SAP ABAP Class CL_ORA_ACTION_DML (ORA: Database Alert Log Monitor)
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
⤷
⤷
Meta Relationship - Using
| # | Relationship type | Using | Short Description | Created on |
|---|---|---|---|---|
| 1 | Inheritance (c INHERITING FROM c_ref) | CL_ORA_ACTION_FILEBASED | Base Class for monitors using files in the Oracle filesystem | 20110419 |
Properties
| Class | CL_ORA_ACTION_DML | |
| Short Description | ORA: Database Alert Log Monitor | |
| Super Class | CL_ORA_ACTION_FILEBASED | Base Class for monitors using files in the Oracle filesystem |
| 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 | 20050831 | SAP |
| Last change | 20130531 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
| # | Type group / Object type | Type | Type Description |
|---|---|---|---|
| 1 | Type group use (TYPE-POOLS tp) | Type group use (TYPE-POOLS tp) |
Interfaces
Class CL_ORA_ACTION_DML has no interface implemented.
Friends
Class CL_ORA_ACTION_DML has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Constant | Private | Type reference (TYPE) | CHAR04 | 'C211' | dark colored line | 20060202 | ||
| 2 | Constant | Private | Type reference (TYPE) | CHAR04 | 'C200' | light colored line | 20060202 | ||
| 3 | Constant | Private | Type reference (TYPE) | CHAR04 | 'C600' | red colored line with trace file | 20060202 | ||
| 4 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_DMLHELP' | Function code: Help | 20060223 | ||
| 5 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_NEXTDAY' | Function code: Scroll to next day | 20060202 | ||
| 6 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_NEXTSTUP' | Function code: Scroll to next startup | 20060202 | ||
| 7 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_PREVDAY' | Function code: Scroll to previous day | 20060202 | ||
| 8 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_PREVSTUP' | Function code: Scroll to previous startup | 20060202 | ||
| 9 | Constant | Private | Type reference (TYPE) | UI_FUNC | 'GML_FC_SHOWTRACE' | Function code: Show trace file | 20060202 | ||
| 10 | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_ALV_GRID | ALV grid with DB message log | 20060202 | |||
| 11 | Instance attribute | Private | Type reference (TYPE) | UI_FUNCTIONS | ALV excluded functions | 20060202 | |||
| 12 | Instance attribute | Private | Type reference (TYPE) | LVC_T_FCAT | ALV field catalog | 20060202 | |||
| 13 | Instance attribute | Private | Type reference (TYPE) | LVC_S_LAYO | ALV layout settings | 20060202 | |||
| 14 | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for trace file display | 20060302 | |||
| 15 | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_CUSTOM_CONTAINER | Container for ALV with DB message log | 20060202 | |||
| 16 | Instance attribute | Private | Object reference (TYPE REF TO) | CL_GUI_TEXTEDIT | TextEdit Control for trace file display | 20060302 | |||
| 17 | Instance attribute | Private | Type reference (TYPE) | I | Selection (lines):Mmax. nr. of lines to be displayed | 20060202 | |||
| 18 | Instance attribute | Private | Type reference (TYPE) | D | Selection (timeframe): Timestamp date | 20060202 | |||
| 19 | Instance attribute | Private | Type reference (TYPE) | T | Selection (timeframe): Timestamp time | 20060202 | |||
| 20 | Instance attribute | Private | Type reference (TYPE) | XFELD | Selection (content): Read all content | 20060202 | |||
| 21 | Instance attribute | Private | Type reference (TYPE) | XFELD | Selection (timeframe): Read from time "begin of all" | 20060202 | |||
| 22 | Instance attribute | Private | Type reference (TYPE) | XFELD | Selection (timeframe): Read from spec. timestamp | 20060202 | |||
| 23 | Instance attribute | Private | Type reference (TYPE) | XFELD | Selection (content): Read only alerts | 20060202 | |||
| 24 | Instance attribute | Private | Type reference (TYPE) | XFELD | Selection (content): Read all without logsw./chkpt | 20060202 | |||
| 25 | Instance attribute | Public | Type reference (TYPE) | ORACC_ACTION_DML | Data displayed | 20050831 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | Instance method | Private | Method | Create initial ALV settings (field catalog, layout, exc.fc) | 20060202 | |
| 2 | Instance method | Private | Method | Connect to a selected database | 20060202 | |
| 3 | Instance method | Private | Method | Disconnect from the connected database | 20060202 | |
| 4 | Instance method | Private | Method | Display the content of a (selected) tracefile in a popup | 20060203 | |
| 5 | Instance method | Private | Method | Filter content of trace file according to a given timestamp | 20060203 | |
| 6 | Instance method | Public | Method | Get values of selection attributes | 20060202 | |
| 7 | Instance method | Private | Method | Get the timestamp of a given trace line | 20060203 | |
| 8 | Instance method | Private | Event handling method | Append own functions for ALV event toolbar | 20060202 | |
| 9 | Instance method | Private | Event handling method | Handle user command caused by ALV buttons | 20060202 | |
| 10 | Instance method | Private | Method | Retrieve selected message log data and display | 20060202 | |
| 11 | Instance method | Private | Method | Read a tracefile using alternative access methods | 20060203 | |
| 12 | Instance method | Public | Method | Set values of selection attributes | 20060202 | |
| 13 | Instance method | Private | Method | Free all ressources which were allocated by trace display | 20060302 |
Events
Class CL_ORA_ACTION_DML has no event.
Types
Class CL_ORA_ACTION_DML has no local type.
Method Signatures
Method CREATE_INITIAL_ALV_SETTINGS Signature
Method CREATE_INITIAL_ALV_SETTINGS on class CL_ORA_ACTION_DML has no parameter.
Method CREATE_INITIAL_ALV_SETTINGS on class CL_ORA_ACTION_DML has no exception.
Method DB_CONNECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | I_REMOTE_SYSTEM | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20060202 |
Method DB_CONNECT on class CL_ORA_ACTION_DML has no exception.
Method DB_DISCONNECT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | I_REMOTE_SYSTEM | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical name for a database connection | 20060202 |
Method DB_DISCONNECT on class CL_ORA_ACTION_DML has no exception.
Method DISPLAY_TRACEFILE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | I_DATE | Call by reference | Type reference (TYPE) | ORA_ALOG_DATE | Date of selected alert log entry | 20060203 | |||
| 2 | I_FILENAME | Call by reference | Type reference (TYPE) | SDBA_TEXT | Path and Name of the tracefile | 20060203 | |||
| 3 | I_INST_HN | Call by reference | Type reference (TYPE) | ORA_HOST_NAME | Instance host name | 20060203 | |||
| 4 | I_INST_NM | Call by reference | Type reference (TYPE) | ORA_INSTANCE_NAME | Instance name | 20060203 | |||
| 5 | I_TIME | Call by reference | Type reference (TYPE) | ORA_ALOG_TIME | Time of selected alert log entry | 20060203 |
Method DISPLAY_TRACEFILE on class CL_ORA_ACTION_DML has no exception.
Method FILTER_TRACEFILE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | CT_TRACE | Call by reference | Type reference (TYPE) | ORA_SDBALIST_TAB | trace file content | 20060203 | |||
| 2 | E_SUBRC | Call by reference | Type reference (TYPE) | SYSUBRC | Returncode | 20060203 | |||
| 3 | I_DATE | Call by reference | Type reference (TYPE) | ORA_ALOG_DATE | date of selected alert log entry | 20060203 | |||
| 4 | I_TIME | Call by reference | Type reference (TYPE) | ORA_ALOG_TIME | time of selected alert log entry | 20060203 |
Method FILTER_TRACEFILE on class CL_ORA_ACTION_DML has no exception.
Method GET_SELECTION_VALUES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E_MAX_LINES | Call by reference | Type reference (TYPE) | I | Selection (lines):Mmax. nr. of lines to be displayed | 20060202 | |||
| 2 | E_READ_TIMEST_DATE | Call by reference | Type reference (TYPE) | D | Selection (timeframe): Timestamp date | 20060202 | |||
| 3 | E_READ_TIMEST_TIME | Call by reference | Type reference (TYPE) | T | Selection (timeframe): Timestamp time | 20060202 |
Method GET_SELECTION_VALUES on class CL_ORA_ACTION_DML has no exception.
Method GET_TRACEENTRY_TIMESTAMP Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E_CURR_DATE | Call by reference | Type reference (TYPE) | D | date (timestamp) | 20060203 | |||
| 2 | E_CURR_TIME | Call by reference | Type reference (TYPE) | T | time (timestamp) | 20060203 | |||
| 3 | I_TRACEENTRY | Value transfer | Type reference (TYPE) | SDBALIST | trace file entry (line) | 20060203 |
Method GET_TRACEENTRY_TIMESTAMP on class CL_ORA_ACTION_DML has no exception.
Method HANDLE_TOOLBAR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E_INTERACTIVE | Call by reference | Attribute reference (LIKE) | 20060202 | |||||
| 2 | E_OBJECT | Call by reference | Attribute reference (LIKE) | 20060202 |
Method HANDLE_TOOLBAR on class CL_ORA_ACTION_DML has no exception.
Method HANDLE_USER_COMMAND Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | E_UCOMM | Call by reference | Attribute reference (LIKE) | 20060202 |
Method HANDLE_USER_COMMAND on class CL_ORA_ACTION_DML has no exception.
Method OKC_EXECUTE Signature
Method OKC_EXECUTE on class CL_ORA_ACTION_DML has no parameter.
Method OKC_EXECUTE on class CL_ORA_ACTION_DML has no exception.
Method READ_TRACEFILE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | ET_TRACE | Call by reference | Type reference (TYPE) | ORA_SDBALIST_TAB | Trace file content | 20060203 | |||
| 2 | E_SUBRC | Call by reference | Type reference (TYPE) | SYSUBRC | Returncode | 20060203 | |||
| 3 | I_DBHOST | Call by reference | Type reference (TYPE) | SDBASI-DBHOST | Host | 20060203 | |||
| 4 | I_FILENAME | Call by reference | Type reference (TYPE) | SDBA_TEXT | Name of the trace file (incl. path) | 20060203 | |||
| 5 | I_INST_NAME | Call by reference | Type reference (TYPE) | ORA_INSTANCE_NAME | Instance name | 20060203 | |||
| 6 | I_SYSID | Call by reference | Type reference (TYPE) | SDBASI-SYSID | System ID / SID | 20060203 |
Method READ_TRACEFILE on class CL_ORA_ACTION_DML has no exception.
Method SET_SELECTION_VALUES Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | I_MAX_LINES | Call by reference | Type reference (TYPE) | I | Selection (lines):Mmax. nr. of lines to be displayed | 20060202 | |||
| 2 | I_READ_TIMEST_DATE | Call by reference | Type reference (TYPE) | D | Selection (timeframe): Timestamp date | 20060202 | |||
| 3 | I_READ_TIMEST_TIME | Call by reference | Type reference (TYPE) | T | Selection (timeframe): Timestamp time | 20060202 | |||
| 4 | I_X_READ_ALL | Call by reference | Type reference (TYPE) | XFELD | Selection (content): Read all content | 20060202 | |||
| 5 | I_X_READ_FROM_TIME0 | Call by reference | Type reference (TYPE) | XFELD | Selection (timeframe): Read from time "begin of all" | 20060202 | |||
| 6 | I_X_READ_FROM_TIMEST | Call by reference | Type reference (TYPE) | XFELD | Selection (timeframe): Read from spec. timestamp | 20060202 | |||
| 7 | I_X_READ_ONLYALERTS | Call by reference | Type reference (TYPE) | XFELD | Selection (content): Read only alerts | 20060202 | |||
| 8 | I_X_READ_WO_LSW_CPT | Call by reference | Type reference (TYPE) | XFELD | Selection (content): Read all without logsw./chkpt | 20060202 |
Method SET_SELECTION_VALUES on class CL_ORA_ACTION_DML has no exception.
Method TRACE_FREE_RESSOURCES Signature
Method TRACE_FREE_RESSOURCES on class CL_ORA_ACTION_DML has no parameter.
Method TRACE_FREE_RESSOURCES on class CL_ORA_ACTION_DML has no exception.
History
| Last changed by/on | SAP | 20130531 |
| SAP Release Created in | 710 |