a****2
发帖数: 85 | 1 The oracle database 10.2 report the following error message:
ORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH
hash-agg,kllcqas:kllsltba)
**********************
but all the parameters don't give any evidence to support the lack of memory
, anyone can help?
Environment:
Window OS 2003, Oracle 10.2, 24G total RAM, 20G sga, 15G pga aggregate.
sga:
lock_sga boolean FALSE
pre_page_sga boolean FALSE
sga_max_size big integer 19200M
sga_target big integer 19200M
pga:
pga_aggregate_target big integer 15G
v$pgastat:
aggregate PGA target parameter 1.6106E+10 bytes
aggregate PGA auto target 1.4444E+10 bytes
global memory bound 1073741824 bytes
total PGA inuse 57061376 bytes
total PGA allocated 100237312 bytes
maximum PGA allocated 354407424 bytes
total freeable PGA memory 12124160 bytes
process count 63
max processes count 102
PGA memory freed back to OS 2.3542E+10 bytes
total PGA used for auto workareas 0 bytes
maximum PGA used for auto workareas 135931904 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 0 bytes
over allocation count 0 bytes
processed 3.1176E+10 bytes
extra bytes read/written 0 bytes
cache hit percentage 100 percent
recompute count (total) 60227
19 rows selected. | a****2
发帖数: 85 | 2 i also attached the screenshot of the pga advice as a reference. | M*****r
发帖数: 1536 | 3 这个似乎是某个查询的某一步OOM了，你能找到那个query吗？
google, metalink, Oracle SR
QERGH
memory
【在 a****2 的大作中提到】
: The oracle database 10.2 report the following error message:
: ORA-04030: out of process memory when trying to allocate 254488 bytes (QERGH
: hash-agg,kllcqas:kllsltba)
: **********************
: but all the parameters don't give any evidence to support the lack of memory
: , anyone can help?
: Environment:
: Window OS 2003, Oracle 10.2, 24G total RAM, 20G sga, 15G pga aggregate.
: sga:
: lock_sga boolean FALSE
|
|
