目的:通过量化指标对比Oracle数据库的新老导入导出工具的性能,为数据库迁移升级做技术准备.方法:进行实验设计,创建适当平台,按照特定参数逐个运行相应的实用程序,记录运行时间及结果,并进行对比.结果:数据导出性能提升80.53％,数据导入性能提升54.99％,整体性能提升63.06％.结论:新工具性能提高明显,可以将数据库升级或数据迁移的时间缩短6个多小时.%Objective: Make technical preparations for the database migration to upgrade the Oracle database to quantify therncomparison between the performance of import and export tools for new an old. Methods: Experimental design and create thernappropriate platform, run these utilities in accordance with the specific parameters one by one, and record the running time and resultsrnwere compared. Results: Data export performance improvement of 80.53%, data import performance improvement of 54.99%, andrnthe overall performance increase of 63.06%. Conclusion: New tool performance is remarkably improved, the database upgrade or datarnmigration can be to shorten the rime for more than 6 hours.
展开▼
