oracle 单机 11.2.0.4数据库在导出的时候报如下的错：
ORA-31693: Table data object "HEILONGJIANG"."T_PERF_WEBRTT":"P_FUTURE" failed to load/unload and is being skipped due to error:
ORA-02354: error in exporting/importing data
ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6_1263032392$" too small
请问解决思路如何？

空间的使用率是如下这样的：
------------------------------ ---------- ---------- ---------- ----------
NGOSS_TBSPACE3 60 59.9849854 .015014648 .03
DOMAIN_TBSPACE1 450 126.960266 323.039734 71.79
SYSAUX 5.63476563 .273925781 5.36083984 95.14
UNDOTBS1 5.64453125 5.47033691 .174194336 3.09
NGOSS_TBSPACE2 1080 214.309021 865.690979 80.16
USERS .004882813 .000915527 .003967285 81.25
SYSTEM 2.15820313 .002319336 2.15588379 99.89
EXAMPLE .338134766 .035217285 .30291748 89.58
SHANXI_TBSPACE1 180 31.2505493 148.749451 82.64
SICHUAN_TBSPACE1 150 24.8796387 125.120361 83.41

增大undo

ORA-01555: snapshot too old: rollback segment number 6 with name "_SYSSMU6_1263032392$" too small
上传alert.log 其中会有关于ORA-01555的进一步信息

你分析了dw00的ASH吗？ 既然它100%CPU 那么显然他还在做事 而不是彻底hang。

那么分析dw00的ASH和看它是否有trace咯

刘大当时我看他 生成的trace没有报错啊只是卡在了下个对象hang着的现象

trace文件中显示的就是如下的代码：
KUPW:20:43:48.402: 1: CHAR set id: 0
KUPW:20:43:48.402: 1: NCHAR set id: 0
KUPW:20:43:48.402: 1: In procedure FORMAT_TABLE_DATA_MSG
KUPW:20:43:48.403: 1: In procedure CREATE_MSG
KUPW:20:43:48.403: 1: KUPV$FT.MESSAGE_TEXT called.
KUPW:20:43:48.403: 1: KUPV$FT.MESSAGE_TEXT returned.
KUPW:20:43:48.403: 1: In procedure SEND_MSG. Fatal=0
KUPW:20:43:48.403: 1: KUPC$QUEUE_INT.SEND called.
KUPW:20:43:48.404: 1: KUPC$QUEUE_INT.SEND returned.
KUPW:20:43:48.404: 1: . . exported "HEILONGJIANG"."NS_MEDIASPEED":"P_201305" 1.029 MB 2895 rows
KUPW:20:43:48.404: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:20:43:48.404: 1: In procedure MOVE_DATA UNLOADing process_order 1016 TABLE_DATA:"HEILONGJIANG"."NS_WEBSPEED":"P_201306"
KUPW:20:43:48.405: 1: KUPD$DATA.OPEN called.
KUPW:20:43:48.405: 1: KUPD$DATA.OPEN returned.
KUPW:20:43:48.405: 1: KUPD$DATA.SET_PARAMETER - common called.
KUPW:20:43:48.406: 1: KUPD$DATA.SET_PARAMETER - common returned.
KUPW:20:43:48.406: 1: KUPD$DATA.SET_PARAMETER - flags called.
KUPW:20:43:48.406: 1: KUPD$DATA.SET_PARAMETER - flags returned.
KUPW:20:43:48.406: 1: KUPD$DATA.START_JOB called.
KUPW:20:43:48.424: 1: KUPD$DATA.START_JOB returned. In procedure GET_JOB_VERSION
KUPW:20:43:48.441: 1:
KUPW:20:43:48.441: 1: CHAR set id: 0
KUPW:20:43:48.441: 1: NCHAR set id: 0
KUPW:20:43:48.441: 1: In procedure FORMAT_TABLE_DATA_MSG
KUPW:20:43:48.442: 1: In procedure CREATE_MSG
KUPW:20:43:48.442: 1: KUPV$FT.MESSAGE_TEXT called.
KUPW:20:43:48.442: 1: KUPV$FT.MESSAGE_TEXT returned.
KUPW:20:43:48.442: 1: In procedure SEND_MSG. Fatal=0
KUPW:20:43:48.442: 1: KUPC$QUEUE_INT.SEND called.
KUPW:20:43:48.443: 1: KUPC$QUEUE_INT.SEND returned.
KUPW:20:43:48.443: 1: . . exported "HEILONGJIANG"."NS_WEBSPEED":"P_201306" 796.3 KB 9342 rows
KUPW:20:43:48.443: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:20:43:48.443: 1: In procedure MOVE_DATA UNLOADing process_order 1017 TABLE_DATA:"HEILONGJIANG"."NS_WEBSPEED":"P_201309"
KUPW:20:43:48.444: 1: KUPD$DATA.OPEN called.
KUPW:20:43:48.444: 1: KUPD$DATA.OPEN returned.
KUPW:20:43:48.444: 1: KUPD$DATA.SET_PARAMETER - common called.
KUPW:20:43:48.445: 1: KUPD$DATA.SET_PARAMETER - common returned.
KUPW:20:43:48.445: 1: KUPD$DATA.SET_PARAMETER - flags called.
KUPW:20:43:48.445: 1: KUPD$DATA.SET_PARAMETER - flags returned.
KUPW:20:43:48.445: 1: KUPD$DATA.START_JOB called.
*** 2016-04-21 20:43:48.468
KUPW:20:43:48.468: 1: KUPD$DATA.START_JOB returned. In procedure GET_JOB_VERSION
KUPW:20:43:48.497: 1:
KUPW:20:43:48.497: 1: CHAR set id: 0
KUPW:20:43:48.497: 1: NCHAR set id: 0
KUPW:20:43:48.497: 1: In procedure FORMAT_TABLE_DATA_MSG
KUPW:20:43:48.497: 1: In procedure CREATE_MSG
KUPW:20:43:48.498: 1: KUPV$FT.MESSAGE_TEXT called.
KUPW:20:43:48.498: 1: KUPV$FT.MESSAGE_TEXT returned.
KUPW:20:43:48.498: 1: In procedure SEND_MSG. Fatal=0
KUPW:20:43:48.498: 1: KUPC$QUEUE_INT.SEND called.
KUPW:20:43:48.499: 1: KUPC$QUEUE_INT.SEND returned.
KUPW:20:43:48.499: 1: . . exported "HEILONGJIANG"."NS_WEBSPEED":"P_201309" 1.311 MB 16111 rows
KUPW:20:43:48.499: 1: In procedure BUILD_OBJECT_STRINGS
KUPW:20:43:48.499: 1: In procedure MOVE_DATA UNLOADing process_order 1018 TABLE_DATA:"HEILONGJIANG"."RTT_TONGJI"
KUPW:20:43:48.500: 1: KUPD$DATA.OPEN called.
KUPW:20:43:48.500: 1: KUPD$DATA.OPEN returned.
KUPW:20:43:48.500: 1: KUPD$DATA.SET_PARAMETER - common called.
KUPW:20:43:48.501: 1: KUPD$DATA.SET_PARAMETER - common returned.
KUPW:20:43:48.501: 1: KUPD$DATA.SET_PARAMETER - flags called.
KUPW:20:43:48.501: 1: KUPD$DATA.SET_PARAMETER - flags returned.
KUPW:20:43:48.501: 1: KUPD$DATA.START_JOB called.
[oracle@DB100 trace]$

刘大，这是从ash报告中出现的结果，我截取的是昨天晚上hang的时间段中的15分钟，显示的信息，请帮忙分析

一般不截图 建议上传整个报告到百度云盘后共享
CPU + WAIT FOR CPU 说明确实有很多CPU运算，另有一部分的db file sequential read 等待则可能为链式行或特殊数据类型所致。

[无效] http://pan.baidu.com/s/1jINHm1w
刘大连接已经附上，请查看