Home > TroubleShooting > ORA-04030: out of process memory when trying to allocate

ORA-04030: out of process memory when trying to allocate

December 22, 2009 Leave a comment Go to comments

Symptoms

SQL> startup
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                  2031352 bytes
Variable Size             205521160 bytes
Database Buffers          310378496 bytes
Redo Buffers                6356992 bytes
Database mounted.
ORA-04030: out of process memory when trying to allocate 35692296 bytes (pga
heap,KCL disk IO request block array)

Causes

There is not memory enough on system to allocate

Fixed

Tuned down sga_target size to 250M as the following

SQL> startup mount
ORACLE instance started.

Total System Global Area  524288000 bytes
Fixed Size                  2031352 bytes
Variable Size             213909768 bytes
Database Buffers          301989888 bytes
Redo Buffers                6356992 bytes
Database mounted.

SQL> show parameter target

NAME                                 TYPE        VALUE
———————————— ———– ——————————
archive_lag_target                   integer     0
db_flashback_retention_target        integer     1440
fast_start_io_target                 integer     0
fast_start_mttr_target               integer     0
pga_aggregate_target                 big integer 200M
sga_target                           big integer 500M
SQL> alter system set sga_target=250M scope=spfile;

System altered.

SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.

Total System Global Area  264241152 bytes
Fixed Size                  2029360 bytes
Variable Size              96471248 bytes
Database Buffers          159383552 bytes
Redo Buffers                6356992 bytes
Database mounted.
Database opened.
SQL>

Advertisements
Categories: TroubleShooting
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: