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 NOVEMBER 01, 2021

Applies to:

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


Full Text Search synchronization (FTS sync) failed with below 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


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


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


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

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