Upgraded to Live-Reorg 7.0 from 6.7 Simulation Reorganization failing with a out of memory error. Looking at MS Window task manager, while the simulation is running, spacemgr.exe memory increases until 800,000 K is used. Below is the call stack
It will definitely help to turn OFF extent-level space checks, as described in the document. The document has the SQL statement necessary to tell Space Manager to turn OFF extent-level space checks, which will make the Simulate Reorganization step run much faster: merge into quest_spc_parameter a using (select CHECK_EXTENTS_DICTIONARY as name, NO as value from dual) b on (a.name = b.name) when matched then update set a.value = b.value, a.upgrade_resets_value = N when not matched then insert (a.name, a.value, a.upgrade_resets_value) values (b.name, b.value, N) ; commit ;
Depending on the type of tablespaces being used in the reorganization, the situation might be improved by following the suggestions in this document "Change Behaviour of Reorg Manager Space Checks" The document can be found at the Space Manager community site http://spacemanagementoracle.inside.quest.com/kbcategory.jspa?categoryID=363 Read the document for a full description of how this will change the behaviour of Space Manager.
- Simulation reorg was done on one table and its 12 indices. It a SAP system, so the table size is big. (3,025 extents, 521 GB). The server has 3.75 GB of RAM - Had no problems using LiveReorg 6.7 on this table and its indexes in this database. - The source and destination tablespaces are dictionary managed