My Oracle Support Banner

BCC adds unnecessary "FAKEDISPLAYNAME%" displayName filter that can cause performance issues (Doc ID 2418160.1)

Last updated on JULY 02, 2018

Applies to:

Oracle Commerce Platform - Version 11.1 and later
Information in this document applies to any platform.

Symptoms

While trying to browse assets in the BCC a performance issue may be encountered. When reviewing the logs after enabling debug on the product catalog the following query may appear surrounding timeout and/or session killed errors. You may also see errors like "ORA-00028: your session has been killed" but each environment may have different symptoms with regards to the error, but the debugging should show the query below as the culprit regardless of the database being used.


 

Changes

 N/A

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!


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