Oracle数据库数据恢复、性能优化

找回密码
注册
搜索
热搜: 活动 交友 discuz
发新帖

85

积分

1

好友

2

主题
1#
发表于 2012-5-25 15:32:56 | 查看: 7671| 回复: 2
环境:aix5.3 oracle10.2.4  expdp出一份dmp,在suse11 oracle11.2.0.2里面impdp,系统数据库均是64位,suse11机器内存16G,sga=6g,pga=4g,就做了impdp操作,涉及一张30G左右的分区表及其上的两个各约10G的索引,导出和导入语句:
导出语句 expdp system/******* directory=expdp_dir tables=riskmgr.t_trans_info dumpfile=t_trans_info.dmp;
导入语句impdp mlsmgr/******* DIRECTORY=dmp_dir dumpfile=t_trans_info.dmp tables=riskmgr.t_trans_info remap_schema=riskmgr:mlsmgr remap_tablespace=riskdata:fxqtest_tbs

trace文件上传附件,impdp报错内容如下:
Processing object type TABLE_EXPORT/TABLE/INDEX/STATISTICS/INDEX_STATISTICS
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
ORA-39083: Object type INDEX_STATISTICS failed to create with error:
ORA-04030: out of process memory when trying to allocate 4088 bytes (PLS CGA hp,pdzgM64_New_Link)
Failing sql is:
DECLARE I_N VARCHAR2(60);   I_O VARCHAR2(60);   NV VARCHAR2(1);   c DBMS_METADATA.T_VAR_COLL;   df varchar2(21) := 'YYYY-MM-DD:HH24:MI:SS';  stmt varchar2(300) := ' INSERT INTO "SYS"."IMPDP_STATS" (type,version,flags,c1,c2,c3,c5,n1,n2,n3,n4,n5,n6,n7,n8,n9,n10,n11,n12,d1,cl1) VALUES (''I'',6,:1,:2,:3,:4,:5,:6,:7,:8,:9,:10,:11,
Processing object type TABLE_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 1 with process name "DW00" prematurely terminated
ORA-31671: Worker process DW00 had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
ORA-39014: One or more workers have prematurely exited.
ORA-39029: worker 12 with process name "DW0B" prematurely terminated
ORA-31671: Worker process DW0B had an unhandled exception.
ORA-04030: out of process memory when trying to allocate 16048 bytes (session heap,kuxLpxAlloc)
ORA-06512: at "SYS.KUPW$WORKER", line 1751
ORA-06512: at line 2
Job "MLSMGR"."SYS_IMPORT_TABLE_01" stopped due to fatal error at 13:36:59

fxqora_dw00_11011_i45010.rar

2.74 KB, 下载次数: 813

2#
发表于 2012-5-25 15:50:40
suse11上oracle用户的limits

oracle@fxq-02:~> ulimit -a
core file size          (blocks, -c) unlimited
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 127210
max locked memory       (kbytes, -l) 64
max memory size         (kbytes, -m) 13848624
open files                      (-n) 65536
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 8192
cpu time               (seconds, -t) unlimited
max user processes              (-u) 16384
virtual memory          (kbytes, -v) 26451440
file locks                      (-x) unlimited

[ 本帖最后由 kylefree 于 2012-5-25 15:52 编辑 ]

回复 只看该作者 道具 举报

3#
发表于 2012-5-25 16:02:00

回复 2# 的帖子

带上EXCLUDE=STATISTICS参数试试呢

回复 只看该作者 道具 举报

您需要登录后才可以回帖 登录 | 注册

QQ|手机版|Archiver|Oracle数据库数据恢复、性能优化

GMT+8, 2024-12-26 02:13 , Processed in 0.052533 second(s), 24 queries .

Powered by Discuz! X2.5

© 2001-2012 Comsenz Inc.

回顶部
TEL/電話+86 13764045638
Email service@parnassusdata.com
QQ 47079569