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: 18.104.22.168 to 22.214.171.124 - Release: 9.2 to 9.2
Information in this document applies to any platform.
You can hit this error under following scenarios:
Case - I
sort_area_size > 1GB
Case - II
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