SAP Reports / Programs

comments icon Comments

RSORACBO SAP ABAP Report - Analysis for Cost-Based Optimizer (Belongs to DB02)







RSORACBO 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 RSORACBO 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 RSORACBO. "Basic submit
SUBMIT RSORACBO AND RETURN. "Return to original report after report execution complete
SUBMIT RSORACBO VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Title: Analysis for Cost-Based Optimizer (Belongs to DB02)


INCLUDES used within this REPORT RSORACBO

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_DBUSER
    CALL FUNCTION 'DB_DBUSER'
     IMPORTING
       DBUSER        = var.

DB_ORA_GET_RELEASE
*  CALL FUNCTION 'DB_ORA_GET_RELEASE'
*       IMPORTING
*            ORA_RELEASE = ORA_RELEASE
*       EXCEPTIONS
*            OTHERS      = 1.

GET_DB_ORA_RELEASE
CALL FUNCTION 'GET_DB_ORA_RELEASE'
 IMPORTING
   ORACLE_RELEASE           = orareltab
 EXCEPTIONS
   DB_RELEASE_UNKNOWN       = 1
   OTHERS                   = 2
          .

POPUP_TO_CONFIRM_STEP
    CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
         EXPORTING
              TITEL     = 'Oracle Performance Monitor'
              TEXTLINE1 = 'Optimizer_Mode is ''RULE'''
              TEXTLINE2 = 'Perform check nevertheless?' "#EC NOTEXT
         IMPORTING
              ANSWER    = ANSWER.

POPUP_TO_CONFIRM_STEP
    CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
         EXPORTING
              TITEL     = 'Oracle Performance Monitor' "#EC NOTEXT
              TEXTLINE1 = '  Operation may take a few minutes' "#EC NOTEXT
              TEXTLINE2 = ' '
         IMPORTING
              ANSWER    = ANSWER.

POPUP_TO_CONFIRM_STEP
      CALL FUNCTION 'POPUP_TO_CONFIRM_STEP'
           EXPORTING
                TEXTLINE1 = 'SAPDBA action logs' "#EC NOTEXT
                TEXTLINE2 = 'Watch Function-ID''s ald/aly !' "#EC NOTEXT
                TITEL     = 'Call Transaction DB14' "#EC NOTEXT
           IMPORTING
                ANSWER    = ANSWER.


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


   
 

RSORACBO - Analysis for Cost-Based Optimizer (Belongs to DB02)
RSORACBO - Analysis for Cost-Based Optimizer (Belongs to DB02)
RSORABUF - RSORABUF: Display of Buffer Pool Information for V$ Tables
RSORABUF - RSORABUF: Display of Buffer Pool Information for V$ Tables
RSORAAJV - Display joins of V$-, GV$- and DBA-Views (Owner SYS)
RSORAAJV - Display joins of V$-, GV$- and DBA-Views (Owner SYS)