SAP ABAP Program SAPLS_ORA_COCKPIT_2 (SAPLS_ORA_COCKPIT_2)
Basic Data
Program SAPLS_ORA_COCKPIT_2  
Program Type F Function group  
Attributes
Status    
Application S Basis  
Authorization Group  
Logical database D$S Processing without database  
Selection screen  
Editor lock Fixed point arithmetic  
Unicode checks active Start using variant  
Function Group
Include Function Module Short Description Mode
01   C_GET_DB_ORA_REDEF   Gathering SQL queries results.    
02   C_ORA_MM_SET_DATA   Initialization and getting parameters    
03   C_ORA_BW_GET_TEST   Buffer Busy Wait    
04   C_ORA_MM_GET_DATA   Initialization and getting parameters    
05   C_ORA_LM_FREE   OK Code Handler (Example 2)    
06   C_ORA_LM_INIT   Initialization and getting parameters    
07   RETRIEVE_ALERT_LOG_CONTENT   RETRIEVE ALERT LOG CONTENT.    
08   C_GET_DB_ORA_LATCH_HOLDER_SQL   Latch Monitoring    
09   C_GET_DB_ORA_LATCH_HOLDER   Latch Monitoring    
10   C_GET_DB_ORA_LATCH   Latch Monitoring    
11   C_GET_DB_ORA_CHILDREN_OF_LATCH   Latch Monitoring    
12   C_GET_DB_ORA_HOT_BLOCKS   Latch Monitoring    
13   C_DB_EXPLAIN_PLAN2   Explain plan for SQL statement    
14   C_GET_DB_ORA_TABLESPACES_AS   Automatic Segment Space Management for Tablespaces    
15   C_GET_DB_ORA_TABLE_AS   Automatic Segment Space Management    
16   C_ORA_GVT2_RETRIEVE_REPORT   builds up an internal report in order to execute it.    
17   C_ORA_AS_INIT   Initialization and getting parameters    
18   C_ORA_GVT2_GET_SAP_TAB_CONT   Retrtieves the contents of the SAP tables    
19   C_GET_DB_ORA_FILESYSTEM_REQUES   Filesystem Requests Monitoring    
20   C_ORAENQ_GET_TEST   Gets data from GV$enqueue_stat ot GVD_ENQUEUE_STAT    
21   C_ORA_BW_GET_DATA_V10   Buffer Busy Wait    
22   C_GET_DB_ORA_LATCH_V10   Latch Monitoring    
23   C_GET_DB_ORA_UNDOSTAT2   retrieves data from view V$UNDOSTAT.    
24   C_ORA_UN_FREE   Freeing resources.    
25   C_ORA_MM_GET_DATA_V10   Initialization and getting parameters    
26   C_ORA_SHOW_DETAILS_STATEMENT   Show details Statement    
27   C_GET_DB_ORA_SPF   Data collection function for the monitor Database Parameters.    
28   C_ORA_SPF_FREE   Freeing resources.    
29   C_ORA_SHOW_AS_POP_UP   Show details statement    
32   C_GET_DB_ORA_VIEWS   Gathering SQL queries results.    
34   C_ORA_VTB_INIT   Initializating objects...    
37   C_ORA_BW_GET_DATA   Buffer Busy Wait    
38   C_PAC_SELECT_DATE   Data selection.    
40   C_TABLE_EXISTENCE   Check if a table exists or not    
43   C_ORA_MON_COLUSG   Oracle Column Usage    
44   C_ORAENQ_GET_DATA   Gets data from GV$enqueue_stat ot GVD_ENQUEUE_STAT    
45   C_DB_EXPLAIN_PLAN_SCC   Explain plan for SQL statement    
46   C_GET_DB_ORA_TABLE_ACCESS   Get data for the table access monitor    
48   C_ORASCC_INIT   Initialization and getting parameters    
50   C_DB_SQL_SOURCE_DISPLAY2   Zeigt den ABAP Source-Code eines SQL Statements an    
51   C_S_ORA_COCKPIT_2_CALL_SCREEN   Call Screen via Framework    
       
Transaction Code
Transactions reference to this program
# Transaction Code Short Description
1 ORA_PERF DBACockpit: Oracle - Performance 
     
Screens
# Screen Short Description
1 0010  DB performance analysis overview 
2 0011  Pop Up Screen for Bundle Patches 
3 0201  Filesystem Requests 
4 0202  I/O per File 
5 0203  Total per Device 
6 0204  I/O per Path 
7 0205  I/O Per File 
8 0206  I/O Per File With Total Lines 
9 0401  Latch Monitor 
10 0402  Latches Overview 
11 0403  Latch Holder 
12 0404  Latch Children 
13 0405  Latch Holders SQL Sta 
14 0406  Cache Buffers Chains 
15 0407  Latch Protected State 
16 0408  Latches Overview 
17 0409  Latches Overview With Total Lines 
18 0410  View 1 
19 0411  View 2 
20 0412  Selection Screen 
21 0413  Selection Screen 
22 0701  Enqueue stat 
23 0702  V$enqueue_stat 
24 0703  V$enqueue_stat with T 
25 0900  Navigation Frame 
26 1101  ASSM 
27 1102  Tablespaces with ASSM 
28 1103  All Tablespaces 
29 1104  Tables with ASSM 
30 1105  Tables without ASSM 
31 1106  Selection Screen 
32 1511  Display V$views/GV$views. 
33 1513  GV$ views 
34 1521  Undo statistics main screen. 
35 1522  Undo statistics tab. 
36 1523  Daily summaries 
37 1524  Max space consumption 
38 1525  1523-subscreen - Day1 
39 1526  1523-subscreen - Day2 
40 1527  1523-subscreen - Day3 
41 1528  1523-subscreen - Day4 
42 1529  1523-subscreen - Day5 
43 1530  1523-subscreen - Day6 
44 1531  1523-subscreen - Day7 
45 1532  1523-subscreen - Daily statistics. 
46 1541  SPFILE. 
47 1542  Active parameters. 
48 1543  Init config file. 
49 1544  Compare params configuration. 
50 1545  Select date. 
51 1546  Parameters history. 
52 1547  SPFILE content. 
53 2201  Main screen for BBW monitor 
54 2202  Buffer Busy Waits 
55 2203  Buffer Busy Waits With Total Lines 
56 2401  Col_Usage-Monitor 
57 2402  Col_Usage-Monitor Subscreen with ALV-Container 
58 2501  Screen for Segment Statistics 
59 2502  Pop Up Screen for Segment Statistics 
60 2510  Table Access Submonitor 
61 2512  Selection Screen 
62 2601  Parallel Degree Active 
63 2700  Basic screen for event histograms 
64 2701  Timed Events - Event Histograms 
65 2702  Timed Events -Event histogram per AWR interval 
66 2703  Pop Screen for System Event Histograms 
67 2801  Screen for Parallel Executions Sessions 
68 2900  Event Metrics 
69 2901  Subscreen for KeySysMetrics 
70 2902  Subscreen for MetricValuePerMetricInterval 
71 2903  Subscreen for ChainedRows 
72 2904  Subscreen for Consistent Gets 
73 2905  Subscreen for SQLWorkareas 
74 2906  Subscreen for StatisticValuePerAWRI 
75 2907  Subscreen for DsikReads 
76 2908  Subscreen for FullTableScans 
77 2909  Subscreen for KeyFigures 
78 2910  Subscreen for Network 
79 2911  Subscreen for ParallelExecutions 
80 2912  Subscreen for Parsing 
81 2913  Subscreen for RedoWrites 
82 2914  Subscreen for CPU 
83 2915  Subscreen for DBWR 
84 3100  Fragmentation and chained row analysis monitor 
     
GUI Status
# GUI Status Short Description
1 0001  Performance Overview 
2 0201  Filesystem Requests 
3 2201  BBW 
4 2510  Table Access 
5 COLUSAGE  Status of Popup for col_usage 
6 S0010  Performance Main Monitor Version 2 
7 S1101  ASSM PF status 
8 S1102  Pick up in list 
9 S1501  Online Redefinition tables - PF Status. 
10 S1511  Display Vviews/Gviews - PF Status. 
11 S1521  Undo statistics - PF Status. 
12 S1541  SPFILE - PF Status. 
13 S1545  Select date 
14 S1600  DB Overview Script 
15 S2401  PF status for Col_Usage-Monitor 
16 S2510  Example PF status 
17 S2512  Pick up in list 
18 S401  PF status for Latch monitoring with Refresh button 
19 S402  PF status for Latch monitoring without Refresh button 
20 S403  Pick up in list 
21 S701  PF status for Enqueue Statistics monitoring 
22 STATUS_0011  Status for Bundle Patches Pop up 
23 STATUS_2501  TOP Segments Statistics 
24 STATUS_2502  Status for Segment Pop up 
25 STATUS_2601  Status for Parallel Degree Active Screen 2601 
26 STATUS_2700  GUI Status for Timed Event Monitor 
27 STATUS_2703  Status for Pop up 
28 STATUS_2801  GUI Status for Parallel Executions Sessions 
29 STATUS_2901  Status for Event Metics 
30 STATUS_3100  GUI status for fragmentation and chained row analysis 
     
GUI Title
# GUI Title Short Description
1 CUM  Selection for Col_Usage-Monitor 
2 T1101  Database Performance Monitor 
3 T1501  Database Performance Monitor 
4 T1511  Database Performance Monitor 
5 T1521  Database Performance Monitor 
6 T1541  Database Performance Monitor 
7 T201  Database Performance Monitor 
8 T2201  Database Performance Monitor 
9 T2510  Database Performance Monitor 
10 T401  Database Performance Monitor 
11 T701  Database Performance Monitor 
12 T702  Database Performance Monitor 
     
History
Last changed by/on SAP  20070813 
SAP Release Created in