SAP C_ORA_ROOT_SELECT_OPTIMIZED_2 Function Module for Initializating objects for the Database Overview monitor...









C_ORA_ROOT_SELECT_OPTIMIZED_2 is a standard c ora root select optimized 2 SAP function module available within SAP R/3 or S/4 Hana systems, depending on your version and release level. It is used for Initializating objects for the Database Overview monitor... processing and below is the pattern details for this FM, showing its interface including any import and export parameters, exceptions etc. there is also a full "cut and paste" ABAP pattern code example, along with implementation ABAP coding, documentation and contribution comments specific to this or related objects.


See here to view full function module documentation and code listing for c ora root select optimized 2 FM, simply by entering the name C_ORA_ROOT_SELECT_OPTIMIZED_2 into the relevant SAP transaction such as SE37 or SE38.

Function Group: S_ORA_COCKPIT_5
Program Name: SAPLS_ORA_COCKPIT_5
Main Program: SAPLS_ORA_COCKPIT_5
Appliation area:
Release date: N/A
Mode(Normal, Remote etc): Normal Function Module
Update:



Function C_ORA_ROOT_SELECT_OPTIMIZED_2 pattern details

In-order to call this FM within your sap programs, simply using the below ABAP pattern details to trigger the function call...or see the full ABAP code listing at the end of this article. You can simply cut and paste this code into your ABAP progrom as it is, including variable declarations.
CALL FUNCTION 'C_ORA_ROOT_SELECT_OPTIMIZED_2'"Initializating objects for the Database Overview monitor...
  EXPORTING
   P_REM_SYS =  "Logical name for a database connection
*  SIZE_MB =  "Oracle_monitoring: selection field
*  SIZE_MB_LOGIC =  "Oracle monitoring: selection logic
*  EXTENTS =  "Oracle_monitoring: selection field
*  EXTENTS_LOGIC =  "Oracle monitoring: selection logic
*  PAR_NUM =  "Oracle_monitoring: selection field
*  PAR_NUM_LOGIC =  "Oracle monitoring: selection logic
*  LOB_NUM =  "Oracle_monitoring: selection field
*  LOB_NUM_LOGIC =  "Oracle monitoring: selection logic
*  COMPRESSION =  "Oracle_monitoring: selection field
*  COMPRESSION_LOGIC =  "Oracle monitoring: selection logic
*  OWNER =  "Oracle_monitoring: selection field
*  SEG_CREATED =  "Oracle_monitoring: selection field
*  SEG_CREATED_LOGIC =  "Oracle monitoring: selection logic
*  OWNER_LOGIC =  "Oracle monitoring: selection logic
*  ROOT_NAME =  "Oracle_monitoring: selection field
*  ROOT_NAME_LOGIC =  "Oracle monitoring: selection logic
*  ROOT_TYPE =  "Oracle_monitoring: selection field
*  ROOT_TYPE_LOGIC =  "Oracle monitoring: selection logic
*  TABLE' ' =  "Oracle_monitoring: selection field
*  TABLE' '_LOGIC =  "Oracle monitoring: selection logic

 IMPORTING
   DATE_ANALYSIS =  "Oracle monitoring
   TIME_ANALYSIS =  "Oracle monitoring: time

TABLES
   TAB_ROOT_LIST =  "Oracle monitoring: DDIC AGGRO
.



IMPORTING Parameters details for C_ORA_ROOT_SELECT_OPTIMIZED_2

P_REM_SYS - Logical name for a database connection

Data type: DBCON_NAME
Optional: No
Call by Reference: Yes

SIZE_MB - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

SIZE_MB_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXTENTS - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXTENTS_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

PAR_NUM - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

PAR_NUM_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

LOB_NUM - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

LOB_NUM_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

COMPRESSION - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

COMPRESSION_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

OWNER - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

SEG_CREATED - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

SEG_CREATED_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

OWNER_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

ROOT_NAME - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

ROOT_NAME_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

ROOT_TYPE - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

ROOT_TYPE_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLESPACE - Oracle_monitoring: selection field

Data type: DB02_SEL
Optional: Yes
Call by Reference: No ( called with pass by value option)

TABLESPACE_LOGIC - Oracle monitoring: selection logic

Data type: DB02_SEL_LOGIC
Optional: Yes
Call by Reference: No ( called with pass by value option)

EXPORTING Parameters details for C_ORA_ROOT_SELECT_OPTIMIZED_2

DATE_ANALYSIS - Oracle monitoring

Data type: DB02_DATE
Optional: No
Call by Reference: No ( called with pass by value option)

TIME_ANALYSIS - Oracle monitoring: time

Data type: DB02_TIME
Optional: No
Call by Reference: No ( called with pass by value option)

TABLES Parameters details for C_ORA_ROOT_SELECT_OPTIMIZED_2

TAB_ROOT_LIST - Oracle monitoring: DDIC AGGRO

Data type: DB02N_AGGRO
Optional: No
Call by Reference: Yes

Copy and paste ABAP code example for C_ORA_ROOT_SELECT_OPTIMIZED_2 Function Module

The ABAP code below is a full code listing to execute function module POPUP_TO_CONFIRM including all data declarations. The code uses the original data declarations rather than the latest in-line data DECLARATION SYNTAX but I have included an ABAP code snippet at the end to show how declarations would look using the newer method of declaring data variables on the fly. This will allow you to compare and fully understand the new inline method. Please note some of the newer syntax such as the @DATA is not available until a later 4.70 service pack (SP8), which i why i have stuck to the origianl for this example.

DATA:
lv_p_rem_sys  TYPE DBCON_NAME, "   
lv_date_analysis  TYPE DB02_DATE, "   
lt_tab_root_list  TYPE STANDARD TABLE OF DB02N_AGGRO, "   
lv_size_mb  TYPE DB02_SEL, "   
lv_size_mb_logic  TYPE DB02_SEL_LOGIC, "   
lv_extents  TYPE DB02_SEL, "   
lv_extents_logic  TYPE DB02_SEL_LOGIC, "   
lv_par_num  TYPE DB02_SEL, "   
lv_par_num_logic  TYPE DB02_SEL_LOGIC, "   
lv_lob_num  TYPE DB02_SEL, "   
lv_lob_num_logic  TYPE DB02_SEL_LOGIC, "   
lv_compression  TYPE DB02_SEL, "   
lv_compression_logic  TYPE DB02_SEL_LOGIC, "   
lv_owner  TYPE DB02_SEL, "   
lv_time_analysis  TYPE DB02_TIME, "   
lv_seg_created  TYPE DB02_SEL, "   
lv_seg_created_logic  TYPE DB02_SEL_LOGIC, "   
lv_owner_logic  TYPE DB02_SEL_LOGIC, "   
lv_root_name  TYPE DB02_SEL, "   
lv_root_name_logic  TYPE DB02_SEL_LOGIC, "   
lv_root_type  TYPE DB02_SEL, "   
lv_root_type_logic  TYPE DB02_SEL_LOGIC, "   
lv_tablespace  TYPE DB02_SEL, "   
lv_tablespace_logic  TYPE DB02_SEL_LOGIC. "   

  CALL FUNCTION 'C_ORA_ROOT_SELECT_OPTIMIZED_2'  "Initializating objects for the Database Overview monitor...
    EXPORTING
         P_REM_SYS = lv_p_rem_sys
         SIZE_MB = lv_size_mb
         SIZE_MB_LOGIC = lv_size_mb_logic
         EXTENTS = lv_extents
         EXTENTS_LOGIC = lv_extents_logic
         PAR_NUM = lv_par_num
         PAR_NUM_LOGIC = lv_par_num_logic
         LOB_NUM = lv_lob_num
         LOB_NUM_LOGIC = lv_lob_num_logic
         COMPRESSION = lv_compression
         COMPRESSION_LOGIC = lv_compression_logic
         OWNER = lv_owner
         SEG_CREATED = lv_seg_created
         SEG_CREATED_LOGIC = lv_seg_created_logic
         OWNER_LOGIC = lv_owner_logic
         ROOT_NAME = lv_root_name
         ROOT_NAME_LOGIC = lv_root_name_logic
         ROOT_TYPE = lv_root_type
         ROOT_TYPE_LOGIC = lv_root_type_logic
         TABLESPACE = lv_tablespace
         TABLESPACE_LOGIC = lv_tablespace_logic
    IMPORTING
         DATE_ANALYSIS = lv_date_analysis
         TIME_ANALYSIS = lv_time_analysis
    TABLES
         TAB_ROOT_LIST = lt_tab_root_list
. " C_ORA_ROOT_SELECT_OPTIMIZED_2




ABAP code using 7.40 inline data declarations to call FM C_ORA_ROOT_SELECT_OPTIMIZED_2

The below ABAP code uses the newer in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. Please note some of the newer syntax below, such as the @DATA is not available until 4.70 EHP 8.

 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 
 


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!