我的环境是 sun solairs 9.
32位的.
内存16G我使用 logminer 分析日志的时候出现:
SQL> EXECUTE dbms_logmnr.add_logfile(LogFileName=>'/prod/prod/arch/arch_PROD_1_111187.arc', Options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> EXECUTE dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oraprod/logs/june1.ora');
BEGIN dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oraprod/logs/june1.ora'); END;
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 5148 bytes
(krvdpqi,KRVD:halc)
那位高手帮忙解决下,着急中`````````
32位的.
内存16G我使用 logminer 分析日志的时候出现:
SQL> EXECUTE dbms_logmnr.add_logfile(LogFileName=>'/prod/prod/arch/arch_PROD_1_111187.arc', Options=>dbms_logmnr.new);
PL/SQL procedure successfully completed.
SQL> EXECUTE dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oraprod/logs/june1.ora');
BEGIN dbms_logmnr.start_logmnr(DictFileName=>'/export/home/oraprod/logs/june1.ora'); END;
*
ERROR at line 1:
ORA-04030: out of process memory when trying to allocate 5148 bytes
(krvdpqi,KRVD:halc)
那位高手帮忙解决下,着急中`````````
解决方案 »
- java与Oracle
- vc+oracle+ado
- 用 http://localhost:1158/em 导出数据, 主机身份证明 用户名 口令填写什么?
- 如何把日期转换成这样的串:MM/DD/YYYY HH:MI:SS AM/PM eg. 12/14/2005 12:50:54 AM
- 【请问】package.procedure 与procedure在运行效率上有什么区别
- oracle8.X备份的菜问题
- 请问一个简单的问题
- 用OEM工具向数据库导入一个DMP文件时,显示authentic error,什么情况?
- Oracle9i Update时出现的奇怪问题
- vs2010在win7 64位环境下通过OCCI访问Oracle总是出错,怎么办?
- 关于数据库访问情况统计的问题
- 请大家推荐一本较有艺术感的sql书籍
楼主在安装Oracle的时候有没有修改操作系统SHELL 参数,检查一下看看。Configure Shell Limits
Oracle recommends that you set shell limits and system configuration parameters as described in this section.The ulimit settings determine process memory related resource limits. Verify that the shell limits displayed in the following table are set to the values shown:Shell Limit Recommended Value
TIME -1 (Unlimited)
FILE -1 (Unlimited)
DATA Minium value: 1048576
STACK Minium value: 32768
NOFILES Minium value: 4096
VMEMORY Minium value: 4194304
To display the current value specified for these shell limits enter the following commands:ulimit -t
ulimit -f
ulimit -d
ulimit -s
ulimit -n
ulimit -v参考Oracle 官方安装文档:
http://download.oracle.com/docs/cd/B19306_01/relnotes.102/b15696/toc.htm
------------------------------------------------------------------------------
Blog: http://blog.csdn.net/tianlesoftware
网上资源: http://tianlesoftware.download.csdn.net
相关视频:http://blog.csdn.net/tianlesoftware/archive/2009/11/27/4886500.aspx
DBA1 群:62697716(满); DBA2 群:62697977
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 8192
coredump(blocks) unlimited
nofiles(descriptors) 256
memory(kbytes) unlimited
我这个都没有限制啊
DATA Minium value: 1048576
STACK Minium value: 32768
NOFILES Minium value: 4096
VMEMORY Minium value: 4194304 这些是建议值,如果不行,就改成Unlimited,然后重启一下看看。
服务器现在就跑一个Oracle 还是跑了其他东西?
SGA 和 PGA 现在是多少?
sga_max_size big integer 3566166528
pga_aggregate_target big integer 1048576000应该够大了吧,数据库是9I的
有个 EBS 和 Oracle 就这两个