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


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

Test / Bes Practic

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>

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: