SAP ABAP Class CL_SDB_ORA_UPDATE_STATS (Generate DB Statistics)
Hierarchy
☛
SAP_BASIS (Software Component) SAP Basis Component
⤷
BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle
⤷
SDBO (Package) Database Administration: Oracle-Specific Components
SAP_BASIS (Software Component) SAP Basis Component⤷
BC-DB-ORA-CCM (Application Component) CCMS / Database Monitors for Oracle⤷
SDBO (Package) Database Administration: Oracle-Specific ComponentsProperties
| Class | CL_SDB_ORA_UPDATE_STATS | |
| Short Description | Generate DB Statistics | |
| Super Class | ||
| Instantiability of a Class | 2 | Public |
| Final |
General Data
| Message Class | ||
| Program status | ||
| Category | 0 | |
| Package | SDBO | Database Administration: Oracle-Specific Components |
| Created | 20051121 | SAP |
| Last change | 20110908 | SAP |
| Shared Memory-enabled | ||
| Fixed point arithmetic | ||
| Unicode checks active |
Forward declarations
Class CL_SDB_ORA_UPDATE_STATS has no forward declaration.
Interfaces
Class CL_SDB_ORA_UPDATE_STATS has no interface implemented.
Friends
Class CL_SDB_ORA_UPDATE_STATS has no friend class.
Attributes
| # | Attribute | Level | Visibility | Read only | Typing | Associated Type | Initial Value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | P_BUCKET_CNT |
Instance attribute | Private | Type reference (TYPE) | INT4 | Number of Buckets for Histograms | 20070615 | ||
| 2 | P_CASCADE |
Instance attribute | Private | Type reference (TYPE) | I | Create Index Statistics (0=YES, 1=NO, 2=AUTO) | 20051121 | ||
| 3 | P_CONNECTION |
Instance attribute | Private | Type reference (TYPE) | DBCON_NAME | Logical Name for a Database Connection | 20051216 | ||
| 4 | P_DBSTATC |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Table DBSTATC exists | 20070314 | ||
| 5 | P_DBSTATTORA |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Table DBSTATTORA exists | 20070314 | ||
| 6 | P_DEGREE |
Instance attribute | Private | Type reference (TYPE) | I | Deg.of Parallelism(0=NULL, 1-16=1-16, except 5=AUTO, 9=DEFT) | 20051121 | ||
| 7 | P_DELETE |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Delete Statistics | 20070918 | ||
| 8 | P_FLUSH |
Instance attribute | Private | Type reference (TYPE) | CHAR3 | Save Table Monitoring Information ('X'=YES) | 20060908 | ||
| 9 | P_FORCE |
Instance attribute | Private | Type reference (TYPE) | CHAR3 | Force Update Statistics (NO/YES) | 20051121 | ||
| 10 | P_GRANULARITY |
Instance attribute | Private | Type reference (TYPE) | I | Granularity (0=DEFT, 1=ALL, 2=GLOB, 3=PART, 4=AUTO) | 20051121 | ||
| 11 | P_HISTO |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Histograms (X=75, S=SKEWONLY, R=REPEAT, A=AUTO, C=ALLCOL) | 20051121 | ||
| 12 | P_INDEXNM |
Instance attribute | Private | Type reference (TYPE) | INDEX_NAME | Index Name | 20060412 | ||
| 13 | P_NEW_ROWS |
Instance attribute | Private | Type reference (TYPE) | F | New Number of Table Records | 20090710 | ||
| 14 | P_ORA_RELEASE |
Instance attribute | Private | Type reference (TYPE) | DBRELEASE-DBRELEASE | Database Release | 20051212 | ||
| 15 | P_OWNNAME |
Instance attribute | Private | Type reference (TYPE) | TAB_ORA-OWNER | Table Owner | 20051121 | ||
| 16 | P_PARTITIONED |
Instance attribute | Private | Type reference (TYPE) | CHAR3 | Partitioned Table | 20051121 | ||
| 17 | P_PARTPERC |
Instance attribute | Private | Type reference (TYPE) | CHAR32 | Calculated Sample Size for Partitions | 20051213 | ||
| 18 | P_PERCENT |
Instance attribute | Private | Type reference (TYPE) | CHAR32 | Calculated Sample Size for Table | 20051121 | ||
| 19 | P_R_CONNECTION |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_SQL_CONNECTION | Database Connection | 20100907 | ||
| 20 | P_SAMPLE |
Instance attribute | Private | Type reference (TYPE) | I | Sample Size (1-100=1%-100%, 1001-1999=0.001%-0.999%) | 20090710 | ||
| 21 | P_SIGNI |
Instance attribute | Private | Type reference (TYPE) | DBSTATC-SIGNI | Sign.(0=DEFT,1=COMP,2=30,3=10,4=3,5=1,6=AUTO,7=0.3,8=0.1,..) | 20051121 | ||
| 22 | P_SKIP_UPD |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Skip Statistics Update Due to DBSTATC | 20070314 | ||
| 23 | P_SORAMON |
Instance attribute | Private | Type reference (TYPE) | CHAR1 | Table SORAMON exists | 20070314 | ||
| 24 | P_SQL_STMT |
Instance attribute | Private | Type reference (TYPE) | STRING | SQL Command with the DBMS_STATS Call | 20070713 | ||
| 25 | P_STMT_REF |
Instance attribute | Private | Object reference (TYPE REF TO) | CL_SQL_STATEMENT | SQL Statement Reference | 20100907 | ||
| 26 | P_TABLNM |
Instance attribute | Private | Type reference (TYPE) | TABNAME | Table Name | 20051121 | ||
| 27 | P_THRESH_MOD |
Instance attribute | Private | Type reference (TYPE) | I | Change Threshold Value (Non-Part=50, Part-Tab=25, Parts=50) | 20051121 |
Methods
| # | Method | Level | Visibility | Method type | Description | Created on |
|---|---|---|---|---|---|---|
| 1 | ADJUST_DBSTATTORA |
Instance method | Private | Method | Generate Entry in DBSTATTORA | 20060908 |
| 2 | CONSTRUCTOR |
Instance method | Public | Constructor | Constructor | 20051121 |
| 3 | DELETE_STATS |
Static method | Public | Method | Interface: Delete Statistics for Table | 20070918 |
| 4 | DELETE_STATS_INDEX |
Static method | Public | Method | Interface: Delete Statistics for Index | 20070918 |
| 5 | DEL_INDEX_STATS |
Instance method | Private | Method | Delete Index Statistics | 20070918 |
| 6 | DEL_STATS |
Instance method | Private | Method | Delete Statistics | 20070918 |
| 7 | EXECUTE_STATEMENT |
Instance method | Private | Method | ASBC Interface | 20051121 |
| 8 | GET_ORA_RELEASE |
Instance method | Private | Method | Determining Oracle release | 20060130 |
| 9 | GLOBAL_GET_CASCADE |
Instance method | Private | Method | CASCADE for Global Statistics | 20051121 |
| 10 | GLOBAL_GET_DEGREE |
Instance method | Private | Method | DEGREE for Global Statistics | 20051121 |
| 11 | GLOBAL_GET_ESTIMATE_PERCENT |
Instance method | Private | Method | ESTIMATE PERCENT for Global Statistics | 20051121 |
| 12 | GLOBAL_GET_GRANULARITY |
Instance method | Private | Method | GRANULARITY for Global Statistics | 20051121 |
| 13 | GLOBAL_GET_METHOD_OPT |
Instance method | Private | Method | METHOD_OPT for Global Statistics | 20051121 |
| 14 | GLOBAL_UPDATE_STATS |
Instance method | Private | Method | Generate Global Statistics | 20051121 |
| 15 | GLOBAL_UPDATE_STATS_INDEX |
Instance method | Private | Method | Generate Global Statistics | 20060412 |
| 16 | GLOBAL_UPD_STATS_REQUIRED |
Instance method | Private | Method | Check if global statistics are required | 20051121 |
| 17 | PART_GET_CASCADE |
Instance method | Private | Method | CASCADE for Partition Statistics | 20051121 |
| 18 | PART_GET_DEGREE |
Instance method | Private | Method | DEGREE for Partition Statistics | 20051121 |
| 19 | PART_GET_ESTIMATE_PERCENT |
Instance method | Private | Method | ESTIMATE PERCENT for Partition Statistics | 20051121 |
| 20 | PART_GET_GRANULARITY |
Instance method | Private | Method | GRANULARITY for Partition Statistics | 20051121 |
| 21 | PART_GET_METHOD_OPT |
Instance method | Private | Method | METHOD_OPT for Partition Statistics | 20051121 |
| 22 | PART_GET_PARTNAME |
Instance method | Private | Method | PARTNAME for Partition Statistics | 20051121 |
| 23 | PART_UPDATE_STATS |
Instance method | Private | Method | Generate Global Statistics | 20051121 |
| 24 | PART_UPD_STATS_REQUIRED |
Instance method | Private | Method | Check if global statistics are required | 20051121 |
| 25 | UPDATE_STATS |
Static method | Public | Method | Interface. Generate Statistics | 20051121 |
| 26 | UPDATE_STATS_INDEX |
Static method | Public | Method | Interface. Generate Statistics | 20060412 |
| 27 | UPDATE_STATS_REQUIRED |
Static method | Public | Method | Interface: Check whether new statistics are required | 20061006 |
Events
Class CL_SDB_ORA_UPDATE_STATS has no event.
Types
| # | Type | Visibility | Typing | Associated Type | Description | Created on | Type Source |
|---|---|---|---|---|---|---|---|
| 1 | _S_IIND | Public | Type reference (TYPE) | IND_ORA | 20051121 | |
|
| 2 | _S_INTEGER | Public | See coding | 20051212 | BEGIN OF _s_integer,
val TYPE i,
END OF _s_integer
|
||
| 3 | _S_MODINFO | Public | See coding | 20051121 | BEGIN OF _s_modinfo,
table_name TYPE tabname,
partition_name TYPE tabname,
last_analyzed TYPE char14,
num_rows TYPE f,
inserts TYPE f,
updates TYPE f,
deletes TYPE f,
truncated TYPE char3,
END OF _s_modinfo
|
||
| 4 | _S_MONITORING | Public | See coding | 20051121 | BEGIN OF _s_monitoring,
is_mon TYPE char3,
is_part TYPE char3,
END OF _s_monitoring
|
||
| 5 | _S_NUMBER | Public | See coding | 20051121 | BEGIN OF _s_number,
val TYPE f,
END OF _s_number
|
||
| 6 | _S_TABFIELDS | Public | See coding | 20051121 | BEGIN OF _s_tabfields,
name TYPE char30,
keyflg TYPE char1,
END OF _s_tabfields
|
||
| 7 | _T_IIND | Public | See coding | 20051121 | _t_iind TYPE STANDARD TABLE OF _s_iind WITH DEFAULT KEY
|
||
| 8 | _T_MODINFO | Public | See coding | 20051121 | _t_modinfo TYPE STANDARD TABLE OF _s_modinfo WITH KEY table_name partition_name
|
||
| 9 | _T_TABFIELDS | Public | See coding | 20051121 | _t_tabfields TYPE STANDARD TABLE OF _s_tabfields WITH DEFAULT KEY
|
Method Signatures
Method ADJUST_DBSTATTORA Signature
Method ADJUST_DBSTATTORA on class CL_SDB_ORA_UPDATE_STATS has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 |  CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20060908 |
Method CONSTRUCTOR Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Importing |
I_CASCADE | Call by reference | Type reference (TYPE) | I | Indexstatistiken erstellen (0=YES, 1=NO, 2=AUTO) | 20051121 | ||
| 2 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logischer Name einer Datenbankverbindung | 20051216 | ||
| 3 | Importing |
I_DEGREE | Call by reference | Type reference (TYPE) | I | Parallelitätsgrad (0=NULL, 1-16-=1-16 außer 5=AUTO, 9=DEFT) | 20051121 | ||
| 4 | Importing |
I_DELETE | Call by reference | Type reference (TYPE) | CHAR1 | Statistiken Löschen | 20070918 | ||
| 5 | Importing |
I_FLUSH | Call by reference | Type reference (TYPE) | CHAR1 | Tabellen-Monitoring Infos wegschreiben ('X'=YES) | 20060908 | ||
| 6 | Importing |
I_FORCE | Call by reference | Type reference (TYPE) | CHAR1 | Update Statistics erzwingen ('X'=YES) | 20051121 | ||
| 7 | Importing |
I_GRANULARITY | Call by reference | Type reference (TYPE) | I | Granularität (0=DEFT, 1=ALL, 2=GLOB, 3=PART, 4=AUTO) | 20051121 | ||
| 8 | Importing |
I_HISTO | Call by reference | Type reference (TYPE) | CHAR1 | Histogramme (X=75, S=SKEWONLY, R=REPEAT, A=AUTO, C=ALLCOL) | 20051121 | ||
| 9 | Importing |
I_INDEXNM | Call by reference | Type reference (TYPE) | INDEX_NAME | Index Name | 20060412 | ||
| 10 | Importing |
I_SAMPLE | Call by reference | Type reference (TYPE) | I | Probengröße (1-100=1%-100%, 1001-1999=0.001%-0.999%) | 20090710 | ||
| 11 | Importing |
I_SIGNI | Call by reference | Type reference (TYPE) | DBSTATC-SIGNI | Sign.(0=DEFT,1=COMP,2=30,3=10,4=3,5=1,6=AUTO,7=0.3,8=0.1,..) | 20051121 | ||
| 12 | Importing |
I_TABLNM | Call by reference | Type reference (TYPE) | TABNAME | Tabellenname | 20051121 | ||
| 13 | Importing |
I_THRESH_MOD | Call by reference | Type reference (TYPE) | I | Änderungsschwellwert (Non-Part=50, Part-Tab=25, Parts=50) | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method DELETE_STATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Exporting |
E_SQL_STMT | Call by reference | Type reference (TYPE) | STRING | SQL Kommando mit dem DBMS_STATS Aufruf | 20070918 | ||
| 2 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical Name for a Database Connection | 20070918 | ||
| 3 | Importing |
I_TABLNM | Call by reference | Type reference (TYPE) | TABNAME | TableName | 20070918 |
Method DELETE_STATS on class CL_SDB_ORA_UPDATE_STATS has no exception.
Method DELETE_STATS_INDEX Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_SQL_STMT | Call by reference | Type reference (TYPE) | STRING | SQL Kommando mit dem DBMS_STATS Aufruf | 20070918 | ||
| 2 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logical Name for a Database Connection | 20070918 | ||
| 3 | Importing |
I_INDEXNM | Call by reference | Type reference (TYPE) | INDEX_NAME | Index Name | 20070918 |
Method DELETE_STATS_INDEX on class CL_SDB_ORA_UPDATE_STATS has no exception.
Method DEL_INDEX_STATS Signature
Method DEL_INDEX_STATS on class CL_SDB_ORA_UPDATE_STATS has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20070918 |
Method DEL_STATS Signature
Method DEL_STATS on class CL_SDB_ORA_UPDATE_STATS has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20070918 |
Method EXECUTE_STATEMENT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_ROWS_FETCHED | Call by reference | Type reference (TYPE) | I | 20051121 | |||
| 2 | Exporting |
E_ROWS_MODIFIED | Call by reference | Type reference (TYPE) | I | 20051121 | |||
| 3 | Exporting |
E_S_DATA | Call by reference | Type reference (TYPE) | ANY | 20051121 | |||
| 4 | Exporting |
E_T_DATA | Call by reference | Type reference (TYPE) | STANDARD TABLE | 20051121 | |||
| 5 | Importing |
I_HOSTVAR1 | Call by reference | Type reference (TYPE) | CHAR30 | 20090710 | |||
| 6 | Importing |
I_HOSTVAR2 | Call by reference | Type reference (TYPE) | CHAR30 | 20090710 | |||
| 7 | Importing |
I_HOSTVAR3 | Call by reference | Type reference (TYPE) | CHAR30 | 20090710 | |||
| 8 | Importing |
I_REPEAT | Call by reference | Type reference (TYPE) | I | 1 | 20090710 | ||
| 9 | Importing |
I_STMT | Call by reference | Type reference (TYPE) | STRING | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GET_ORA_RELEASE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
ORA_RELEASE | Call by reference | Type reference (TYPE) | DBRELEASE-DBRELEASE | Release der Datenbank | 20060130 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20060130 |
Method GLOBAL_GET_CASCADE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_GET_DEGREE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_GET_ESTIMATE_PERCENT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_GET_GRANULARITY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_GET_METHOD_OPT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_UPDATE_STATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 |  Returning |
R_GLOB_STATS_UPDATED | Value transfer | Type reference (TYPE) | CHAR3 | Feld der Laenge 3 Bytes | 20051209 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method GLOBAL_UPDATE_STATS_INDEX Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
R_GLOB_STATS_UPDATED | Value transfer | Type reference (TYPE) | CHAR3 | Feld der Laenge 3 Bytes | 20060412 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20060412 |
Method GLOBAL_UPD_STATS_REQUIRED Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Returning |
R_UPD_STAT_REQUIRED | Value transfer | Type reference (TYPE) | CHAR3 | Statistiken auf Partition neu berechnen | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_CASCADE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_DEGREE Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_ESTIMATE_PERCENT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_GRANULARITY Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_METHOD_OPT Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_GET_PARTNAME Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Changing |
C_STMT | Call by reference | Type reference (TYPE) | STRING | DBMS_STAT Aufruf | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_UPDATE_STATS Signature
Method PART_UPDATE_STATS on class CL_SDB_ORA_UPDATE_STATS has no parameter.
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method PART_UPD_STATS_REQUIRED Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Importing |
I_S_MODINFO | Call by reference | Type reference (TYPE) | _S_MODINFO | Partitionsname | 20051121 | ||
| 2 | Returning |
R_UPD_STAT_REQUIRED | Value transfer | Type reference (TYPE) | CHAR3 | Statistiken auf Partition neu berechnen | 20051121 |
| # | Exception | Resumable | Description | Created on |
|---|---|---|---|---|
| 1 | CX_SQL_EXCEPTION |
Ausnahmeklasse für SQL Fehler | 20051121 |
Method UPDATE_STATS Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_SQL_STMT | Call by reference | Type reference (TYPE) | STRING | SQL Kommando mit dem DBMS_STATS Aufruf | 20070713 | ||
| 2 | Importing |
I_CASCADE | Call by reference | Type reference (TYPE) | I | 0 | Indexstatistiken erstellen (0=YES, 1=NO, 2=AUTO) | 20051121 | |
| 3 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logischer Name einer Datenbankverbindung | 20051216 | ||
| 4 | Importing |
I_DEGREE | Call by reference | Type reference (TYPE) | I | 0 | Parallelitätsgrad (0=NULL, 1-16-=1-16 außer 5=AUTO, 9=DEFT) | 20051121 | |
| 5 | Importing |
I_FLUSH | Call by reference | Type reference (TYPE) | CHAR1 | ' ' | Tabellen-Monitoring Infos wegschreiben ('X'=YES) | 20060908 | |
| 6 | Importing |
I_FORCE | Call by reference | Type reference (TYPE) | CHAR1 | ' ' | Update Statistics erzwingen ('X'=YES) | 20051121 | |
| 7 | Importing |
I_GRANULARITY | Call by reference | Type reference (TYPE) | I | 0 | Granularität (0=DEFT, 1=ALL, 2=GLOB, 3=PART, 4=AUTO) | 20051121 | |
| 8 | Importing |
I_HISTO | Call by reference | Type reference (TYPE) | CHAR1 | ' ' | Histogramme (X=75, S=SKEWONLY, R=REPEAT, A=AUTO, C=ALLCOL) | 20051121 | |
| 9 | Importing |
I_SAMPLE | Call by reference | Type reference (TYPE) | I | 0 | Probengröße (1-100=1%-100%, 1001-1999=0.001%-0.999%) | 20090710 | |
| 10 | Importing |
I_SIGNI | Call by reference | Type reference (TYPE) | DBSTATC-SIGNI | 0 | Sign.(0=DEFT,1=COMP,2=30,3=10,4=3,5=1,6=AUTO,7=0.3,8=0.1,..) | 20051121 | |
| 11 | Importing |
I_TABLNM | Call by reference | Type reference (TYPE) | TABNAME | Tabellenname | 20051121 | ||
| 12 | Importing |
I_THRESH_MOD | Call by reference | Type reference (TYPE) | I | 0 | Änderungsschwellwert (Non-Part=50, Part-Tab=25, Parts=50) | 20051121 |
Method UPDATE_STATS on class CL_SDB_ORA_UPDATE_STATS has no exception.
Method UPDATE_STATS_INDEX Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_SQL_STMT | Call by reference | Type reference (TYPE) | STRING | SQL Kommando mit dem DBMS_STATS Aufruf | 20070713 | ||
| 2 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logischer Name einer Datenbankverbindung | 20060412 | ||
| 3 | Importing |
I_DEGREE | Call by reference | Type reference (TYPE) | I | 0 | Parallelitätsgrad (0=NULL, 1-16-=1-16 außer 5=AUTO, 9=DEFT) | 20060412 | |
| 4 | Importing |
I_GRANULARITY | Call by reference | Type reference (TYPE) | I | 0 | Granularität (0=DEFT, 1=ALL, 2=GLOB, 3=PART, 4=AUTO) | 20060412 | |
| 5 | Importing |
I_INDEXNM | Call by reference | Type reference (TYPE) | INDEX_NAME | Index Name | 20060412 | ||
| 6 | Importing |
I_SAMPLE | Call by reference | Type reference (TYPE) | I | 0 | Probengröße (1-100=1%-100%, 1001-1999=0.001%-0.999%) | 20090710 | |
| 7 | Importing |
I_SIGNI | Call by reference | Type reference (TYPE) | DBSTATC-SIGNI | 0 | Sign.(0=DEFT,1=COMP,2=30,3=10,4=3,5=1,6=AUTO,7=0.3,8=0.1,..) | 20060412 |
Method UPDATE_STATS_INDEX on class CL_SDB_ORA_UPDATE_STATS has no exception.
Method UPDATE_STATS_REQUIRED Signature
| # | Type | Parameter | Pass Value | Optional | Typing Method | Associated Type | Default value | Description | Created on |
|---|---|---|---|---|---|---|---|---|---|
| 1 | Exporting |
E_GLOBAL_STATS_REQUIRED | Call by reference | Type reference (TYPE) | CHAR3 | Globale Statistiken notwendig | 20061006 | ||
| 2 | Exporting |
E_PART_STATS_REQUIRED | Call by reference | Type reference (TYPE) | CHAR3 | Statistiken auf Tabellenpartition notwendig | 20061006 | ||
| 3 | Importing |
I_CONNECTION | Call by reference | Type reference (TYPE) | DBCON_NAME | Logischer Name einer Datenbankverbindung | 20061006 | ||
| 4 | Importing |
I_FLUSH | Call by reference | Type reference (TYPE) | CHAR1 | ' ' | Tabellen-Monitoring Infos wegschreiben ('X'=YES) | 20061006 | |
| 5 | Importing |
I_TABLNM | Call by reference | Type reference (TYPE) | TABNAME | Tablename | 20061006 | ||
| 6 | Importing |
I_THRESH_MOD | Call by reference | Type reference (TYPE) | I | 0 | Änderungsschwellwert (Non-Part=50, Part-Tab=25, Parts=50) | 20061006 |
Method UPDATE_STATS_REQUIRED on class CL_SDB_ORA_UPDATE_STATS has no exception.
History
| Last changed by/on | SAP | 20110908 |
| SAP Release Created in | 710 |
