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 laterInformation 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:
- Follow the steps 1-11 in Note:2086408.1 to rebuild FTS indexes
- Log into sqlpus as agile database user, and run below command to synchronize FTS indexes:
- 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 |