xtts expdp hung at inital stages

上周6某电信客户进行OSS数据库从aix到Linux的跨平台迁移升级，数据库版本并没有太大变化，即从11.2.0.3 到11.2.0.4。友商在进行3次测试，据说都没有太大问题。

然而，在正式割接时，进行元数据导出时，发现expdp操作hung住，几十分钟都没有任何反应，最后通过dblink的方式直接在目标库进行impdp操作来绕过了该问题。

经查确认是该Oracle Bug 16318046 : TTS EXPORT STUCK AT INITIAL STAGES，关于该bug的描述如下：

Bug 16318046 : TTS EXPORT STUCK AT INITIAL STAGES	

Bug 属性
 
类型	B - Defect	已在产品版本中修复	
严重性	2 - Severe Loss of Service	产品版本	11.2.0.3
状态	36 - Duplicate Bug. To Filer	平台	226 - Linux x86-64
创建时间	2013-2-13	平台版本	NO DATA
更新时间	2016-8-5	基本 Bug	13717234
数据库版本	11.2.0.3	影响平台	Generic
产品源	Oracle	与此 Bug 相关的知识, 补丁程序和 Bug

 
相关产品
 
产品线	Oracle Database Products	系列	Oracle Database Suite
区域	Oracle Database	产品	5 - Oracle Database - Enterprise Edition

Hdr: 16318046 11.2.0.3 RDBMS 11.2.0.3 DATA PUMP EXP PRODID-5 PORTID-226 13717234
Abstract: TTS EXPORT STUCK AT INITIAL STAGES
 
*** 02/12/13 10:36 am ***
 
PROBLEM:
--------
 
expdp "'/ as sysdba'" parfile=auexpxtts.dat
;;;
Export: Release 11.2.0.3.0 - Production on Wed Jan 23 23:00:14 2013
 
Copyright (c) 1982, 2011, Oracle and/or its affiliates.  All rights reserved.
;;;
Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 
64bit Production
With the Partitioning and Oracle Label Security options
Starting "SYS"."SYS_EXPORT_TRANSPORTABLE_01":  "/******** AS SYSDBA" 
parfile=auexpxtts.dat
 
DIAGNOSTIC ANALYSIS:
--------------------
SQL ID: bjf05cwcj5s6p
Plan Hash: 0
BEGIN :1 := sys.kupc$que_int.receive(:2); END;
 
 
call     count       cpu    elapsed       disk      query    current        
rows
------- ------  -------- ---------- ---------- ---------- ----------  
----------
Parse    16229      1.79       2.17          0          0          0          
 0
Execute  16228     45.18   81114.46          0      65309          0          
26
Fetch        0      0.00       0.00          0          0          0          
 0
------- ------  -------- ---------- ---------- ---------- ----------  
----------
total    32457     46.98   81116.63          0      65309          0          
26
 
Misses in library cache during parse: 1
Misses in library cache during execute: 1
Optimizer mode: ALL_ROWS
Parsing user id: SYS   (recursive depth: 2)
 
Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  wait for unread message on broadcast channel
                                              81109        1.38      81058.42
  library cache: mutex X                          2        0.00          0.00
  library cache lock                              1        4.69          4.69
******************************************************************************
**
 
Trace file: P2PDB21_dm03_34603216.trc
 
 
SQL ID: bjf05cwcj5s6p
Plan Hash: 0
BEGIN :1 := sys.kupc$que_int.receive(:2); END;
 
 
call     count       cpu    elapsed       disk      query    current        
rows
------- ------  -------- ---------- ---------- ---------- ----------  
----------
Parse      140      0.01       0.01          0          0          0          
 0
Execute    140      0.33     496.10          0       1656          0          
70
Fetch        0      0.00       0.00          0          0          0          
 0
------- ------  -------- ---------- ---------- ---------- ----------  
----------
total      280      0.34     496.11          0       1656          0          
70
 
Misses in library cache during parse: 0
Optimizer mode: ALL_ROWS
Parsing user id: SYS   (recursive depth: 2)
 
Elapsed times include waiting on following events:
  Event waited on                             Times   Max. Wait  Total Waited
  ----------------------------------------   Waited  ----------  ------------
  wait for unread message on broadcast channel
                                                519        1.12        495.72
******************************************************************************
**
 
Trace file: P2PDB21_dw00_37552328.trc
 
SQL ID: 82n5hj2hgrbdx
Plan Hash: 2296790768
SELECT  objnum 
FROM
  (SELECT r, objnum FROM   (SELECT rownum r, o.obj# objnum    FROM  sys.obj$ 
  o, sys.tab$ t, sys.dba_xml_tab_cols x,  sys.user$ u    WHERE  t.ts# = :1   
  AND t.obj# = o.obj# AND  o.name = x.table_name AND o.owner# = u.user# AND  
  u.name = x.owner AND  (x.storage_type = 'BINARY') AND  NOT EXISTS (SELECT 1 
 
  FROM   sys.ku_noexp_tab noexp WHERE  noexp.obj_type =  'USER' AND 
  noexp.name = u.name)) ) WHERE r = 1 
 
 
call     count       cpu    elapsed       disk      query    current        
rows
------- ------  -------- ---------- ---------- ---------- ----------  
----------
Parse        1      0.00       0.00          0          0          0          
 0
Execute    436      0.12       0.14          0        680          0          
 0
Fetch      435  75154.06   79676.07          1   56238520          0          
 0
------- ------  -------- ---------- ---------- ---------- ----------  
----------
total      872  75154.19   79676.21          1   56239200          0          
 0
 
WORKAROUND:
-----------
use normal export but ct using EBS and required to use datapump.
 
RELATED BUGS:
-------------
Bug:13728919 
 
REPRODUCIBILITY:
----------------
 
TEST CASE:
----------
 
STACK TRACE:
------------
 
SUPPORTING INFORMATION:
-----------------------
 
24 HOUR CONTACT INFORMATION FOR P1 BUGS:
----------------------------------------
 
DIAL-IN INFORMATION:
--------------------

在此记录一下，希望大家以后在进行xtts跨平台迁移时注意这个问题，不要再次掉到坑里。