SAP ABAP Program SAPLSTD9 (Update Statistics for Certain Index)
Basic Data
| Program | SAPLSTD9 | Update Statistics for Certain Index |
| 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 |  GET_DB_ORA_V_UNDOSTAT |
used by a check in service assistant. | R |
| 02 | GET_DB_ORA_UNDOSTAT |
retrieves data from view V$UNDOSTAT. | |
| 03 | GET_DB_ORA_INSTANCE_INFO |
Get info about RAC instances | |
| 04 | GET_DB_ORA_SEGSTAT |
V$SEGSTAT monitoring | |
| 05 | SCAN_ORA_SELECT_STATEMENT |
scan oracle select statement for columns and tables | |
| 06 | GET_DB_ORA_STATISTIC_NAMES |
Get statistic names | |
| 07 | POPUP_WITH_TABLE |
Popup to display internal table data | |
| 08 | ORA_READ_TRACEFILE_RE |
Oracle: Read trace file (remote enabled) | R |
| 09 | GET_DB_ORA_RELEASE |
Read oracle release | |
| 10 | GET_DB_IS_RAC |
Database is running on RAC ? | |
| 11 | ORA_CREATE_SNAPSHOT |
Create an oracle monitor snapshot of gv$ views | R |
| 12 | GET_DB_ALLPARAMETERS_ORA2 |
Get DB parameter from V$parameter | |
| 13 | ORA_DELETE_SNAPSHOT |
Delete an oracle monitor snapshot (gv$ view copy) | |
| 14 | ORA_SNAP_CHECK_DB_RESTART |
Check if there was a DB restart between snapshots | |
| 15 | ORA_DELETE_SNAPSHOT_WO_MASTER |
Repair-Tool: Delete snapshot values without a snapshot master entry | |
| 16 | MONITOR_SM_FREE |
ORA RAC Session Monitor Free Ressources Function | |
| 17 | MONITOR_SM_INIT |
Initialization Module for Session Monitor | |
| 18 | MONITOR_SM_OKCODE_HANDLER |
ORA RAC Session Monitor OK Code Handler | |
| 19 | MONITOR_SM_ORASESSION |
Oracle Session Monitor Data Collector | R |
| 20 | ORA_AUXSTATS_INIT |
Init-Function | |
| 21 | ORA_AUXSTATS_FREE |
Dealloc used memory | |
| 22 | ORA_AUXSTATS_DATA |
Select the data from the sap_auxstats table | |
| 23 | ORA_AUXSTATS_OKCODE_HANDLER |
OK Code Handler | |
| 24 | ORA_RESUMABLE_DATA |
Select data from table sap_resumable | |
| 25 | ORA_RESUMABLE_FREE |
Deallocation of all used memory resources | |
| 26 | ORA_RESUMABLE_INIT |
Initialization of the resumable monitor | |
| 27 | ORA_RESUMABLE_OKCODE_HANDLER |
ok code handler for the resumable monitor | |
| 28 | ORA_MON_DJV_INIT |
Display join of views: Initialization of data | |
| 29 | ORA_MON_DJV_OKCD |
Display join of views: OK-Code handling | |
| 30 | ORA_MON_DJV_FREE |
Display join of views: Free resources and data | |
| 31 | MONITOR_LK_FREE |
ORA RAC SGA Monitor Free Ressources Function | |
| 32 | MONITOR_LK_INIT |
Initialization Module for SGA Monitor | |
| 33 | MONITOR_LK_OKCODE_HANDLER |
ORA RAC SGA Monitor OK Code Handler | |
| 34 | ORA_PARALLEL_QUERY_FREE |
Deallocation of all used memory resources | |
| 35 | ORA_PARALLEL_QUERY_INIT |
Initialization of the parallel query monitor | |
| 36 | ORA_PAR_QUERY_EXPLAIN_PLAN |
Display the Explain Plan for a parallel query | R |
| 37 | ORA_PAR_QUERY_OKCODE_HANDLER |
ok code handler for the parallel query monitor | |
| 38 | ORA_AUXSTATS_DATA_SNAPSHOT |
Select the data from the sap_auxstats table | |
| 39 | ORA_DATAGUARD_INIT |
Free | |
| 40 | ORA_DATAGUARD_FREE |
Free | |
| 41 | ORA_DATAGUARD_OKCODE_HANDLER |
OK code Handler | |
| 42 | ORA_CHECKPOINT_FREE |
Deallocation of all used memory resources | |
| 43 | ORA_CHECKPOINT_INIT |
Initialization of the checkpoint monitor | |
| 44 | ORA_CHECKPOINT_OKCODE_HANDLER |
ok code handler for the checkpoint monitor | |
| 45 | MONITOR_PG_FREE |
ORA RAC SGA Monitor Free Ressources Function | |
| 46 | MONITOR_PG_INIT |
Initialization Module for SGA Monitor | |
| 47 | MONITOR_PG_OKCODE_HANDLER |
ORA RAC SGA Monitor OK Code Handler | |
| 48 | MONITOR_SG_FREE |
ORA RAC SGA Monitor Free Ressources Function | |
| 49 | MONITOR_SG_OKCODE_HANDLER |
ORA RAC SGA Monitor OK Code Handler | |
| 50 | MONITOR_SG_INIT |
Initialization Module for SGA Monitor | |
| 51 | ORA_REORG_SNAPSHOT |
Reorganize all oracle monitor snapshot tables (gvd_*, ora_*) | R |
| 52 | ORA_MON_DBMLOG_INIT |
Oracle database message log: Initialization | |
| 53 | ORA_MON_DBMLOG_OKHDL |
Oracle database message log: OK-Code handler | |
| 54 | ORA_MON_DBMLOG_FREE |
Oracle database message log: Free ressources | |
| 55 | ORA_MON_SYSEVENT_INIT |
Oracle database monitor "system events": Initialization | |
| 56 | ORA_MON_SYSEVENT_OKHDL |
Oracle database monitor "system events": OK-Code handler | |
| 57 | ORA_MON_SYSEVENT_FREE |
Oracle database monitor "system events": Free ressources | |
| 58 | ORA_MON_SYSEVENT_SDD |
Oracle database monitor "system events": SDD (Service data download) | |
| 59 | ORA_MON_ALOG_CLASSIFY |
Oracle monitor: Classify alert log entries | |
| 60 | ORA_MON_READ_ALOG_CLASSIFIED |
Oracle monitor: read alert log for inst.ID and classify | |
| 61 | MONITOR_STM_OKCODE_HANDLER |
ORA RAC SGA Monitor OK Code Handler | |
| 62 | MONITOR_STM_LISTPRINT |
Print list into spool | |
| 63 | MONITOR_STM_INIT |
Initialization Module for SGA Monitor | |
| 64 | MONITOR_STM_FREE |
ORA RAC SGA Monitor Free Ressources Function | |
| 65 | MONITOR_LK_SDD |
Oracle database monitor "locks": SDD (Service data download) | |
| 66 | MONITOR_SM_SDD |
Oracle database monitor "session": SDD (Service data download) | |
| 67 | MONITOR_SG_SDD |
Oracle database monitor "SGA": SDD (Service data download) | |
| 68 | MONITOR_PG_SDD |
Oracle database monitor "PGA": SDD (Service data download) | |
Transaction Code
Screens
| # | Screen | Short Description |
|---|---|---|
| 1 | 0100 | List output dialog box |
| 2 | 0501 | ORA RAC Session Monitor Subscreen |
| 3 | 0503 | Oracle Session Monitor for RAC with Controls Detail Display |
| 4 | 0510 | Oracle RAC SGA Monitor main screen |
| 5 | 0511 | SGA |
| 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 | 0560 | Oracle RAC Lock Monitor main screen |
| 42 | 0561 | Detail Display for Lock Monitor |
| 43 | 0710 | System event monitor: "main subscreen" (tabstrips) |
| 44 | 0720 | System event monitor: Summary of busy waits |
| 45 | 0730 | System event monitor: Detailed view of system events |
| 46 | 0740 | System event monitor: GV$SYSTEM_EVENT |
| 47 | 0810 | Display arbitrary join of views: Editor screen |
| 48 | 1201 | Oracle RAC Lock Monitor main screen |
| 49 | 1310 | TabStrip for the "CBO System Statistic" Submonitor |
| 50 | 1320 | Screen for System CBO-Statistics |
| 51 | 1330 | If availavble the screen show all colleted system statistics |
| 52 | 1401 | Main screen Dataguard Oracle monitor |
| 53 | 1402 | Overview |
| 54 | 1403 | Database |
| 55 | 1404 | Dataguard status |
| 56 | 1405 | Managed standby |
| 57 | 1601 | Container for the resumable submonitor |
| 58 | 1610 | PopUp-Window, which provided add. resumable space infos |
| 59 | 1620 | Detail-Screen for long text-fields from table DBA_RESUMABLE |
| 60 | 2010 | Container for the parallel query submonitor |
| 61 | 2020 | PopUp-Window, which provide phyical infos about a px. |
| 62 | 2030 | PopUp-Window, which provide more infos about the q-coord. |
| 63 | 2040 | Display the Exection Plan for a Parallel Query |
| 64 | 2610 | Database messages: Selection popup |
| 65 | 2620 | Oracle database messages monitor: display alert log |
| 66 | 2910 | Database messages: Selection popup |
| 67 | 2920 | Oracle monitor: display alert log |
GUI Status
| # | GUI Status | Short Description |
|---|---|---|
| 1 | 0401 | Pick up in list |
| 2 | 502 | Detail Display Oracle Sessionmonitor |
| 3 | 561 | Lock Monitor Detail Display |
| 4 | JV_0810 | Status SQL Editor |
| 5 | ML_2620B | Main status databse message log |
| 6 | ML_ALV_POPUP | Standard for General List Output in Dialog Box |
| 7 | ML_S2610 | Selection scope database messages |
| 8 | PICK | Pick up in list |
| 9 | S1301 | GUI Status for auxstats |
| 10 | S1601 | GUI Status for resumable |
| 11 | S1610 | GUI Status for the DBA_RESUMABLE details |
| 12 | S1620 | GUI Status for detail view of long statements |
| 13 | S2010 | GUI Status for Screen 2010 (gv_px_session) |
| 14 | S2020 | GUI Status for the Parallel Query phys infos |
| 15 | S2030 | GUI Status, which provide more infos about the q-coord. |
| 16 | S2910 | Selection scope database messages |
| 17 | S2920 | GUI Status for Screen 2010 (gv_px_session) |
| 18 | SE_0710_MAIN | Main status system event monitor |
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 | Database Performance Monitor |
| 7 | JV_T0820 | Result of the SELECT statement |
| 8 | ML_T2610 | Database Messages |
| 9 | SE_T0710 | Database Performance Monitor |
| 10 | T1301 | Database Performance Monitor |
| 11 | T1601 | Database Performance Monitor |
| 12 | T1610 | Details |
| 13 | T1620 | Details |
| 14 | T2010 | Database Performance Monitor |
| 15 | T2020 | Additional infos to a parallel query process |
| 16 | T2030 | Additional information about the parallel query coordiantor |
| 17 | T2910 | Listing of Database Checkpoints |
| 18 | T2920 | Database Performance Monitor |
History
| Last changed by/on | SAP | 20040312 |
| SAP Release Created in |
