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 ORACC 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 C_COLOR_DARK Constant Private Type reference (TYPE) CHAR04 'C211' dark colored line 20060202
2 C_COLOR_LIGHT Constant Private Type reference (TYPE) CHAR04 'C200' light colored line 20060202
3 C_COLOR_TRC Constant Private Type reference (TYPE) CHAR04 'C600' red colored line with trace file 20060202
4 C_FC_DMLHELP Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_DMLHELP' Function code: Help 20060223
5 C_FC_NEXTDAY Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_NEXTDAY' Function code: Scroll to next day 20060202
6 C_FC_NEXTSTUP Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_NEXTSTUP' Function code: Scroll to next startup 20060202
7 C_FC_PREVDAY Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_PREVDAY' Function code: Scroll to previous day 20060202
8 C_FC_PREVSTUP Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_PREVSTUP' Function code: Scroll to previous startup 20060202
9 C_FC_SHOWTRACE Constant Private Type reference (TYPE) UI_FUNC 'GML_FC_SHOWTRACE' Function code: Show trace file 20060202
10 DML_ALV Instance attribute Private Object reference (TYPE REF TO) CL_GUI_ALV_GRID ALV grid with DB message log 20060202
11 DML_ALV_EXCLFUNC Instance attribute Private Type reference (TYPE) UI_FUNCTIONS ALV excluded functions 20060202
12 DML_ALV_FIELDCAT Instance attribute Private Type reference (TYPE) LVC_T_FCAT ALV field catalog 20060202
13 DML_ALV_LAYOUT Instance attribute Private Type reference (TYPE) LVC_S_LAYO ALV layout settings 20060202
14 DML_CC_TRACE Instance attribute Private Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container for trace file display 20060302
15 DML_CONTAINER Instance attribute Private Object reference (TYPE REF TO) CL_GUI_CUSTOM_CONTAINER Container for ALV with DB message log 20060202
16 DML_TEXTED_TRACE Instance attribute Private Object reference (TYPE REF TO) CL_GUI_TEXTEDIT TextEdit Control for trace file display 20060302
17 SEL_MAX_LINES Instance attribute Private Type reference (TYPE) I Selection (lines):Mmax. nr. of lines to be displayed 20060202
18 SEL_READ_TIMEST_DATE Instance attribute Private Type reference (TYPE) D Selection (timeframe): Timestamp date 20060202
19 SEL_READ_TIMEST_TIME Instance attribute Private Type reference (TYPE) T Selection (timeframe): Timestamp time 20060202
20 SEL_X_READ_ALL Instance attribute Private Type reference (TYPE) XFELD Selection (content): Read all content 20060202
21 SEL_X_READ_FROM_TIME0 Instance attribute Private Type reference (TYPE) XFELD Selection (timeframe): Read from time "begin of all" 20060202
22 SEL_X_READ_FROM_TIMEST Instance attribute Private Type reference (TYPE) XFELD Selection (timeframe): Read from spec. timestamp 20060202
23 SEL_X_READ_ONLYALERTS Instance attribute Private Type reference (TYPE) XFELD Selection (content): Read only alerts 20060202
24 SEL_X_READ_WO_LSW_CPT Instance attribute Private Type reference (TYPE) XFELD Selection (content): Read all without logsw./chkpt 20060202
25 VIEW_DATA Instance attribute Public Type reference (TYPE) ORACC_ACTION_DML Data displayed 20050831
Methods
# Method Level Visibility Method type Description Created on
1 CREATE_INITIAL_ALV_SETTINGS Instance method Private Method Create initial ALV settings (field catalog, layout, exc.fc) 20060202
2 DB_CONNECT Instance method Private Method Connect to a selected database 20060202
3 DB_DISCONNECT Instance method Private Method Disconnect from the connected database 20060202
4 DISPLAY_TRACEFILE Instance method Private Method Display the content of a (selected) tracefile in a popup 20060203
5 FILTER_TRACEFILE Instance method Private Method Filter content of trace file according to a given timestamp 20060203
6 GET_SELECTION_VALUES Instance method Public Method Get values of selection attributes 20060202
7 GET_TRACEENTRY_TIMESTAMP Instance method Private Method Get the timestamp of a given trace line 20060203
8 HANDLE_TOOLBAR Instance method Private Event handling method Append own functions for ALV event toolbar 20060202
9 HANDLE_USER_COMMAND Instance method Private Event handling method Handle user command caused by ALV buttons 20060202
10 OKC_EXECUTE Instance method Private Method Retrieve selected message log data and display 20060202
11 READ_TRACEFILE Instance method Private Method Read a tracefile using alternative access methods 20060203
12 SET_SELECTION_VALUES Instance method Public Method Set values of selection attributes 20060202
13 TRACE_FREE_RESSOURCES 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 Importing 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 Importing 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 Importing I_DATE Call by reference Type reference (TYPE) ORA_ALOG_DATE Date of selected alert log entry 20060203
2 Importing I_FILENAME Call by reference Type reference (TYPE) SDBA_TEXT Path and Name of the tracefile 20060203
3 Importing I_INST_HN Call by reference Type reference (TYPE) ORA_HOST_NAME Instance host name 20060203
4 Importing I_INST_NM Call by reference Type reference (TYPE) ORA_INSTANCE_NAME Instance name 20060203
5 Importing 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 Changing CT_TRACE Call by reference Type reference (TYPE) ORA_SDBALIST_TAB trace file content 20060203
2 Exporting E_SUBRC Call by reference Type reference (TYPE) SYSUBRC Returncode 20060203
3 Importing I_DATE Call by reference Type reference (TYPE) ORA_ALOG_DATE date of selected alert log entry 20060203
4 Importing 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 Exporting E_MAX_LINES Call by reference Type reference (TYPE) I Selection (lines):Mmax. nr. of lines to be displayed 20060202
2 Exporting E_READ_TIMEST_DATE Call by reference Type reference (TYPE) D Selection (timeframe): Timestamp date 20060202
3 Exporting 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 Changing E_CURR_DATE Call by reference Type reference (TYPE) D date (timestamp) 20060203
2 Changing E_CURR_TIME Call by reference Type reference (TYPE) T time (timestamp) 20060203
3 Importing 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 Importing E_INTERACTIVE Call by reference Attribute reference (LIKE) 20060202
2 Importing 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 Importing 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 Exporting ET_TRACE Call by reference Type reference (TYPE) ORA_SDBALIST_TAB Trace file content 20060203
2 Exporting E_SUBRC Call by reference Type reference (TYPE) SYSUBRC Returncode 20060203
3 Importing I_DBHOST Call by reference Type reference (TYPE) SDBASI-DBHOST Host 20060203
4 Importing I_FILENAME Call by reference Type reference (TYPE) SDBA_TEXT Name of the trace file (incl. path) 20060203
5 Importing I_INST_NAME Call by reference Type reference (TYPE) ORA_INSTANCE_NAME Instance name 20060203
6 Importing 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 Importing I_MAX_LINES Call by reference Type reference (TYPE) I Selection (lines):Mmax. nr. of lines to be displayed 20060202
2 Importing I_READ_TIMEST_DATE Call by reference Type reference (TYPE) D Selection (timeframe): Timestamp date 20060202
3 Importing I_READ_TIMEST_TIME Call by reference Type reference (TYPE) T Selection (timeframe): Timestamp time 20060202
4 Importing I_X_READ_ALL Call by reference Type reference (TYPE) XFELD Selection (content): Read all content 20060202
5 Importing I_X_READ_FROM_TIME0 Call by reference Type reference (TYPE) XFELD Selection (timeframe): Read from time "begin of all" 20060202
6 Importing I_X_READ_FROM_TIMEST Call by reference Type reference (TYPE) XFELD Selection (timeframe): Read from spec. timestamp 20060202
7 Importing I_X_READ_ONLYALERTS Call by reference Type reference (TYPE) XFELD Selection (content): Read only alerts 20060202
8 Importing 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