Friday , March 29 2024

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

We can receive this error in the case of many sorting or join operations in 12c databases.

The reason for the error is the memory limit that is set with the “pga_aggregate_limit” parameter that is new parameter in the 12c. By default, the value of this parameter is 2 times the PGA_AGGREGATE_TARGET parameter or 3 times the value of the PROCESSES parameter.

We can solve the error by setting the value of the parameter PGA_AGGREGATE_LIMIT to 0 (zero).

Loading

About dbtut

We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.

Leave a Reply

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

Categories