monline

I've just found some "ORA-04030: out of process memory when trying to allocate string bytes (string,string)" error messages in our alert file. A short search with Google pointed me to tweaking the PGA_AGGREGATE_TARGET instance parameter.

Others have already written down everything worth to say, so here are some articles that I've found most useful in this area:

1. Undocumented secrets for super-sizing your PGA
2. PGA_AGGREGATE_TARGET: workarea is limited to 200M by _pga_max_size
3. Forum discussion about "Sort Area Size"