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

Last updated on APRIL 08, 2024

Applies to:

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

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