SAP Note 584416 - Guidelines for the ALPHA conversion on oracle databases

Composant : Data Warehouse Management - BW ORACLE

Solution : https://service.sap.com/sap/support/notes/584416 (Connexion à SAP Service Marketplace requise)

Mots Clés :
sysdba'sql> alter database add logfile group <groupnumber>    '<path, sysdba'sql> create rollback segment prs_a01 storage, tablespace-size >=25 gb< 100 000 000 create >=  75 rollback segments, tablespace-size >=30 gb< 200 000 000 create >= 100 rollback segments, tablespace-size >=40 gb< 300 000 000 create >= 150 rollback segments, tablespace-size >=60 gb> 300 000 000 create >= 200 rollback segments, sysdba'sql> select distinct tabkat, sysdba' sql> update igora set, index <indexname>goto se14 search, goto se16 -> table rsmdodsconvstate delete

Notes associées :

589851Guidelines for the ALPHA conversion (Performance)
559524Alpha: Parallel processing of the ODS converter
447341values for ALPHA conversion routine
84348Oracle deadlocks, ORA-00060