Friday, December 31, 2010

ORA-04030

ORA-04030 means machine hosting database instance has run out of memory because database instance is requesting memory for PGA.

In some cases allocated PGA can exceed PGA_AGGREGATE_TARGET parameter because untunable PGA may grow very large due to PL/SQL collections variables for example.

You can check maximum PGA allocated in GB with:

SQL> select name, value/(1024*1024*1024) GB from v$pgastat where name like '%max
%allocated%';

NAME                                                                     GB
---------------------------------------------------------------- ----------
maximum PGA allocated                                            ,080384254

Note: Thanks to Forstmann, the above was originally published at http://forums.oracle.com/forums/thread.jspa?threadID=1120120&tstart=15. I published above from my old notes but the reference was missing from there.

2 comments:

Pierre Forstmann said...

Thank you for publishing my OTN forum message on your blog.

http://forums.oracle.com/forums/thread.jspa?threadID=1120120&tstart=15

Unknown said...

Find latest jobs in Pakistan,teaching,finance,academic,online internet jobs.
Jobs from top companies and from top newspapers of Pakistan.
Visit www.toppakjobs.blogspot.com to apply for these jobs online.