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.