SAP ABAP Program SAPLS_ORA_COCKPIT_1 (SAPLS_ORA_COCKPIT_1)
Basic Data
Program SAPLS_ORA_COCKPIT_1  
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_FILE_NAMES   get file names for file metric selection    
02   C_GET_DB_ORA_UNDOSTAT   retrieves data from view V$UNDOSTAT.    
03   C_GET_DB_ORA_SEGSTAT   V$SEGSTAT monitoring    
04   C_GET_DB_ORA_STATISTIC_NAMES   Get statistic names    
05   C_GET_DB_ORA_INSTANCE_INFO   Get info about RAC instances    
06   C_POPUP_WITH_TABLE   Popup to display internal table data    
07   C_GET_DB_ALLPARAMETERS_ORA2   Get DB parameter from V$parameter    
08   C_SCAN_ORA_SELECT_STATEMENT   scan oracle select statement for columns and tables    
09   C_MONITOR_LK_INIT_3   Initialization Module for Lock Monitor    
10   C_ORA_CREATE_SNAPSHOT   Create an oracle monitor snapshot of gv$ views   R  
11   C_ORA_DELETE_SNAPSHOT   Delete an oracle monitor snapshot (gv$ view copy)    
12   C_GET_DB_ORA_MET_WAIT   Database Metrics: System Metrics    
13   C_ORA_DELETE_SNAPSHOT_WO_MASTE   Repair-Tool: Delete snapshot values without a snapshot master entry    
14   C_GET_DB_ORA_SQL_ADVISOR   Database Metrics: System Metrics    
15   C_MONITOR_SGA_TEST   Oracle database monitor "SGA":    
16   C_ORA_MON_SYSEVT_V10   Oracle System Event    
17   C_MONITOR_SGA_V10   Oracle database monitor "SGA":    
18   C_MONITOR_LK_INIT_2   Initialization Module for Lock Monitor    
19   C_GET_DB_ORA_MET_SYS_SUMMARY   Database Metrics: System Metrics    
20   C_ORA_AUXSTATS_DATA   Select the data from the sap_auxstats table (snapshots)    
21   C_ORA_FM_V_EVENT_NAME   FM for retrieving the V$EVENT_NAME data    
22   C_MONITOR_LK_INIT_1   Initialization Module for Lock Monitor    
23   C_POPUP_WITH_TABLE_DISPLAY   Popup to display internal table data    
24   C_ORA_RESUMABLE_INIT   Initialization of the resumable monitor    
25   C_MONITOR_PG_INIT_V10   Initialization Module for PGA Monitor    
26   C_GET_DB_ORA_MET_SYS   Database Metrics: System Metrics    
27   C_GET_DB_ORA_MSYS_DATES   Database Metrics: Dates for SysMetrics    
28   C_GET_DB_ORA_METRIC_NAMES   Database Metrics: System Metrics    
29   C_ORA_RESUMABLE_INIT_V10   Initialization of the resumable monitor    
30   C_MONITOR_LK_INIT   Initialization Module for Lock Monitor    
31   C_GET_DB_ORA_METRIC_DATES   Database Metrics: Dates for SysMetrics    
32   C_ORA_GET_DBHOSTNAME   Oracle: Get Database Host Name   R  
33   C_ORA_PARALLEL_QUERY_INIT   Initialization of the parallel query monitor    
34   C_ORA_PAR_QUERY_EXPLAIN_PLAN   Display the Explain Plan for a parallel query   R  
35   C_ORA_PAR_QUERY_OKCODE_HANDLER   ok code handler for the parallel query monitor    
36   C_GET_DB_ORA_MET_FILE   Database Metrics: System Metrics    
37   C_POPUP_BATCH_PARAMETER   Get batch parameters for SQLC    
41   C_ORA_CHECKPOINT_INIT   Initialization of the checkpoint monitor    
44   C_MONITOR_PG_INIT   Initialization Module for PGA Monitor    
46   C_ORA_DBA_USERS   Query dba users    
47   C_ORA_FM_GV_ASH   FM to retrieve GV$ACTIVE_SESSION_HISTORY data    
48   C_ORA_FM_FILE_REQUESTS   Function Module to return File Request information    
49   C_ORA_REORG_SNAPSHOT   Reorganize all oracle monitor snapshot tables (gvd_*, ora_*)   R  
51   C_ORA_FM_ASH_SAMPLE_TIMES   Function Module to return Min and Max sample times    
53   C_ORA_FM_SQL_INFO   Function Module to return File Request information    
54   C_GET_DB_ORA_GV_CURR_BLOCKSRV   get data from gv$current_block_server view    
57   C_ORA_MON_ALOG_CLASSIFY   Oracle monitor: Classify alert log entries    
58   C_ORA_MON_READ_ALOG_CLASSIFIED   Oracle monitor: read alert log for inst.ID and classify    
63   C_MONITOR_LK_SDD   Oracle database monitor "locks": SDD (Service data download)    
66   C_MONITOR_PG_SDD   Oracle database monitor "PGA": SDD (Service data download)    
67   C_ORA_READ_TRACEFILE_RE   Oracle: Read trace file (remote enabled)   R  
68   C_GET_DB_ORA_RELEASE   Read oracle release    
69   C_S_ORA_COCKPIT_1_CALL_SCREEN   Call Screen via Framework    
70   C_ORA_MON_SYSEVT   Oracle System Event    
71   C_MONITOR_SGA   Oracle database monitor "SGA":    
       
Transaction Code
Transactions reference to this program
# Transaction Code Short Description
1 ORA_LOCK Oracle: Lock-Monitor 
     
Screens
# Screen Short Description
1 0100  List output dialog box 
2 0150  List output dialog box 
3 0505  Pop Screen for SQL ID in Resource Memo 
4 0510  Oracle RAC SGA Monitor main screen 
5 0511  SGA - Resources memory overview 
6 0512  SGA(detail) 
7 0513  Curr. SGA resize op. 
8 0514  Dyn. SGA components 
9 0515  Comp. SGA resize op. 
10 0516  Cache advisory stat. 
11 0517  Shared pool advice 
12 0518  Buffer pool statistic 
13 0519  Current SGA resize operations full 
14 0520  Current SGA resize operations sort by component 
15 0521  Dynamic SGA components full 
16 0522  Dynamic SGA components sort by Component 
17 0523  Complete SGA resize operations full 
18 0524  Complete SGA resize operations sort by component 
19 0525  Cache advisory statistic full 
20 0526  Cache advisory statistic size for estimation 
21 0527  Shared pool advice full 
22 0528  Shared pool advice size for estimation 
23 0530  Oracle RAC PGA Monitor main screen 
24 0531  Status 
25 0532  Snapshot 
26 0533  PGA Advice 
27 0534  PGA status 
28 0535  SQL workarea 
29 0536  SQL workarea histogra 
30 0537  Workarea executions 
31 0538  Current operations 
32 0539  PGA memory usage 
33 0540  Target advice size 
34 0541  Advice Histogram 
35 0542  View SQL_WORKAREA 
36 0543  Top 10 mem. cache con 
37 0544  One-multipass workare 
38 0545  Histogramm 
39 0546  Percent optimal 
40 0547  SQL Workarea Statement Display 
41 0555  Target Advice Size 
42 0556  Advice Histogram 
43 0560  Oracle RAC Lock Monitor main screen 
44 0561  Detail Display for Lock Monitor 
45 0562  Without DBA_OBJECTS 
46 0563  With DBA_OBJECTS 
47 0564  Blocking Graph 
48 0565  DML Locks 
49 0710  System event monitor: "main subscreen" (tabstrips) 
50 0720  System event monitor: Summary of busy waits 
51 0730  System event monitor: Detailed view of system events 
52 0740  System event monitor: GV$SYSTEM_EVENT 
53 0810  Display arbitrary join of views: Editor screen 
54 0811  Arbitrary join of views: Popup batch exec. parameters 
55 0812  Arbitrary join of views: Popup batch exec. parameters 
56 0813  Enter SQL Statement 
57 0814  Result 
58 0900  Navigation Frame 
59 1111  Arbitrary join of views: Popup batch exec. parameters 
60 1115  SQL Command Editor 
61 1116  SQL Command Editor: Enter SQL Statement 
62 1117  SQL Command Editor: Result 
63 1310  TabStrip for the "CBO System Statistic" Submonitor 
64 1320  Screen for System CBO-Statistics 
65 1330  If available the screen shows all collected system statistic 
66 1340  CBO: Dictionary Stats 
67 1350  CBO: Fixed Object Stats 
68 1360  CBO: Locked/Missing Table Statistics 
69 1370  CBO: Existing Extended Statistics 
70 1380  CBO: Special Statistics 
71 1501  Main Screen for Configuration Patches 
72 1601  Container for the resumable submonitor 
73 1610  PopUp-Window, which provided add. resumable space infos 
74 1620  Detail-Screen for long text-fields from table DBA_RESUMABLE 
75 1700  ORA: sql advisor 
76 1701  subscreen for sql advisor 
77 1801  Main screen for IO Activities 
78 1901  Main Screen for IO Redo Log per hour 
79 2010  Parallel Query Monitor Main Screen 
80 2020  PopUp-Window, which provide phyical infos about a px. 
81 2030  PopUp-Window, which provide more infos about the q-coord. 
82 2040  Display the Execution Plan for a Parallel Query 
83 2610  Alert log Monitor: Main screen 
84 2620  Oracle database messages monitor: display alert log 
85 2630  Oracle database messages monitor: display trace file (popup) 
86 2710  Oracle Alert Log using V$DIAG_ALERT_EXT 
87 2720  Oracle Alert Log subscreen V$DIAG_ALERT_EXT 
88 2730  Oracle Alert Log using V$DIAG_ALERT_EXT: display trace file 
89 2910  Database messages: Selection popup 
90 2920  Checkpoints 
91 2930  Database messages: Selection popup 
92 2940  Checkpoints II 
93 3100  RAC: gv$current_block_server main screen 
94 3101  Current Block Server 
95 3200  Oracle Metrics: System Summary 
96 3201  System Summary 
97 3202  System Summary Graph 
98 3205  popup screen for system summary metrics monitor 
99 3210  Oracle Metrics: System 
100 3211  System Metrics 
101 3212  System Metrics 
102 3215  popup for system metrics monitor 
103 3220  Oracle Metrics: Wait Class 
104 3221  Wait Class 
105 3222  Wait Class Graph 
106 3225  popup for graph data-wait class metrics monitor 
107 3240  Oracle Metrics: File 
108 3241  File Metrics 
109 3242  File Metrics Graph 
110 3245  detailpopup for graph selection 
111 3500  ORA: Oracle Net 
112 3501  ORA: Oracle Net Sub 1 
113 3502  ORA: Oracle Net Sub 2 
114 3503  ORA: Oracle Net Sub 3 
115 3504  ORA: Oracle Net Sub 4 
116 3505  ORA: Oracle Net Sub 5 
117 3700  Main Screen for GVD Views 
118 3701  Sub Screen for GV$Views 
119 3702  Sub Screen for GV$ View Result 
120 3800  Main Screen for DBA Views 
121 3801  Sub Screen for DBA Views 
122 3802  Sub Screen for DBA View Result 
123 3900  Main Screen for USER Views 
124 3901  Sub Screen for USER Views 
125 3902  Sub Screen for USER View Result 
126 4000  RSORASTT: Main Screen 
127 4001  RSORASTT: Popup for upload details 
128 5000  Popup for batch parameters 
     
GUI Status
# GUI Status Short Description
1 0401  Pick up in list 
2 0530  PGA 
3 0560  Lock Monitor 
4 1601  Resumable Space Allocation 
5 1700  SQL Advisor 
6 2010  Parallel Query 
7 2920  Checkpoints 
8 3900  Status for USERViews 
9 561  Lock Monitor Detail Display 
10 JV_0810  Status SQL Editor 
11 JV_0811  Arbitrary join of views popup status 
12 JV_0812  Arbitrary join of views popup status 
13 ML_2610_ALOG_ALV  Main status database message log 
14 ML_2630_TRACE_ED  DB message log: Trace display 
15 PICK  Pick up in list 
16 PICK2  Pick up in list 
17 S1110  Status SQL Editor 
18 S1111  SQL Command Editor: popup status 
19 S1301  GUI Status for auxstats 
20 S1620  GUI Status for detail view of long statements 
21 S1700  Menu for SQL Advisor 
22 S2020  GUI Status for the Parallel Query phys infos 
23 S2710  Oracle Alert Log 
24 S2730  Oracle Alert Log: Tracefile 
25 S2910  Selection scope database messages 
26 S3100  PF status for Enqueue Statistics monitoring 
27 S3200  Menu for System Summary Metrics 
28 S3205  detailpopup status formetrics monitors 
29 S3210  Menu for System Metrics 
30 S3220  Menu for Wait Class Metrics 
31 S3230  Menu for Session Metrics 
32 S3240  Menu for File Metrics 
33 S3500  ORA: Oracle Net 
34 S4000  RSORASTT 
35 S4001  Popup for RSORASTT 
36 S5000  Popup for batch parameters 
37 S510  SGA Monitor Status 
38 SE_0710_MAIN  Main status system event monitor 
39 SE_3  System Event 3 
40 STATUS_0505  Status for Pop for Resource Memory 
41 STATUS_1501  Configuration Patches 
42 STATUS_1801  IO Activities 
43 STATUS_1901  Status for IO Redo Log Per Hour Screen 1901 
44 STATUS_3700  Status for GVDViews 
45 STATUS_3800  Status for DBAViews 
46 STATUS_3900  Status for USER Views 
     
GUI Title
# GUI Title Short Description
1 001  &1 
2 401  Database Performance Monitor 
3 501  Database Performance: Active Sessions 
4 502  Detail Display Oracle Sessionmonitor 
5 561  Lock Monitor Detail Display 
6 JV_T0810  Arbitrary Monitoring: Join SELECTs 
7 JV_T0811  Please enter background job parameters 
8 JV_T0820  Result of the SELECT statement 
9 ML_T2610  Alert log monitor 
10 ML_T2630  Alert log monitor: Trace file content 
11 SE_T0710  Database Performance Monitor 
12 T1601  Database Performance Monitor 
13 T1610  Details 
14 T1620  Details 
15 T2010  Database Performance Monitor 
16 T2020  Additional infos to a parallel query process 
17 T2030  Additional information about the parallel query coordiantor 
18 T2910  Listing of Database Checkpoints 
19 T2920  Database Performance Monitor 
20 T3100  RAC Statistics: Current Block Server 
21 T3200  Database Metrics: System Summary Metrics 
22 T3210  Database Metrics: System Metrics 
23 T3220  Database Metrics: Wait Class Metrics 
24 T3230  Database Metrics: Session Metrics 
25 T3240  Database Metrics: File Metrics 
     
History
Last changed by/on SAP  20070813 
SAP Release Created in