SAP Reports / Programs

RSORAHST SAP ABAP Report - Oracle DB statistics history: Take snapshot + reorg snapshots







RSORAHST is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Oracle DB statistics history: Take snapshot + reorg snapshots This report will be started periodically TCOLL driven via report RSORAHCL (see also online documentation of RSORAHCL)...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RSORAHST 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 RSORAHST. "Basic submit
SUBMIT RSORAHST AND RETURN. "Return to original report after report execution complete
SUBMIT RSORAHST VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: SPSNTEHR = Delete (time): Except hours
Selection Text: SPSNDEHR = Delete (weekday): Except hours
Selection Text: SO_MLRCV = On errrors send mail to
Selection Text: P_REOTSP = Tablespace for tmp. reorg data
Selection Text: P_REORGC = Reorg. compressed tables
Selection Text: P_DELETE = Delete old snapshots
Selection Text: P_DELALL = Delete all snapshots
Selection Text: P_CREATE = Create a new snapshot
Selection Text: PPSN_AGT = Delete (time): Age
Selection Text: PPSN_AGE = Age per. snapshots to delete
Selection Text: PPSN_AGD = Delete (weekday): Age
Selection Text: PPSNDEWD = Delete (weekday): Except WD
Selection Text: PMSN_AGE = Age man. snapshots to delete
Title: Oracle DB statistics history: Take snapshot + reorg snapshots
Text Symbol: S38 = Delete Snapshot after hour of day
Text Symbol: S37 = Delete Snapshot only once per day
Text Symbol: S36 = Delete all snapshots
Text Symbol: S35 = Per. snapshots - possibility to keep time
Text Symbol: S34 = Exception: Time
Text Symbol: S33 = Exception: Day of week
Text Symbol: S32 = days
Text Symbol: S31 = Delete periodic snapshots older than
Text Symbol: S30 = Per. snapshots - possibility to keep weekday+time
Text Symbol: S27 = days
Text Symbol: S26 = Delete all periodic snapshots older than
Text Symbol: S25 = Periodic snapshots
Text Symbol: S23 = days
Text Symbol: S22 = Delete all manual snapshots older than
Text Symbol: S21 = Manual snapshots
Text Symbol: S20 = Snapshot deletion
Text Symbol: S10 = Snapshot creation
Text Symbol: S00 = Common settings
Text Symbol: R01 = Reorganizing special tables
Text Symbol: M99 = Database system is not oracle:
Text Symbol: M98 = (Please use transaction ST04)
Text Symbol: M97 = Monitor is not approved for oracle release:
Text Symbol: I04 = Error during snapshot reorg. (see log + mail)
Text Symbol: I03 = Error during snapshot deletion (see log + mail)





Text Symbol: I02 = Error during snapshot creation (see log + mail)
Text Symbol: I01 = Mail receiver user does not exist:
Text Symbol: D02 = Deleting snapshots
Text Symbol: D01 = Collecting snapshots for deletion
Text Symbol: C01 = Creating new periodic snapshot


INCLUDES used within this REPORT RSORAHST

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:

DB_ORA_GET_RELEASE ** CALL FUNCTION 'DB_ORA_GET_RELEASE' ** IMPORTING ** ora_release = g_ora_release.

GET_DB_ORA_RELEASE * CALL FUNCTION 'GET_DB_ORA_RELEASE' * IMPORTING * oracle_release = orareltab * EXCEPTIONS * db_release_unknown = 1 * OTHERS = 2.

SAPGUI_PROGRESS_INDICATOR * CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' * EXPORTING * percentage = 10 * text = text-c01.

ORA_CREATE_SNAPSHOT * CALL FUNCTION 'ORA_CREATE_SNAPSHOT' * EXPORTING * i_snapshot_type = p_snapty * i_save_errlog = 'X' * it_mail_receivers = pt_mail_receivers * IMPORTING * e_rc = l_rc.

SAPGUI_PROGRESS_INDICATOR * CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' * EXPORTING * percentage = 1 * text = text-d01.

DATE_COMPUTE_DAY * CALL FUNCTION 'DATE_COMPUTE_DAY' * EXPORTING * date = ls_snapshot-sap_date * IMPORTING * day = l_weekday.

SAPGUI_PROGRESS_INDICATOR * CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' * EXPORTING * percentage = l_percent * text = text-d02.

ORA_DELETE_SNAPSHOT * CALL FUNCTION 'ORA_DELETE_SNAPSHOT' * EXPORTING * i_snapshot_id = ls_snapshot-snapshot_id * i_save_errlog = 'X' * it_mail_receivers = pt_mail_receivers * IMPORTING * e_rc = l_rc.

SAPGUI_PROGRESS_INDICATOR * CALL FUNCTION 'SAPGUI_PROGRESS_INDICATOR' * EXPORTING * percentage = 1 * text = text-r01.

ORA_REORG_SNAPSHOT * CALL FUNCTION 'ORA_REORG_SNAPSHOT' * EXPORTING * i_save_errlog = 'X' * it_mail_receivers = pt_mail_receivers * i_tablespace = p_reotsp * IMPORTING * e_rc = l_rc.



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 RSORAHST or its description.