SAP Reports / Programs

RS_CI_CC_ANALYZE_ORA SAP ABAP Report - Examination of Top x Statements of Cursor Caches







RS_CI_CC_ANALYZE_ORA 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 RS_CI_CC_ANALYZE_ORA 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 RS_CI_CC_ANALYZE_ORA. "Basic submit
SUBMIT RS_CI_CC_ANALYZE_ORA AND RETURN. "Return to original report after report execution complete
SUBMIT RS_CI_CC_ANALYZE_ORA 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: P_TOP = Top ... of Cursor Cache
Selection Text: P_EXE = No. of Executions
Selection Text: P_DIR = Disk Reads
Selection Text: P_CPU = CPU Time
Selection Text: P_BIG = CPU Time, all Tables GK>=3
Selection Text: P_BFG = Buffer Gets
Selection Text: P_AVE = Medium CPU Time
Selection Text: P_ALL = Show Other Strategies also
Title: Examination of Top x Statements of Cursor Caches
Text Symbol: 220 = Show Statements with the Following Strategies:
Text Symbol: 212 = (Max. 255) Statements in Cursor Cache Sorted by ...
Text Symbol: 211 = For the Top
Text Symbol: 206 = Display Statements with Other Strategies also
Text Symbol: 205 = Index Range Scan (Range = Client)
Text Symbol: 204 = Hash Join
Text Symbol: 203 = Index Range Scan
Text Symbol: 202 = Full Index Scan
Text Symbol: 201 = Full Table Scan
Text Symbol: 200 = Examine Cursor Cache
Text Symbol: 116 = Buffer Gets
Text Symbol: 115 = Disk Reads
Text Symbol: 114 = CPU Time (Accesses to Large Tables only [GK >= 3])
Text Symbol: 113 = Medium Execution Time
Text Symbol: 112 = No. of Executions
Text Symbol: 111 = CPU Time
Text Symbol: 110 = Sorted by
Text Symbol: 100 = Cursor Cache Analysis of Top &1 Statements


INCLUDES used within this REPORT RS_CI_CC_ANALYZE_ORA

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:

REUSE_ALV_LIST_DISPLAY call function 'REUSE_ALV_LIST_DISPLAY' exporting * I_INTERFACE_CHECK = ' ' I_BYPASSING_BUFFER = 'X' * I_BUFFER_ACTIVE = 'X' I_CALLBACK_PROGRAM = L_REPID I_CALLBACK_PF_STATUS_SET = 'SET_PF_STATUS' I_CALLBACK_USER_COMMAND = 'UCOMM_ALV_NAVIGATION' I_STRUCTURE_NAME = 'SCI_CC_ALV' IS_LAYOUT = L_LAYOUT IT_FIELDCAT = LT_FIELDCAT * IT_EXCLUDING = * IT_SPECIAL_GROUPS = * IT_SORT = * IT_FILTER = * IS_SEL_HIDE = * I_DEFAULT = 'X' * I_SAVE = ' ' * IS_VARIANT = IT_EVENTS = GT_EVENTS[] * IT_EVENT_EXIT = * IS_PRINT = * IS_REPREP_ID = * I_SCREEN_START_COLUMN = 0 * I_SCREEN_START_LINE = 0 * I_SCREEN_END_COLUMN = 0 * I_SCREEN_END_LINE = 0 * IMPORTING * E_EXIT_CAUSED_BY_CALLER = * ES_EXIT_CAUSED_BY_USER = tables T_OUTTAB = LT_ALV exceptions * PROGRAM_ERROR = 1 others = 2 .

REUSE_ALV_EVENTS_GET call function 'REUSE_ALV_EVENTS_GET' exporting I_LIST_TYPE = 0 importing ET_EVENTS = RT_EVENTS.

REUSE_ALV_COMMENTARY_WRITE call function 'REUSE_ALV_COMMENTARY_WRITE' exporting IT_LIST_COMMENTARY = LT_LIST_TOP_OF_PAGE.

DB_EXPLAIN_PLAN call function 'DB_EXPLAIN_PLAN' exporting STATEMENT = L_STATEMENT * NO_DISPLAY = ' ' * STMT_LG = 0 * tables * VALUES = * PLAN = * ORA_PAR = exceptions * EXPLAIN_FAILED = 1 others = 2 .

RS_TOOL_ACCESS call function 'RS_TOOL_ACCESS' exporting OPERATION = 'SHOW' OBJECT_NAME = L_TABNAME OBJECT_TYPE = 'TABL' exceptions others = 3.

DB_SQL_SOURCE_DISPLAY call function 'DB_SQL_SOURCE_DISPLAY' exporting SOURCE_REF = L_NAVIGATE exceptions * SOURCE_NOT_FOUND = 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 RS_CI_CC_ANALYZE_ORA or its description.