- Oracle 19.12 EMON large consumption of PGA memory
SQL-02100 Application team is approaching and reporting: “We do receive the following error on production!”: This is a clear indicating for running out of PGA memory. Well, this is suspicious! This is a lightweight application, using an AWS Oracle RDS instance with 24G SGA and 32G memory. Just a few sessions are connected and the
- Disconnect Oracle database sessions with srvctl & DBMS_SERVICE
Disconnect long lasting (application) client-based Oracle database sessions with srvctl & DBMS_SERVICE.
SQL-02100 Application team is approaching and reporting: “We do receive the following error on production!”: This is a clear indicating for running out of PGA memory. Well, this is suspicious! This is a lightweight application, using an AWS Oracle RDS instance with 24G SGA and 32G memory. Just a few sessions are connected and the
Disconnect long lasting (application) client-based Oracle database sessions with srvctl & DBMS_SERVICE.