Solution : https://service.sap.com/sap/support/notes/12621 (SAP Service marketplace login required)
Summary :
The slow reorganization of PSAP00LD in SAPDBA is due to ORACLE misinterpreting the 'COMMIT = Y' parameter, leading to commits after every record instead of after each ArrayInsert with value buffer. As of Release 3.0D, this can be avoided using SAP's beta unload/load or ORACLE SQL*Loader. For older methods, importing with 'COMMIT = N' requires a larger rollback segment to enhance speed. The process involves several steps: determining the largest table, creating and using an adequate rollback segment, deactivating old segments, modifying SAPDBA's script parameters, and post-reorganization cleanup. Particular care is needed when handling tables without long fields and ATAB separation.
Key words :
sqldba> connect internalsqldba> create tablespace psaprollbig datafile '/oracle/c11/sapdata1/rollbig_1/rollbig, sqldba> connect internalsqldba> alter rollback segment <segment_name> offline, sqldba> connect internalsqldba> alter rollback segment <segment_name> online, sqldba> create rollback segment rollbig tablespace psaprollbig storage, rm /oracle/c11/sapdata1/rollbig_1/rollbig, sqldba> connect internal sqldba> select max, sqldba> alter rollback segment rollbig offline, sqldba> alter rollback segment rollbig online, sqldba> drop rollback segment rollbig, oracle incorrectly interpretsparameter 'commit = y'
Related Notes :
| 489690 | CC INFO: Copying large production clients |
| 96296 | CC-ERROR: Database problem in client copy |
| 68896 | R3trans: Performance problems and cluster |
| 67205 | CC-INFO: Copying large and productive clients |
| 46077 | Latest note on the language import 3.0E |
| 45157 | Language supplements: Snapshot too old |
| 43487 | Collective note: SAPDBA - Reorgnztn/Space/Structure |
| 38930 | Current note on the language import for 3.0D |
| 3807 | Error messages regarding rollback and undo segments |