OERR: ORA 4030 "out of process memory when trying to allocate %s bytes (%s.%s)

Subject:	OERR: ORA 4030 "out of process memory when
	Doc ID:	Note:19836.1	Type:	REFERENCE
	Last Revision Date:	12-JUN-2004	Status:	PUBLISHED

Error:  ORA 4030

Text:   out of process memory when trying to allocate %s bytes (%s,%s)

-------------------------------------------------------------------------------

Cause:  Operating system process private memory has been exhausted

Action: See the database administrator or operating system administrator to

        increase process memory quota. There may be a bug in the application

        that causes excessive allocations of process memory space.

*** Important: The notes below are for experienced users - See Note 22080.1

Explanation:

        The Oracle shadow process cannot allocate memory. The error 

        should show the number of bytes being requested and area where

        they are required

Diagnosis:

        1) Check for a subsequent error, Eg: ORA 7324, to see where

           memory is being allocated.

        2) Check user memory limits and swap space. If these are too

           low you may get the above error. 

           Eg: 'limit' or 'ulimit -a' on Unix.

        3) It may help to reduce  if this is large.

        4) Check if using the Parallel Query Option - if an operation is

           being performed in parallel the memory requirements are greater.