SAP ABAP Program SAPLSORA (ORACLE Standard Function Modules)
Basic Data
| Program | SAPLSORA | ORACLE Standard Function Modules |
| Program Type | F | Function group |
Attributes
| Status | ||
| Application | S | Basis |
| Authorization Group | ||
| Logical database | ||
| Selection screen | ||
| Editor lock | Fixed point arithmetic | |
| Unicode checks active | Start using variant |
Function Group
| Include | Function Module | Short Description | Mode |
|---|---|---|---|
| 01 |  DB_TABLE_DATA_DISPLAY_ORA |
DB-Specific Display Module (SCREEN) for DB15 | |
| 02 | GET_TABLES_FROM_TSP_ORA |
Tables Information from dba_tables (Single Tablespace) | R |
| 03 | GET_TABLE_SIZE_ORA |
Get Table Size for Oracle | |
| 04 | GET_DATA_FILES_FROM_TSP_ORA |
Tables Information from dba_tables (Single Tablespace) | R |
| 05 | UPDATE_STATS_ORA |
Update Statistics for a Single Oracle Table | |
| 06 | GET_SIGNI_FROM_METHOD_ORA |
Determines Significance Derived from Analysis Method and Option | |
| 07 | GET_LAST_STATS_DATE_ORA |
Gets the Last Statistics Date from dba_tab_columns | R |
| 08 | GET_INDEXES_FROM_TAB_ORA |
Indexes Information from dba_indexes (for a Single Table) | R |
| 09 | GET_DB_RELEASE_ORA |
Get Oracle Version | |
| 10 | GET_ALL_DB_PARAMETER_ORA |
Get DB Parameter from V$parameter | R |
| 11 | DB_TABLE_DATA_READ_ORA |
Read all Table Statistics Data Including Statistics Date | |
| 12 | DB_TABLE_DATA_INS_ORA |
Insert All Table Statistics Data into DBSTATTORA and DBSTATHORA | |
| 13 | GET_ALL_DB_CHECK_PARAMETER |
Gets all DB Check parameter from DBCHECKORA | R |
| 14 | GET_DB_PARAMETER_ORA |
Get DB Parameter from V$parameter | R |
| 15 | GET_TABLE_INFO_ORA |
Table Information from dba_tables | R |
| 16 | GET_SEGMENT_INFO_ORA |
Segment Information from dba_segments | R |
| 17 | GET_TSP_INFO_ORA |
R | |
| 18 | GET_INDEX_INFO_ORA |
R | |
| 19 | GET_TABLESPACE_INFO_ORA |
R | |
| 20 | GET_ORACLE_HOME |
Wert der Environment-Variable ORACLE_HOME | |
| 21 | UPDATE_STATS_INDEX_ORA |
||
| 22 | UPDATE_STATS_DBSTATC_ORA |
Check und evtl. Update von Statistiken gemäß der DBSTATC | |
| 23 | CUSTOMIZE_STATS_DBSTATC_ORA |
||
| 24 | GET_SIMPLE_ALLOC_INFO_ORA |
Allokierter und tatsächlicher Plattenplatzbedarf der Datenbank (approx.) | R |
| 25 | GET_DB_NAME_ORA |
Get Oracle database name | |
| 26 | DS_COLL_DB_KPIS_ORA |
Datensammlung für ORACLE NW DB KPIs | R |
Transaction Code
Screens
| # | Screen | Short Description |
|---|---|---|
| 1 | 0100 | Database-Specific Screen: Detailed Information for DB15 |
| 2 | 0110 | DB-Specific Screen: Online Detailed Information for DB15 |
GUI Status
| # | GUI Status | Short Description |
|---|---|---|
| 1 | STAT0100 | Status for Screen 100 |
GUI Title
| # | GUI Title | Short Description |
|---|---|---|
| 1 | 100 | Table Details from SAP Statistics |
| 2 | 110 | Table Details from Oracle Statistics |
History
| Last changed by/on | SAP | 19961122 |
| SAP Release Created in |
