My Oracle Support Banner

Performance Issues During Login In 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 AUGUST 17, 2022

Applies to:

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


There are more than 300 individual queries to S_UI_FILE during login with Open UI (on 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.)


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.