On 11.2.0.4 CTX_DOC.POLICY_FILTER Consumes All CPU for Certain Documents (Doc ID 1683082.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Text - Version 11.2.0.4 to 11.2.0.4 [Release 11.2]
Information in this document applies to any platform.

Symptoms

The ctx_doc.policy_filter consumes all CPU for certain documents.
This does not happen to all calls to ctx_doc.policy_filter or document indexing.

Problem is easily reproducible using below testcase on IBM AIX (64 bit) platform -

SQL> declare
  2
  3     l_clob clob;
  4     l_flag boolean := TRUE;
  5     v_language varchar2(4);
  6     v_charset varchar2(30);
  7     v_filedata blob;
  8
  9     begin
 10
 11     select file_data, language,oracle_charset into v_filedata,
v_language, v_charset
 12      from FND_LOBS_TEST where file_id = 4017053;
 13      ctx_doc.policy_filter( 'endeca_policy', v_filedata, l_clob,
l_flag,v_language,null,v_charset);
 14
 15  end;
 16  /

Same testcase runs fine on Linux x86-64 (no Hang or CPU spin is seen).  
The hanging behaviour is only seen on AIX (64-bit).

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms