CTCNKMF 2015/09/10
. . exporting table SALES_STATISTIC
EXP-00056: ORACLE error 3113 encountered
ORA-03113: end-of-file on communication channel
EXP-00008: ORACLE error 1023 encountered
ORA-01023: Cursor context not found (Invalid cursor number)
EXP-00000: Export terminated unsuccessfully
CTCNSLF 2015/09/10
EXP-00056: ORACLE error 1555 encountered
ORA-01555: snapshot too old: rollback segment number 11 with name "_SYSSMU11$" too small
EXP-00000: Export terminated unsuccessfully
*****(快照过旧)1.增大表空间 2.undo保留时间 3.改变SQL执行效率
*****
select begin_time,end_time,undoblks
from v$undostat; 进程数
*****
select max(undoblks / ((end_time - begin_time)*24*3600)) from v$undostat;进程中使用最多block块大小
*****SELECT (UR * (UPS * DBS))/1024/1024 AS "M"
FROM (select max(tuned_undoretention) AS UR from v$undostat),
(SELECT undoblks/((end_time-begin_time)*86400) AS UPS
FROM v$undostat
WHERE undoblks = (SELECT MAX(undoblks) FROM v$undostat)),
(SELECT block_size AS DBS
FROM dba_tablespaces
WHERE tablespace_name = (SELECT UPPER(value) FROM v$parameter WHERE name = 'undo_tablespace'));
查询所需的undo表空间的最大值
CTCNJCF 2015/09/11
[
oracle@CTDBJCF01 CTCNJCF]$ cat CTCNJCF_110915.log | grep ORA
EXP-00056: ORACLE error 12161 encountered
ORA-12161: TNS:internal error: partial data received
EXP-00056: ORACLE error 12161 encountered
ORA-12161: TNS:internal error: partial data received
网络问题,暂且归结于网络问题