I am working on a migration of a large INTRALINK database (~2M PIV). I have encountered issues with the migration that are specifically related to the volume of data. Below are some of the issues and remediations.
<> Poor overnight performance -- Turn off all backups.
<> Archive logs flood the disk -- Turn off archiving.
<> Rollback/Undo logs flood the disk -- Change Undo TS to 30 minutes max.
I've also noticed that the UDA loader causes the database to double in size, from ~30 GB to 60 GB.
Are there any other tips for working with large databases? Does reordering the loaders from the recommended order improve overall performance? What commands are you executing for gathering statistics? Etc.
Stuart Harvey
