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/
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 exceeds PGA_AGGREGATE_LIMIT Processing object type SCHEMA_EXPORT/TABLE/STATISTICS/TABLE_STATISTICS UDI-00028: operation generated ...
oracle同样捉供了可以将PGA转睹到囤踪文件的方法.方法如下: SQL/ alter session set event三 * inmediate trace name heapduap level n' ? 其中的level "决定了和那些内存堆转储到跟踪文件: Level 1: PGA汇总佶息 Level 2: SGA『总(S息 Level 4: CGA汇总佶息 Level 8:半前调用的汇总佶息(CGA) Level...
在 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