Oracle Database - Enterprise Edition - Version 18.0.0.0 and later: SQL's waiting on PGA Memory Operation Wait Event after upgrade to 18c from 11g
Action: Correct the function code in the PL/SQL procedure, recompile it, and retry the operation. PGA-20933: invalid value specified by initialization parameter string=string Cause: The keyword parameter keyword=value specifies an invalid value. Action: Refer to the Oracle Database Gateway for...
https://fritshoogland.wordpress.com/2017/03/01/oracle-12-2-wait-event-pga-memory-operation/#comment-5838 https://fritshoogland.wordpress.com/2015/07/17/oracle-12-and-latches/ https://andreynikolaev.wordpress.com/
Execute the Oracle-supplied utility to compile invalid objects globally: Login as sys with SQLPLUS: Sqlplus “/as sysdba” SQL> @ORACLE_HOME/rdbms/admin/utlrp 转载于:https://blog.51cto.com/cwind/1010089 ###sample 3 ### sample 3 ORA-06512: /ORA-04036: PGA memory used by the instance e...
在 12.2.0.1 的10046事件跟踪文件中,"PGA memory operation"和"acknowledge over PGA limit"的等待事件要多得多;消耗在"acknowledge over PGA limit"的时间特别多。 此外,12.1.0.2 和 12.2.0.1 环境都有很多等待事件"direct path read"和"direct path read temp"。
Oracle Database Cloud Schema Service - Version N/A and later: SQL Statements Run Slower Waiting on "PGA memory operation" and "Acknowledge over PGA limit" After Migr