Weekend Learning: Data Pump and Oracle DB parameters to increase Data Pump performance

Tonight My Oracle Support article 1611373.1 "What DataPump And Oracle RDBMS Parameters Can Significantly Affect DataPump Performance ?" is a very straightforward listing of parameters which could teach you how to speed up Data Pump but also it can teach you about the Oracle DB as well by introducing you to some of these parameters maybe for the first time!

Datapump LOB export/import not in parallel

Are you getting ready to do an upgrade of your OS/DB/app platforms?  Were you planning on using Datapump to get it done?  Did you know that the export and import of LOBs cannot execute in parallel?  My Oracle Support document "DataPump Export/Import Of LOBs Are Not Executed in Parallel" in note ID 1467662.1 not only informs us of that fact but introduces us to an overview article of Oracle Large Objects for BasicFiles and SecureFiles too.  Take a few minutes to read both MOS articles!

Migrating Oracle EBS Database to Exadata

I thought this had an interesting whitepaper PDF detailing just how one can migrate their EBS database over to Exadata without losing a drop of data!  This makes use of the Cross-platform Transportable Tablespaces (XTTS) technology, so not only do you get to find out how Oracle Data Pump works in this situation but you can read up on yet another Oracle based solution with XTTS and maybe pick up a thing or two like I did.