Performance Issues During Login In 8.1.1.11 Patchset 3 When Using Open UI - more than 300 queries to S_UI_FILE adding 30 seconds to the login time (Doc ID 1914293.1)

Last updated on JULY 02, 2017

Applies to:

Siebel CRM - Version 8.1.1.11 SIA [23030] and later
Information in this document applies to any platform.

Goal

There are more than 300 individual queries to S_UI_FILE during login with Open UI (on 8.1.1.11 Patchset 3)
delaying the login up to a minute (depending on how many repositories there are)

It also seems hugely inefficient to query on only one table and one row id at a time for the Open UI manifests. If we set a search spec on all the business components in the "Manifest Open UI" project to only search on one repository, we are able to improve the performance again.

(We have 24 custom entries in the application manifest administration.)

Solution

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