My Oracle Support Banner

FTS Sync Failed with ORA-04036: PGA Memory Used By The Instance Exceeds PGA_AGGREGATE_LIMIT (Doc ID 2817741.1)

Last updated on JANUARY 24, 2024

Applies to:

Oracle Agile PLM Framework - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

Full Text Search synchronization (FTS sync) failed with below error:


Error

ERROR at line 1:
ORA-00028: your session has been killed
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT
ORA-06512: at "CTXSYS.DRVDISP", line 5
ORA-06512: at "CTXSYS.DRVDISP", line 315
ORA-06512: at "CTXSYS.DRVDML", line 457
ORA-06512: at "CTXSYS.DRVDDL", line 6095
ORA-06512: at "CTXSYS.DRVLSB", line 2207
ORA-06512: at "CTXSYS.CTX_DDL", line 1217
ORA-06512: at line 1


Steps

The issue can be reproduced at will with the following steps:

  1. Follow the steps 1-11 in Note:2086408.1 to rebuild FTS indexes
  2. Log into sqlpus as agile database user, and run below command to synchronize FTS indexes:
  3. After running till for a while, it failed with above errors in the console


Changes

Rebuilding Full Text Search Index was performed for large amount of files in the system

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.