My Oracle Support Banner

OracleTextSearch PGA Size Grows Uncontrollably When Using Custom AUTO_LEXER Configuration (Doc ID 1297910.1)

Last updated on SEPTEMBER 23, 2021

Applies to:

Oracle WebCenter Content - Version 10.0 and later
Information in this document applies to any platform.

Symptoms

When performing a (quick) search on a UCM instance that is configured using OracleTextSearch with the AUTO_LEXER on an Oracle RDBMS 11.2.0.1, the Oracle database process memory increases to several hundreds of megabytes and does not decrease. Subsequent searches will continue to allocate more memory on the database host until all available memory is consumed.

On windows, you may notice that the oracle.exe grows to consume all available memory and grow to several gigabytes.

After running the search, the following SQL statement shows that the "total PGA inuse" and "total PGA allocated" increases significantly, while only a limited amount of PGA memory is marked "freeable":


NOTE: If you are not using the AUTO_LEXER (or are on the 11.2.0.2 patch set and still observe excessive memory allocation) then please take a look at the issue described in <Document 1065852.1> "OracleTextSearch Database's PGA Size Grows Uncontrollably".

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
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.