ITPUX技术网

交流 . 资讯 . 分享
Make progress together!
Oracle数据库DBA高级工程师培训视频
Oracle数据库培训-备份恢复-性能优化-集群容灾
mysql数据库视频教程

oracle expdp导出元数据TABLE COMMENT过程hang住遭遇bug14192178

内容发布:风哥| 发布时间:2016-7-26 18:09:35
expdp导出元数据时遭遇bug,TABLE COMMENT过程hang住了

在做expdp过程中,hang在以下位置几十个小时,
..Processing object type SCHEMA_EXPORT/TABLE/COMMENT

通过expdp过程指定TRACE=480300 :

Export/Import DataPump Parameter TRACE - How to Diagnose Oracle Data Pump (文档 ID 286496.1)

输出hang的trace 日志信息如下:
KUPW:12:24:27.492: 1: TABLE
KUPW:12:24:27.492: 1: NEW_SR_INCOME
KUPW:12:24:27.493: 1: WC_NSUP2_R_ACCL_ANSW_BN_MA_F
KUPW:12:24:27.494: 1: Base Process info: 41996 and processing status: C and processing state: R
KUPW:12:24:27.494: 1: new state: R
KUPW:12:24:27.494: 1: new status: C
KUPW:12:24:27.494: 1: In procedure BUILD_SUBNAME_LIST with COMMENT:.
KUPW:12:24:27.494: 1: In function NEXT_PO_NUMBER
KUPW:12:24:27.494: 1: KUPF$FILE.WRITE_LOB called.
KUPW:12:24:27.498: 1: KUPF$FILE.WRITE_LOB returned.
KUPW:12:24:27.498: 1: MD FilePieces Count: 1
KUPW:12:24:27.498: 1: FORALL called.
KUPW:12:24:27.510: 1: FORALL returned.
KUPW:12:24:27.511: 1: DBMS_LOB.TRIM called. v_md_xml_clob
KUPW:12:24:27.511: 1: DBMS_LOB.TRIM returned.
KUPW:12:24:27.511: 1: DBMS_METADATA.FETCH_XML_CLOB called. Handle: 100001


同时再结合10046事件,分析出hang在以下系统表:
DW slaves showing time executing SQL likely to be of the form    "SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(...FROM SYS.KU$_ACPTABLE_VIEW..."

10046 trace expdp进程方法如下:
游客,如果您要查看本帖隐藏内容请回复


通过诊断后,确认bug:14192178 ,通过对数据库进行patch后解决。
Bug 14192178 - EXPDP of partitioned table can be slow (文档 ID 14192178.8)

Description
This problem is introduced in 11.2.0.3

Datapump export (EXPDP) of partitioned objects can be slow compared to earlier releases.
There have been several separate bug fixes which attempted to address this expdp performanceissue for various internal queries such as bug 13844935, bug 13914808 , bug 13898265 and bug 14006804.
This fix effectively supersedes all of those fixes and can also help for some IMPDP / import operations and some DBMS_METADATA queries.

Rediscovery Notes
Observe poor performance of datapump export of partitioned objects in 11.2.0.3 DW slaves showing time executing SQL likely to be of the form   
"SELECT /*+all_rows*/ SYS_XMLGEN(VALUE(KU$), XMLFORMAT.createFormat2(...FROM SYS.KU$_ACPTABLE_VIEW...

" Workaround None Note:
For interim patches you should only need the fix for this bug.   
Fixes for earlier bugs 13844935, bug 13914808 , bug 13898265 and bug 14006804 should  not be required if you have this fix (14192178) Getting a Fix Use one of the "Fixed" versions listed above (for Patch Sets / bundles use the latest version available as  contents are cumulative - the "Fixed" version listed above is  the first version where the fix is included) or You can check for existing interim patches here: Patch:14192178



上一篇:oracle远程expdp与exp一些问题说明-EXP-00113
下一篇:Oracle数据库删除undo表空间遇到ORA-30013及ORA-01548的解决方案
189070296,150201289

专业提供Oracle数据库服务、主机、存储、备份、中间件等相关技术支持服务,QQ号:176140749
关注ITPUX技术网微信公众号itpux_com  ,了解本站最新技术资料的分享.

欢迎加QQ群,提供超多高质量Oracle/Unix/Linux技术文档与视频教程的下载。

Oracle/MySQL/Linux群4-5:189070296  150201289  
Oracle/MySQL/Linux群6-8:244609803   522261684   522651731
备注:请勿重复加群,另请注明 from itpux

加群分享视频教程部分如下:

1、公开课视频:Oracle/MySQL数据库工程师职业发展前景讲解(免费)
http://edu.51cto.com/course/7015.html

2、51CTO学院Oracle数据库高级工程师培训(高薪就业.课程介绍)
http://edu.51cto.com/px/train/131?xiaotu

3、Oracle DBA数据库高级工程师培训视频课程1.1(系列78套+七大阶段+上千案例)
套餐视频地址: http://edu.51cto.com/topic/1121.html

4、MySQL数据库(终身门徒)套餐:http://edu.51cto.com/sd/1e1a6

回复

使用道具 举报

内容发布:dylan| 发布时间:前天 13:35
棒棒的。。。。。。。。。。。。。。。。。。。。
回复

使用道具 举报

内容发布:shuiganjiuying2| 发布时间:2019-2-26 14:25:52

学习
学习
学习
学习
学习
学习
学习
学习
学习
学习
回复 支持 反对

使用道具 举报

内容发布:sealion| 发布时间:2018-12-12 16:34:16
好贴,讲得清楚,详细。可操作性强
回复 支持 反对

使用道具 举报

内容发布:jackmao90| 发布时间:2018-9-5 09:45:52
好好学习,了解一下下!!!!!!!!
回复 支持 反对

使用道具 举报

1框架
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

快速回复 返回顶部 返回列表