This blog entry is for those unfortunate to be stuck with the old legacy exp/imp instead of the expdp/impdp (Datapump).
We are importing a ton of data and here are some import tricks that are documented in Oracle MetaLink doc id 93763.1. The ones I'm listing here only apply to imports from direct exports. We had already done the other things in the note.
1. Increase the BUFFER size of the import
2. Create some huge redo log files to minimize the LGWR switches.
It was amazing. This MetaLink note actually works :-)
No comments:
Post a Comment