Re: ORA-4030 out of process memory

Try cutting pga_aggregate_target in half. Have you checked the 9206 patch set to see if the pga issues it fixes apply to your environment? I've been convinced (without proof) it doesn't work as advertised, just blindly cutting it seems to fix problems (for my 9206 system, 400M works good). But see
http://www.jlcomp.demon.co.uk/faq/pat_presentation.html and http://www.jlcomp.demon.co.uk/untested.html for real information.

Do you have multiple instances? Shared servers? How much physical memory do you have? What are your init.ora parameters that affect the SGA, anyways? sort area size?

Some of the recommended unix kernel parameter settings have changed over time, have you checked them lately? If you are not running out of memory, then you may be running out of a memory resource that is dependent on the kernel parameters. I assume you've seen Note:233869.1 and Note:199746.1, but go over them again anyways. What's your unlockable_mem, too? (This can get screwy if you let the system manage it, especially if you've got a large SGA, or bogus shared memory segments. The system can't lock memory for a process, even though there appears to be plenty of memory available, so gives back a message to Oracle, which then 4031's).

jg

--
@home.com is bogus.
RAC really doesn't like being bored:
https://metalink.oracle.com/metalink/plsql/f?p=130:4:9806597813211123337::::p4_database_id,p4_docid,p4_show_header,p4_show_help,p4_black_frame,p4_font:BUG,4883174,1,1,1,helvetica