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
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.
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)
No INCLUDES are used within this REPORT code!
No SAP DATABASE tables are accessed within this REPORT code!
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.
Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.
RSORAHST - Oracle DB statistics history: Take snapshot + reorg snapshots RSORAHST - Oracle DB statistics history: Take snapshot + reorg snapshots RSORAHCL - History collector for oracle database monitors RSORAHCL - History collector for oracle database monitors RSORAF01 - FORMs RSORAENV - ST04 (Oracle): Display Environment Parameters for Selected Host