Re: Execute table optimization concurrently
Posted by:
Rick James
Date: August 07, 2014 10:57PM
400-way parallelizing of OPTIMIZE (or any other I/O thingie) is likely to _severely_ fragment the files. This is because each table or index will be asking for more disk space in an interleaved fashion, thereby leading to the pieces being scattered around on disk. Break it in 2-3 chunks and you will get nearly down to 2 hours, but there will still be some fragmentation.
Subject
Written By
Posted
Re: Execute table optimization concurrently
August 07, 2014 10:57PM
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.