ORA-04030 out of process memory when trying to allocate string bytes (string,string) Cause: Operating system process private memory has been exhausted. Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.应该是某些资源没有及时释放引起的,还是要根据当前SGA的状况检查你的应用程序
我的sort_area_size 是 524288。
系统配置:2 CPU,1G内存,呼叫中心模式,每天试运行呼叫量1000左右。
以下是我的init.ora文件
background_dump_dest = /data1/admin/ora9i/bdump
compatible = 9.0.0
control_files = ('/data1/oradata/ora9i/control01.ctl', '/data1/oradata/ora9i/control03.ctl', '/data1/oradata/ora9i/control02.ctl')
core_dump_dest = /data1/admin/ora9i/cdump
db_block_size = 8192
db_cache_size = 301989888
db_domain = ''
db_files = 1000
db_name = ora9i
dispatchers = '(PROTOCOL=TCP)(SER=MODOSE)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.GiopServer)','(PROTOCOL=TCP)(PRE=oracle.aurora.server.SGiopServer)','(protocol=TCP)(mul=OFF)(sess=800)'
fast_start_mttr_target = 300
instance_name = ora9i
java_pool_size = 33554432
large_pool_size = 150000000
log_archive_dest_1 = 'LOCATION=/ora/OraHome1/dbs/arch'
mts_sessions = 800
open_cursors = 800
parallel_threads_per_cpu = 4
processes = 1000
remote_login_passwordfile = EXCLUSIVE
resource_manager_plan = 'SYSTEM_PLAN'
sessions = 1105
shared_pool_size = 150994944
shared_server_sessions = 800
sort_area_size = 524288
timed_statistics = TRUE
undo_management = AUTO
undo_tablespace = UNDOTBS
user_dump_dest = /data1/admin/ora9i/udump大家帮我参谋一下吧!
(string,string)
Cause: Operating system process private memory has been exhausted.
Action: See the database administrator or operating system administrator to increase process memory quota. There may be a bug in the application that causes excessive allocations of process memory space.应该是某些资源没有及时释放引起的,还是要根据当前SGA的状况检查你的应用程序
所谓的process memory对于初始化参数里并没有,只是一种整体的概念吧?
我的客户程序里面一般是记录集recordset没有关闭,但connection肯定用完就关闭的。记录集的程序不关闭对于服务器有影响吗?只是对客户机的内存影响吗?
那些mts相关参数有没有什么需要调整的,我的oracle9i被设置成共享服务器模式。
谢谢你,以前也没少得到你的帮助。回头我试一下。我把shared_pool_size
改成100MB试一下