环境:
OS:AIX Version 5.3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi错误日志内容:
Mon Dec 27 22:04:27 2010
Errors in file /oracle/admin//bdump/nwom2_j001_1519742.trc:
ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key)
Tue Dec 28 01:14:48 2010
Errors in file /oracle/admin//udump/nwom2_ora_1429886.trc:
ORA-00600: internal error code, arguments: [PITL1], [], [], [], [], [], [], []请问高手这两个错误时什么原因造成的?如何解决?
OS:AIX Version 5.3
Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bi错误日志内容:
Mon Dec 27 22:04:27 2010
Errors in file /oracle/admin//bdump/nwom2_j001_1519742.trc:
ORA-04030: out of process memory when trying to allocate 64544 bytes (sort subheap,sort key)
Tue Dec 28 01:14:48 2010
Errors in file /oracle/admin//udump/nwom2_ora_1429886.trc:
ORA-00600: internal error code, arguments: [PITL1], [], [], [], [], [], [], []请问高手这两个错误时什么原因造成的?如何解决?
$ ulimit -a
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) 2097151
nofiles(descriptors) 2000$ ulimit -Ha
time(seconds) unlimited
file(blocks) unlimited
data(kbytes) unlimited
stack(kbytes) 4194304
memory(kbytes) unlimited
coredump(blocks) unlimited
nofiles(descriptors) unlimitedSQL>select * from v$pgastat;
NAME VALUE UNIT
aggregate PGA target parameter 4294967296 bytes
aggregate PGA auto target 2069323776 bytes
global memory bound 104857600 bytes
total PGA inuse 2084654080 bytes
total PGA allocated 2343911424 bytes
maximum PGA allocated 9982167040 bytes
total freeable PGA memory 180551680 bytes
process count 98 (null)
max processes count 236 (null)
PGA memory freed back to OS 343751852032 bytes
total PGA used for auto workareas 89178112 bytes
maximum PGA used for auto workareas 1324768256 bytes
total PGA used for manual workareas 0 bytes
maximum PGA used for manual workareas 1075200 bytes
over allocation count 39 (null)
bytes processed 1796615078912 bytes
extra bytes read/written 1419165855744 bytes
cache hit percentage 55.86 percent
recompute count (total) 408391 (null)