1
oracle-data-pump-best-practices+(1).pdf
免费下载
Oracle Data Pump
Best Practices
May, 2024, Version 2.0
Copyright © 2024, Oracle and/or its affiliates
Public
2
Best Practices / Version 2.0
Copyright © 2024, Oracle and/or its affiliates / Public
Table of contents
Obtaining Support and the Data Pump Bundle Patch
4
Do Not Invoke Export Using SYS as SYSDBA
4
Use A Parameter File
4
Make a Consistent Data Pump Export
5
Exclude Statistics from Export and Import
6
Use Diagnostics
6
Always use the Logfile Diagnostic Parameters
6
Check the Alert log
6
Monitor Processes with Database Views
6
Use Data Pump Trace
7
Use SQL Trace
7
Improve Performance with Parallelism and Statistics
7
Use Parallelism
7
Specify wildcards to create multiple Dumpfiles
9
Gather Statistics before and after Data Pump Operations
10
Set Resources Utilization Appropriately
10
Network Mode Import
11
Use Securefile Lobs
11
Set Database Compatibility
11
Use the Universal Client
11
Use Compression for Space Efficiency and Performance
12
Check Database Parameters Before a Data Pump Job
13
Use Include and Exclude Parameters
13
Exclude or Include Scheduler Jobs in the Export
14
Exclude a Large index, Build it with Parallelism after Import
14
Additional Practices for Oracle Autonomous Database
14
Perform a Schema or table Level Export
14
Use a Network Link mode Import to Autonomous Database
15
Consider the Access Method
15
Use the DATAPUMP_CLOUD_IMP role
15
Verify the Dumpfile with Checksum
15
Import into a non-partitioned table
16
Use the AL32UTF8 database character set
16
Creating, Transferring or Downloading an ADB Dumpfile Set
16
CONCLUSION
16
of 17
免费下载
【版权声明】本文为墨天轮用户原创内容，转载时必须标注文档的来源（墨天轮），文档链接，文档作者等基本信息，否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容，欢迎发送邮件至：contact@modb.pro进行举报，并提供相关证据，一经查实，墨天轮将立刻删除相关内容。
下载排行榜
评论