My Oracle Support Banner

WebCenter Content - Search Performance Issue when Returning a Large Number of Search Results (Doc ID 1678812.1)

Last updated on SEPTEMBER 21, 2023

Applies to:

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

Symptoms

Search results are slow to display when returning a large number of results.  If a search returns more than 1000 results it takes more than 2 minutes.  It should take only a few seconds.

The Content Server 'schemacache' trace logging is showing a results set for every schema value, for every option list, for every search result.   There are thousands of schemacache entries in the trace logging for one search.

The logs show thousands of entries like this:

>schemacache/7    03.13 07:12:45.461    IdcServer-2197    getViewValues() using 'intradoc.shared.schema.SchemaCacheItem@q1234512354 on YesNoList(1.null) timestamp: 0, rows: null, size: 0'
>schemacache/7    03.13 07:12:45.461    IdcServer-2197    touching object intradoc.shared.schema.SchemaCacheItem@q1234512354 on YesNoList(1.1) timestamp: 1394692237474, rows: 2, size: 208 in container
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    *** LocalData ***
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    (19 keys + 0 defaults)
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    PublishViewData=1
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    blDateFormat=M/d/yy {h:mm[:ss] {aa}[zzz]}!mAM,PM!tAmerica/Chicago
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schDefaultDisplayExpression=<$if dOption$><$dOption$><$endif$>
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schDesignComponentSourceName=Design
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schDesignSourceVersion=8.0.2
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schInternalColumn=dValue
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schIsClientSorted=0
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schIsServerSorted=false
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schIsSystemObject=true
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schLabelColumn=dOption
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schLocalizationList=Display
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schLocalizeWhenDisplayed=1
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schRequiredFeatures=Design
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schTableName=YesNoList
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schVersion=1
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schViewColumns=dValue,dOption,dKey,idcComponentName
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schViewDescription=System view on SharedObjects table YesNoList
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schViewName=YesNoList
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    schViewType=SharedObjectsTable
 schemacache/7    03.13 07:12:45.461    IdcServer-2197   
 schemacache/7    03.13 07:12:45.461    IdcServer-2197   
 schemacache/7    03.13 07:12:45.461    IdcServer-2197    ***  RESULT SETS  ***

 

Changes

The configuration entry is present MaxResults=2000 in the config.cfg file.

11.1.1.7 MLR 4 OPatch was recently applied.

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


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