SAP Function Modules
C_MONITOR_SGA_TEST SAP Function module - Oracle database monitor "SGA":
C_MONITOR_SGA_TEST is a standard SAP function module available within R/3 SAP systems depending on your version and release level. Below is the pattern details for this FM showing its interface including any import and export parameters, exceptions etc as well as any documentation contributions (Comments) specific to the object.
See here to view full function module documentation and code listing, simply by entering the name C_MONITOR_SGA_TEST into the relevant SAP transaction such as SE37 or SE80.
Associated Function Group:
S_ORA_COCKPIT_1
Released Date:
Not Released
Processing type: Normal fucntion module
Pattern for FM C_MONITOR_SGA_TEST - C MONITOR SGA TEST
CALL FUNCTION 'C_MONITOR_SGA_TEST' "Oracle database monitor "SGA":
EXPORTING
i_remote_system = " dbcon_name Logical name for a database connection
i_dbid = " ora_dbid Oracle monitoring: database id
i_db_rel = " ora_rel_number Oracle release number
i_inst_id = " ora_inst_id Instance ID
i_snapshot_from = " ora_snapshot_id Snapshot ID (from)
i_snapshot_to = " ora_snapshot_id Snapshot ID (to)
TABLES
bps_list = " ora_sg_bps SDD - Oracle SGA monitor: BPS
cro_list = " ora_sg_cro SDD - Oracle SGA monitor: CRO
dca_list = " ora_sg_dca SDD - Oracle SGA monitor: DCA
sdc_list = " ora_sg_sdc SDD - Oracle SGA monitor: SDC
sgastat_list = " ora_sg_sgastat SDD - Oracle SGA monitor: SGASTAT
sga_list = " ora_sg_sga SDD - Oracle SGA monitor: SGA
spa_list = " ora_sg_spa SDD - Oracle SGA monitor: SPA
sro_list = " ora_sg_sro SDD - Oracle SGA monitor: SRO
. " C_MONITOR_SGA_TEST
ABAP code example for Function Module C_MONITOR_SGA_TEST
The ABAP code below is a full code listing to execute function module C_MONITOR_SGA_TEST including all data declarations. The code uses 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 original method of declaring data variables up front. 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).
| it_bps_list | TYPE STANDARD TABLE OF ORA_SG_BPS,"TABLES PARAM |
| wa_bps_list | LIKE LINE OF it_bps_list , |
| it_cro_list | TYPE STANDARD TABLE OF ORA_SG_CRO,"TABLES PARAM |
| wa_cro_list | LIKE LINE OF it_cro_list , |
| it_dca_list | TYPE STANDARD TABLE OF ORA_SG_DCA,"TABLES PARAM |
| wa_dca_list | LIKE LINE OF it_dca_list , |
| it_sdc_list | TYPE STANDARD TABLE OF ORA_SG_SDC,"TABLES PARAM |
| wa_sdc_list | LIKE LINE OF it_sdc_list , |
| it_sgastat_list | TYPE STANDARD TABLE OF ORA_SG_SGASTAT,"TABLES PARAM |
| wa_sgastat_list | LIKE LINE OF it_sgastat_list , |
| it_sga_list | TYPE STANDARD TABLE OF ORA_SG_SGA,"TABLES PARAM |
| wa_sga_list | LIKE LINE OF it_sga_list , |
| it_spa_list | TYPE STANDARD TABLE OF ORA_SG_SPA,"TABLES PARAM |
| wa_spa_list | LIKE LINE OF it_spa_list , |
| it_sro_list | TYPE STANDARD TABLE OF ORA_SG_SRO,"TABLES PARAM |
| wa_sro_list | LIKE LINE OF it_sro_list . |
DATA(ld_i_remote_system) = 'Check type of data required'.
DATA(ld_i_dbid) = 'Check type of data required'.
DATA(ld_i_db_rel) = 'Check type of data required'.
DATA(ld_i_inst_id) = 'Check type of data required'.
DATA(ld_i_snapshot_from) = 'Check type of data required'.
DATA(ld_i_snapshot_to) = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_bps_list to it_bps_list.
"populate fields of struture and append to itab
append wa_cro_list to it_cro_list.
"populate fields of struture and append to itab
append wa_dca_list to it_dca_list.
"populate fields of struture and append to itab
append wa_sdc_list to it_sdc_list.
"populate fields of struture and append to itab
append wa_sgastat_list to it_sgastat_list.
"populate fields of struture and append to itab
append wa_sga_list to it_sga_list.
"populate fields of struture and append to itab
append wa_spa_list to it_spa_list.
"populate fields of struture and append to itab
append wa_sro_list to it_sro_list. . CALL FUNCTION 'C_MONITOR_SGA_TEST' EXPORTING i_remote_system = ld_i_remote_system i_dbid = ld_i_dbid i_db_rel = ld_i_db_rel i_inst_id = ld_i_inst_id i_snapshot_from = ld_i_snapshot_from i_snapshot_to = ld_i_snapshot_to TABLES bps_list = it_bps_list cro_list = it_cro_list dca_list = it_dca_list sdc_list = it_sdc_list sgastat_list = it_sgastat_list sga_list = it_sga_list spa_list = it_spa_list sro_list = it_sro_list . " C_MONITOR_SGA_TEST
IF SY-SUBRC EQ 0. "All OK ENDIF.
ABAP code to compare 7.40 inline data declaration with original syntax
The below ABAP code uses the older none in-line data declarations. This allows you to see the coding differences/benefits of the later inline syntax. It may also be useful if you are using an older version of SAP as some of the newer syntax above, such as the @DATA is not available until 4.70 EHP 8.
DATA:
| ld_i_remote_system | TYPE DBCON_NAME , |
| it_bps_list | TYPE STANDARD TABLE OF ORA_SG_BPS , |
| wa_bps_list | LIKE LINE OF it_bps_list, |
| ld_i_dbid | TYPE ORA_DBID , |
| it_cro_list | TYPE STANDARD TABLE OF ORA_SG_CRO , |
| wa_cro_list | LIKE LINE OF it_cro_list, |
| ld_i_db_rel | TYPE ORA_REL_NUMBER , |
| it_dca_list | TYPE STANDARD TABLE OF ORA_SG_DCA , |
| wa_dca_list | LIKE LINE OF it_dca_list, |
| ld_i_inst_id | TYPE ORA_INST_ID , |
| it_sdc_list | TYPE STANDARD TABLE OF ORA_SG_SDC , |
| wa_sdc_list | LIKE LINE OF it_sdc_list, |
| ld_i_snapshot_from | TYPE ORA_SNAPSHOT_ID , |
| it_sgastat_list | TYPE STANDARD TABLE OF ORA_SG_SGASTAT , |
| wa_sgastat_list | LIKE LINE OF it_sgastat_list, |
| ld_i_snapshot_to | TYPE ORA_SNAPSHOT_ID , |
| it_sga_list | TYPE STANDARD TABLE OF ORA_SG_SGA , |
| wa_sga_list | LIKE LINE OF it_sga_list, |
| it_spa_list | TYPE STANDARD TABLE OF ORA_SG_SPA , |
| wa_spa_list | LIKE LINE OF it_spa_list, |
| it_sro_list | TYPE STANDARD TABLE OF ORA_SG_SRO , |
| wa_sro_list | LIKE LINE OF it_sro_list. |
ld_i_remote_system = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_bps_list to it_bps_list.
ld_i_dbid = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_cro_list to it_cro_list.
ld_i_db_rel = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_dca_list to it_dca_list.
ld_i_inst_id = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_sdc_list to it_sdc_list.
ld_i_snapshot_from = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_sgastat_list to it_sgastat_list.
ld_i_snapshot_to = 'Check type of data required'.
"populate fields of struture and append to itab
append wa_sga_list to it_sga_list.
"populate fields of struture and append to itab
append wa_spa_list to it_spa_list.
"populate fields of struture and append to itab
append wa_sro_list to it_sro_list.
Contribute (Add Comments)
Please help keep this info upto date and use the comments section below to add useful hints, tips and information specific to this SAP function. This will then be available for you and other users to easily find by simply searching on the object name C_MONITOR_SGA_TEST or its description.
C_MONITOR_SGA_TEST - Oracle database monitor "SGA": C_MONITOR_SGA - Oracle database monitor "SGA": C_MONITOR_PG_SDD - Oracle database monitor "PGA": SDD (Service data download) C_MONITOR_PG_INIT_V10 - Initialization Module for PGA Monitor C_MONITOR_PG_INIT - Initialization Module for PGA Monitor C_MONITOR_LK_SDD - Oracle database monitor "locks": SDD (Service data download)