Friday, December 31, 2010


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

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

Note: Thanks to Forstmann, the above was originally published at I published above from my old notes but the reference was missing from there.


Pierre Forstmann said...

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

Unknown said...

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