ERROR:
ORA-04030: out of process memory when trying to allocate 1230024 bytes (pga heap,redo read desc array)
ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
Tue Dec 09 11:15:32 2014
Dumping diagnostic data in directory=[cdmp_20141209111532], requested by (instance=1, osid=4137), summary=[incident=151217].
Solution:
To resolve the above issue increase sga size.
alter system set sga_max_size=<size>g scope=spfile;
alter system set sga_target=<size>g scope=spfile;
then restart the DB
ORA-04030: out of process memory when trying to allocate 1230024 bytes (pga heap,redo read desc array)
ORA-04030: out of process memory when trying to allocate 4032 bytes (qmxdGetChildNo,qmemNextBuf:alloc)
Tue Dec 09 11:15:32 2014
Dumping diagnostic data in directory=[cdmp_20141209111532], requested by (instance=1, osid=4137), summary=[incident=151217].
Solution:
To resolve the above issue increase sga size.
alter system set sga_max_size=<size>g scope=spfile;
alter system set sga_target=<size>g scope=spfile;
then restart the DB
No comments:
Post a Comment