Performance Issues During Login In 220.127.116.11 Patchset 3 When Using Open UI - more than 300 queries to S_UI_FILE adding 30 seconds to the login time
Last updated on APRIL 30, 2018
Applies to:Siebel CRM - Version 18.104.22.168 SIA  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 22.214.171.124 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.)
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms