SAP Reports / Programs
RSORATAB SAP ABAP Report - DB02 (Oracle): Tables and Indexes: Detailed Analysis (Report)
RSORATAB is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.
If you would like to execute this report or see the full code listing simply enter RSORATAB into the relevant SAP transactions such as SE38 or SE80
ABAP code to call this SAP report using the submit statement
This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.
SUBMIT RSORATAB. "Basic submit
SUBMIT RSORATAB AND RETURN. "Return to original report after report execution complete
SUBMIT RSORATAB VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
See more syntax options for the ABAP SUBMIT statement
Text pool values
Title: DB02 (Oracle): Tables and Indexes: Detailed Analysis (Report)
INCLUDES used within this REPORT RSORATAB
No INCLUDES are used within this REPORT code!
TABLES used within REPORT and the associated SELECT statement:
No SAP DATABASE tables are accessed within this REPORT code!
Function Modules used within report and the associated call statement:
GET_DB_ORA_RELEASE CALL FUNCTION 'GET_DB_ORA_RELEASE' IMPORTING ORACLE_RELEASE = ORA_REL.
DB_DBUSER CALL FUNCTION 'DB_DBUSER' IMPORTING DBUSER = DB_USER.
DB02_ORA_SELECT_SEGMENTS call function 'DB02_ORA_SELECT_SEGMENTS' EXPORTING SEG_NAME = SEG_NAME TB_SPACE = TB_SPACE SEG_TYPE = SEG_TYPE KBYTES = KBYTES NR_EXTENTS = EXTENTS with_bitmap = bitmap with_compression = compress TABLES DBA_SEGMENTS = DBA_SEGMENTS73.
POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING titel = 'Alter Index' "#EC NOTEXT textline1 = 'Alter Index rebuild?' "#EC NOTEXT textline2 = 'Operation will lock table and index!' "#EC NOTEXT IMPORTING answer = answer.
DB02_ORA_TABLE_INDEX_ANALYSIS call function 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = SEG_ROOT PARTITION = SEG_NAME SEG_TYPE = SEG_TYPE ANALYSIS = 'S' TABLES DBA_SEGMENTS = DBA_SEGMENTS73I EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.
DB02_ORA_TABLE_INDEX_ANALYSIS CALL FUNCTION 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = SEG_ROOT PARTITION = SEG_NAME SEG_TYPE = SEG_TYPE ANALYSIS = 'E' TABLES DBA_EXTENTS = DBA_EXTENTS73 EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.
POPUP_TO_CONFIRM_STEP CALL FUNCTION 'POPUP_TO_CONFIRM_STEP' EXPORTING * defaultoption = e01 TEXTLINE1 = MESG2 TEXTLINE2 = MESG3 TITEL = MESG1 IMPORTING ANSWER = ANSWER.
JOB_OPEN CALL FUNCTION 'JOB_OPEN' EXPORTING DELANFREP = D JOBNAME = 'DBTABLEANALYSIS' IMPORTING JOBCOUNT = CURRENT_JOB EXCEPTIONS CANT_CREATE_JOB = 01 INVALID_JOB_DATA = 02 JOBNAME_MISSING = 03 OTHERS = 99.
JOB_CLOSE CALL FUNCTION 'JOB_CLOSE' EXPORTING JOBCOUNT = CURRENT_JOB JOBNAME = 'DBTABLEANALYSIS' STRTIMMED = 'X' EXCEPTIONS CANT_START_IMMEDIATE = 01 INVALID_STARTDATE = 02 JOBNAME_MISSING = 03 JOB_CLOSE_FAILED = 04 JOB_NOSTEPS = 05 JOB_NOTEX = 06 LOCK_FAILED = 07 OTHERS = 99.
DB02_ORA_TABLE_INDEX_ANALYSIS CALL FUNCTION 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = SEG_ROOT PARTITION = SEG_NAME SEG_TYPE = SEG_TYPE ANALYSIS = 'T' IMPORTING DBA_SEGMENTS_TAB = DBA_SEGMENTS73T DBA_TABLES = DBA_TABLES73 DBSTATTORA1 = DBSTATTORA BLOCK_SIZE = BLOCK_SIZE EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.
DB02_ORA_TABLE_INDEX_ANALYSIS CALL FUNCTION 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = SEG_ROOT PARTITION = SEG_NAME SEG_TYPE = SEG_TYPE ANALYSIS = 'I' IMPORTING DBA_SEGMENTS_TAB = DBA_SEGMENTS73A DBSTATIORA1 = DBSTATIORA INDEX_STATS = INDEX_STAT SINGLE_INDEX = DBA_INDEXES73 BLOCK_SIZE = BLOCK_SIZE EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.
DB02_ORA_TABLE_INDEX_ANALYSIS call function 'DB02_ORA_TABLE_INDEX_ANALYSIS' EXPORTING SEG_NAME = SEG_ROOT PARTITION = SEG_NAME SEG_TYPE = SEG_TYPE ANALYSIS = 'C' TABLES DBA_TAB_COLUMNS = DBA_TAB_COLUMNS73 DD03V_TAB = DD03V_TAB EXCEPTIONS NO_SELECTION = 1 OTHERS = 2.
Contribute (Add Comments)
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.
This will then be available for everyone to easily find by simply searching on the report name RSORATAB or its description.