Why a Parallel Export Script?

This chapter describes a script that performs fast Oracle database exports using Symmetric Multi Processing (SMP) machines. The performance benefit this script provides is nearly linear relative to the number of CPUs. For example, with 32 CPUs available for backups, a speed of nearly 32 times the standard database export can be achieved. Therefore, this script can be valuable for situations where exports of large amounts of mission-critical data need to be performed.

The script was contributed by its authors, Neal Sundberg and Mike Ellison from Qualcomm Inc. This approach was presented by Qualcomm in a paper called “Parallel Export/Import Today on SMP Machines” at the 1995 Oracle Users Week conference. The script ...

Get Backup and Restore Practices for Sun Enterprise™ Servers now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.