BCC adds unnecessary "FAKEDISPLAYNAME%" displayName filter that can cause performance issues
(Doc ID 2418160.1)
Last updated on FEBRUARY 05, 2019
Applies to:Oracle Commerce Platform - Version 11.1 and later
Information in this document applies to any platform.
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.
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