Oracle数据库数据导入导出实用程序的评测

Evaluation of Export & Import Utilities of the Oracle Database

目的:通过量化指标对比Oracle数据库的新老导入导出工具的性能,为数据库迁移升级做技术准备。方法:进行实验设计,创建适当平台,按照特定参数逐个运行相应的实用程序,记录运行时间及结果,并进行对比。结果:数据导出性能提升80.53%,数据导入性能提升54.99%,整体性能提升63.06%。结论:新工具性能提高明显,可以将数据库升级或数据迁移的时间缩短6个多小时。

Objective： Make technical preparations for the database migration to upgrade the Oracle database to quantify the comparison between the performance of import and export tools for new an old. Methods： Experimental design and create the appropriate platform, run these utilities in accordance with the specific parameters one by one, and record the running time and results were compared. Results： Data export performance improvement of 80.53%, data import performance improvement of 54.99%, and the overall performance increase of 63.06%. Conclusion： New tool performance is remarkably improved, the database upgrade or data migration can be to shorten the time for more than 6 hours.