expdp 导出表特别慢
expdp在导出带有LOB字段的表的时候速度特别慢,大佬们有没有解决方法啊?
我来答
添加附件
收藏
复制链接
微信扫码分享
在小程序上查看
分享
添加附件
问题补充
4条回答
默认
最新
-
If the table is partitioned, then there would be n DataPump Worker processes active (where n is the value of the parallel parameter), each unloading data from one of the table partitions.
-
Include a where clause in the EXPDP command to segment the export and run multiple EXPDP to simulate parallelism:
The expdp command has a QUERY parameter which enables you to filter the data that is exported by specifying a clause for a SQL SELECT statement.
The query_clause is typically a WHERE clause for fine-grained row selection, but could be any SQL clause
This QUERY parameter could be used to run different exports from the same table at the same time, exporting a range of rows in each operation.
评论
有用 0采纳答案后不可修改和取消
1,查询一下等待事件
2,检查内存设置
评论
有用 0回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
墨值悬赏

