Thursday , June 13 2024

ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT

In today’s article, we will cover the ORA-04036: error that comes at the end of the upgrade while performing an upgrade on the database.

After examining it, I noticed that I got the following error.

The problem is roughly as follows, PGA space is a space used for existing sessions and on 11G this space can grow independently depending on capacity.

In 12C and later, ” pga_aggregate_limit ” parameter was introduced. Since this parameter limits us, it leads to error.

In fact, the first thing to do is to find the answer to the question of why the kill process consumes so much resources.

If we look at the quick solutions,

For example, you can set the “pga_aggregate_limit” limit to 0.

Or you can increase the limit.


About Buğra PARLAYAN

Burgra Parlayan is an experienced Database and Weblogic Administrator. After completing his technical / relevant training he has got involved with a serious amount of projects. He successfully managed database upgrade, database migration, database performance tuning projects for various public institutions.Currently he has been employed by one of the leading financial institutions called Turkiye Hayat & Emeklilik as responsible administrator for Oracle Database and Oracle Middleware. He has been sharing his experience and knowledge by face to face training, personal blog and various social networking accounts to support the Oracle ecosystem continuously since 2010.

Leave a Reply

Your email address will not be published. Required fields are marked *