免费注册 查看新帖 |

Chinaunix

  平台 论坛 博客 文库
最近访问板块 发新帖
查看: 1526 | 回复: 0

sqlldr直接路径导入遇到ORA-4030 [复制链接]

论坛徽章:
0
发表于 2011-12-22 08:54 |显示全部楼层
 
15亿+条的记录,用sqlldr导入,9个多小时后遇到ORA-4030。
调整了一些参数后再进行,同样也是在9个多小时以ORA-4030结束。
 
Sweep [inc2][132427]: completed
Trace dumping is performing id=[cdmp_20110810190110]
Wed Aug 10 19:01:11 2011
Errors in file /u01/app/oracle/diag/rdbms/ddns_fs/peanut/incident/incdir_132426/peanut_ora_20743_i132426.trc:
ORA-04030: out of process memory when trying to allocate 82456 bytes (pga heap,control file i/o buffer)
ORA-04030: out of process memory when trying to allocate 65560 bytes (klcalh:ld_hds,kdblc memory)
Trace dumping is performing id=[cdmp_20110810190112]
Wed Aug 10 19:02:08 2011
Sweep [inc2][132428]: completed
Sweep [inc2][132426]: completed
 
调整的部分参数
ALTER SYSTEM SET parallel_servers_target=32 SCOPE=BOTH;
Wed Aug 10 19:22:54 2011
ALTER SYSTEM SET open_cursors=1000 SCOPE=BOTH;
Wed Aug 10 19:24:31 2011
ALTER SYSTEM SET processes=300 SCOPE=SPFILE;
Wed Aug 10 19:24:46 2011
ALTER SYSTEM SET session_cached_cursors=100 SCOPE=SPFILE;
Wed Aug 10 19:25:25 2011
ALTER SYSTEM SET sga_max_size='1G' SCOPE=SPFILE;
Wed Aug 10 19:25:52 2011
ALTER SYSTEM SET sort_area_size=0 SCOPE=SPFILE;
[root@localhost ~]# cat /etc/sysctl.conf | grep shmmax
kernel.shmmax = 68719476736
#kernel.shmmax = 536870912
 
[root@oray ~]# ulimit -a
core file size          (blocks, -c) 0
data seg size           (kbytes, -d) unlimited
scheduling priority             (-e) 0
file size               (blocks, -f) unlimited
pending signals                 (-i) 137216
max locked memory       (kbytes, -l) 32
max memory size         (kbytes, -m) unlimited
open files                      (-n) 1024
pipe size            (512 bytes, -p) 8
POSIX message queues     (bytes, -q) 819200
real-time priority              (-r) 0
stack size              (kbytes, -s) 10240
cpu time               (seconds, -t) unlimited
max user processes              (-u) 137216
virtual memory          (kbytes, -v) unlimited
file locks                      (-x) unlimited
您需要登录后才可以回帖 登录 | 注册

本版积分规则 发表回复

  

北京盛拓优讯信息技术有限公司. 版权所有 京ICP备16024965号-6 北京市公安局海淀分局网监中心备案编号:11010802020122 niuxiaotong@pcpop.com 17352615567
未成年举报专区
中国互联网协会会员  联系我们:huangweiwei@itpub.net
感谢所有关心和支持过ChinaUnix的朋友们 转载本站内容请注明原作者名及出处

清除 Cookies - ChinaUnix - Archiver - WAP - TOP