暂无图片
expdp 导出表特别慢
我来答
分享
宋化鑫
2020-05-13
expdp 导出表特别慢

expdp在导出带有LOB字段的表的时候速度特别慢,大佬们有没有解决方法啊?

我来答
添加附件
收藏
分享
问题补充
4条回答
默认
最新
zouxiang
  1. 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.

  2. 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
Xiaofei Huangfu

1,查询一下等待事件
2,检查内存设置

暂无图片 评论
暂无图片 有用 0
马平

1.如果没有必要可以不去导统计信息
2.加并行

暂无图片 评论
暂无图片 有用 0
张sir

lob导出确实很慢,不能用并行,感觉没辙

暂无图片 评论
暂无图片 有用 0
回答交流
提交
问题信息
请登录之后查看
邀请回答
暂无人订阅该标签,敬请期待~~
暂无图片墨值悬赏