SAP Reports / Programs | Basis Components | Use Subcomponents | Performance Monitors (TCC)(BC-CCM-MON-TUN) SAP BC

RSORALCK SAP ABAP Report - Program RSORALCK







RSORALCK 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 RSORALCK 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 RSORALCK. "Basic submit
SUBMIT RSORALCK AND RETURN. "Return to original report after report execution complete
SUBMIT RSORALCK 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_INSTID = Instance ID
Title: Program RSORALCK
Text Symbol: 040 = SC - System commit number instance
Text Symbol: 041 = DR - Distributed recovery process
Text Symbol: 042 = SM - SMON
Text Symbol: 043 = DX - Distributed transaction entry
Text Symbol: 044 = SN - Sequence number instance
Text Symbol: 045 = FS - File set
Text Symbol: 046 = SQ - Sequence number enqueue
Text Symbol: 047 = HW - Space management operations on a specific segment
Text Symbol: 048 = SS - Sort segment
Text Symbol: 049 = IN - Instance number
Text Symbol: 050 = ST - Space transaction enqueue
Text Symbol: 051 = IR - Instance recovery serialization global enqueue
Text Symbol: 052 = SV - Sequence number value
Text Symbol: 053 = IS - Instance state
Text Symbol: 054 = TA - Generic enqueue
Text Symbol: 055 = IV - Library cache invalidation instance
Text Symbol: 056 = TS - Temporary segment enqueue (ID2=0)
Text Symbol: 057 = JQ - Job queue
Text Symbol: 059 = KK - Thread kick
Text Symbol: 060 = TT - Temporary table enqueue
Text Symbol: 061 = UN - User name
Text Symbol: 062 = MM - Mount definition global enqueue
Text Symbol: 063 = US - Undo segment DDL
Text Symbol: 064 = MR - Media recovery
Text Symbol: 065 = WL - Being-written redo log instance
Text Symbol: 066 = Library cache pin instance (A..Z = namespace)
Text Symbol: 067 = Row cache instance (A..Z = cache)
Text Symbol: 068 = Library cache lock instance lock (A..P = namespace)
Text Symbol: 069 = Unknown
Text Symbol: 070 = Instance ID
Text Symbol: 071 = SID
Text Symbol: 072 = Time
Text Symbol: 073 = Oracle Lock Details
Text Symbol: S01 = Optional history selection (leave empty for "db start" up to "now")
Text Symbol: S02 = Optional instance selection (e.g. for RAC monitors; empty for "total")
Text Symbol: 001 = Not an ORACLE DB - program aborted.





Text Symbol: 002 = Not ORACLE version 8/9 - program aborted.
Text Symbol: 003 = List header line
Text Symbol: 004 = Instance List
Text Symbol: 006 = Object Name
Text Symbol: 007 = Instance Name
Text Symbol: 008 = Status
Text Symbol: 009 = Oracle Shadow Process ID
Text Symbol: 010 = PID
Text Symbol: 012 = Oracle Lock Monitor
Text Symbol: 013 = Impossible to initialize ALV. Please open a message.
Text Symbol: 014 = Impossible to create container object. Please open a message.
Text Symbol: 015 = Impossible to create ALV object. Please open a message.
Text Symbol: 016 = Impossible to create editor control. Please open a message.
Text Symbol: 017 = 0 - none
Text Symbol: 018 = 1 - null (NULL)
Text Symbol: 019 = 2 - row-S (SS)
Text Symbol: 020 = 3 - row-X (SX)
Text Symbol: 021 = 4 - share (S)
Text Symbol: 022 = 5 - S/Row-X (SSX)
Text Symbol: 023 = 6 - exclusive (X)
Text Symbol: 024 = unknown
Text Symbol: 025 = TM - DML enqueue
Text Symbol: 026 = TX - Transaction enqueue
Text Symbol: 027 = UL - User supplied
Text Symbol: 028 = BL - Buffer hash table instance
Text Symbol: 029 = CF - Control file schema global enqueue
Text Symbol: 030 = PF - Password File
Text Symbol: 031 = CI - Cross-instance function invocation instance
Text Symbol: 032 = PI - Parallel operation
Text Symbol: 033 = PS - Parallel operation
Text Symbol: 034 = CU - Cursor bind
Text Symbol: 035 = PR - Process startup
Text Symbol: 036 = DF - Data file instance
Text Symbol: 037 = DL - Direct loader parallel index create
Text Symbol: 038 = RT - Redo thread global enqueue
Text Symbol: 039 = DM - Mount/startup db primary/secondary instance


INCLUDES used within this REPORT RSORALCK

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 = orareltab * EXCEPTIONS * db_release_unknown = 1 * OTHERS = 2.

HELP_VALUES_GET_WITH_TABLE CALL FUNCTION 'HELP_VALUES_GET_WITH_TABLE' "#EC * EXPORTING "#EC * title_in_values_list = 'List header line'(003) "#EC * titel = 'Instance List'(004) "#EC * no_conversion = 'X' "+EC * IMPORTING "#EC * select_value = p_instid "#EC * TABLES "#EC * fields = fields "#EC * valuetab = valuetab. "#EC *

DB_EXPLAIN_PLAN CALL FUNCTION 'DB_EXPLAIN_PLAN' "#EC * EXPORTING "#EC * statement = l_stmt_str "#EC * stmt_lg = l_stmt_ln "#EC * EXCEPTIONS "#EC * explain_failed = 1 "#EC * OTHERS = 2. "#EC *



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