ORA-04030: 在尝试分配 1044 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足 ORA-04030: 在尝试分配 2556 字节 (kxs-heap-b,bind var buf) 时进程内存不足 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9901): ORA-04030: 在尝试分配 1044 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足 ORA-04030: 在尝试分配 1044 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足 ORA-04030: 在尝试分配 2556 字节 (kxs-heap-b,bind var buf) 时进程内存不足 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9902): ORA-04030: 在尝试分配 5392 字节 (kxs-heap-w,Scan compression ctx) 时进程内存不足 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9903): ORA-04030: 在尝试分配 2068 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足 Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_lgwr_1904.trc (incident=8761): ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer) Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_lgwr_1904.trc: ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer) LGWR (ospid: 1904): terminating the instance due to error 4030 Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_cjq0_3848.trc (incident=9321): ORA-04030: out of process memory when trying to allocate bytes (,) Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_pmon_2992.trc (incident=8689): ORA-04030: out of process memory when trying to allocate bytes (,) Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_mmnl_404.trc (incident=8801): ORA-04030: out of process memory when trying to allocate bytes (,) Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_j001_3492.trc (incident=9874): ORA-04030: out of process memory when trying to allocate bytes (,) Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_j001_3492.trc: ORA-04030: out of process memory when trying to allocate bytes (,) ORA-1092 : opidrv aborting process J001 ospid (3864_3492) Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ckpt_2612.trc (incident=8769): ORA-04030: out of process memory when trying to allocate bytes (,) Fri Oct 24 05:35:01 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_smon_1824.trc (incident=8777): ORA-04030: out of process memory when trying to allocate bytes (,) Fri Oct 24 05:35:02 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_diag_1252.trc (incident=8705): ORA-04030: out of process memory when trying to allocate bytes (,) DDE: Problem Key 'ORA 4030' was completely flood controlled (0x6) Further messages for this problem key will be suppressed for up to 10 minutes Fri Oct 24 05:35:02 2014 Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_q001_3280.trc: ORA-04030: out of process memory when trying to allocate bytes (,) ORA-1092 : opidrv aborting process Q001 ospid (3864_3280) Fri Oct 24 05:35:03 2014 ORA-4030 : opidrv aborting process S000 ospid (3864_2216) Fri Oct 24 05:35:03 2014 ORA-1092 : opidrv aborting process W000 ospid (3864_2436) Instance terminated by LGWR, pid = 1904
也看看控制面板里面 事件探测器 有么有提示
ORA-04030: 在尝试分配 2556 字节 (kxs-heap-b,bind var buf) 时进程内存不足
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9901):
ORA-04030: 在尝试分配 1044 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足
ORA-04030: 在尝试分配 1044 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足
ORA-04030: 在尝试分配 2556 字节 (kxs-heap-b,bind var buf) 时进程内存不足
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9902):
ORA-04030: 在尝试分配 5392 字节 (kxs-heap-w,Scan compression ctx) 时进程内存不足
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ora_3292.trc (incident=9903):
ORA-04030: 在尝试分配 2068 字节 (Typecheck,kggfaDoKghAlloc) 时进程内存不足
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_lgwr_1904.trc (incident=8761):
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_lgwr_1904.trc:
ORA-04030: out of process memory when trying to allocate 82444 bytes (pga heap,control file i/o buffer)
LGWR (ospid: 1904): terminating the instance due to error 4030
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_cjq0_3848.trc (incident=9321):
ORA-04030: out of process memory when trying to allocate bytes (,)
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_pmon_2992.trc (incident=8689):
ORA-04030: out of process memory when trying to allocate bytes (,)
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_mmnl_404.trc (incident=8801):
ORA-04030: out of process memory when trying to allocate bytes (,)
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_j001_3492.trc (incident=9874):
ORA-04030: out of process memory when trying to allocate bytes (,)
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_j001_3492.trc:
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-1092 : opidrv aborting process J001 ospid (3864_3492)
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_ckpt_2612.trc (incident=8769):
ORA-04030: out of process memory when trying to allocate bytes (,)
Fri Oct 24 05:35:01 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_smon_1824.trc (incident=8777):
ORA-04030: out of process memory when trying to allocate bytes (,)
Fri Oct 24 05:35:02 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_diag_1252.trc (incident=8705):
ORA-04030: out of process memory when trying to allocate bytes (,)
DDE: Problem Key 'ORA 4030' was completely flood controlled (0x6)
Further messages for this problem key will be suppressed for up to 10 minutes
Fri Oct 24 05:35:02 2014
Errors in file e:\app\administrator\diag\rdbms\sbdb\sbdb\trace\sbdb_q001_3280.trc:
ORA-04030: out of process memory when trying to allocate bytes (,)
ORA-1092 : opidrv aborting process Q001 ospid (3864_3280)
Fri Oct 24 05:35:03 2014
ORA-4030 : opidrv aborting process S000 ospid (3864_2216)
Fri Oct 24 05:35:03 2014
ORA-1092 : opidrv aborting process W000 ospid (3864_2436)
Instance terminated by LGWR, pid = 1904
ALERT信息见5楼。我给分配了2g,服务器现在用的人不多,但是不知道oracle内存占用一直往上蹦
http://www.itpub.net/thread-1030911-1-1.html
http://ibmcn.blog.51cto.com/510174/655741
http://blog.itpub.net/10834762/viewspace-445622
可以参考这些设置。
但是最好装64位