My Oracle Support Banner

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

Last updated on OCTOBER 31, 2019

Applies to:

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


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
  3     l_clob clob;
  4     l_flag boolean := TRUE;
  5     v_language varchar2(4);
  6     v_charset varchar2(30);
  7     v_filedata blob;
  9     begin
 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,
 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).


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.