REORGANIZE PARTITION Stuck: (status = setup)
We are using REORGANIZE PARTITION to combine 2 partitions (by range) into a single partition. But, for some reason, the query stays in "setup" status for
a very long time with high CPU usage and no data movement to the temp table. Then, the query completes the move without issue. Is there anything we can do to eliminate or speedup this process. Maybe some way to do the alter by creating a new table with the data and swapping the files using the file system. Any input or referrals would be greatly appreciated. Thanks.
Subject
Views
Written By
Posted
REORGANIZE PARTITION Stuck: (status = setup)
4855
June 01, 2011 07:36PM
2543
June 01, 2011 07:46PM
2412
June 02, 2011 10:34PM
2945
June 03, 2011 03:23AM
2957
June 03, 2011 08:28AM
2427
June 03, 2011 02:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.