The following ABAP dump happens during an SQL query:
Category Installation error
Runtime Errors DBSQL_SQL_ERROR
Date and Time 23.07.2021 13:50:10
SQL error "SQL code: 4036" occurred while accessing table "SOPR".
Database error text: "SQL message: ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT"
The Oracle alert log shows also:
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
and sometimes heavy swapping is logged in the alert log too:
WARNING: Heavy swapping observed on system in last 5 mins.
Heavy swapping can lead to timeouts, poor performance, and instance eviction.
- SAP Netweaver 7.0 or higher
- Oracle Database Server 11g or higher
KBA , BC-DB-ORA , Oracle , Problem
About this pageThis is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.