ORA-00604: error occurred at recursive SQL level 1 ORA-04030: out of process memory when trying to allocate

During import from production to test environment was getting failed using imp utility and error was

ORA-00604: error occurred at recursive SQL level 1
ORA-04030: out of process memory when trying to allocate

Solution:

              Increased the sga_target value from 2.5G to 3G and retried it worked fine.


Note:
            sga_target can be extended upto the max size of sga_max_size, so first increase value of sga_max_size,if not has enough size, then increase sga_target


Steps:

            alter system set sga_max_size=3096M scope=spfile; 

            shutdown immediate;

            startup;

            alter system set sga_target=3096m scope=memory;