ORA-4030 as a result of 1GB limit of memory per process
Last updated on NOVEMBER 28, 2016
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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms