ORA-4030 Error
I have a 11.1g DB running on a windows server. The DB is starting to report ORA-4030 errors.
There is talk in some of the previous post on setting various pga parameters.
I ran
select name, value from v&pgastat order by value desc
NAME VALUE
---------------------------------------------------------------- ----------
bytes processed 1492566016
aggregate PGA target parameter 440401920
aggregate PGA auto target 318145536
maximum PGA allocated 137574400
total PGA allocated 129427456
global memory bound 88080384
total PGA inuse 87333888
maximum PGA used for auto workareas 4632576
total PGA used for auto workareas 465920
recompute count (total) 1970
cache hit percentage 100
NAME VALUE
---------------------------------------------------------------- ----------
max processes count 66
process count 66
total PGA used for manual workareas 0
maximum PGA used for manual workareas 0
over allocation count 0
extra bytes read/written 0
total freeable PGA memory 0
PGA memory freed back to OS 0
Can you suggest what I need to do next to resolve and stop this error from occuring
Thanks
Brendan