My Oracle Support Banner

ORA-4030 as a result of 1GB limit of memory per process (Doc ID 272786.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Oracle Server - Enterprise Edition - Version: to - Release: 9.2 to 9.2
Information in this document applies to any platform.


Running query which requires a large sort area memory. The PGA grows until the 1GB sort_area_size is used and then errors out with ORA-04030, although the instance has much more than 1GB TEMP space available that is never touched.

You can hit this error under following scenarios:

Case - I

Set workarea_size_policy=manual
sort_area_size > 1GB

Case - II

Set workarea_size_policy=auto
pga_aggregate_target is set to a large value, so that a single process uses more than 1 GB of process memory.


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.