R
Richard Banville
Guest
Are you running index rebuild with the new –datascanthreads and –TF options? If not, you might want to read up on them. They have been shown to make index rebuild 5X faster. Suggestion would be –datascanthreads 8 –TF 80 with caveats on the resources required to execute in that way. From: James Palmer [mailto:bounce-jdpjamesp@community.progress.com] Sent: Tuesday, June 03, 2014 10:01 AM To: TU.OE.RDBMS@community.progress.com Subject: RE: [Technical Users - OE RDBMS] Remove a storage area As a way of explaining, it's a 150GB area made up of extents that are smaller than 2GB. Most a lot smaller. It's a really bad structure. I'm moving stuff around to more sensible areas. On that note, the bit that is taking the time is the index rebuild at the end. My process is as follows. Does anyone have any tips on something I could do differently (OE11.2.1)? Binary Dump Data Drop tables Add new areas Create df and move stuff to the new areas needed Remove the now surplus storage area Load the binaries Rebuild indexes Everything is scripted and works beautifully, it's just the index rebuild that is taking forever.
Continue reading...
Continue reading...