Large Number of SQL Statements on the S_ACC_VIEW_APP Table
(Doc ID 1677126.1)
Last updated on NOVEMBER 22, 2019
Applies to:Siebel Tools - Version 220.127.116.11 [IP2013] and later
Information in this document applies to any platform.
We observed this change during testing for the 18.104.22.168 SIA upgrade. The number of SQL statements executed on the database increased significantly when users are logging in to the Siebel application.
We upgraded from 22.214.171.124 to 126.96.36.199 and we have not added any new customizations, just the upgrade repository changes.
Specifically, when the users are logging on to the Siebel application, there is a lot more increase in the database load compared to the database load that we saw with 188.8.131.52?
Why is this happening?
All of the new sql in the Object Manager log files are Select statements on the S_ACC_VIEW_APP table.
The increase in SQL Select Statements on S_ACC_VIEW_APP table can be seen with a Siebel 184.108.40.206 SIA dedicated web client test with the standard "out of the box" siebel_sia.srf file.
Enable client side logging with the Siebel_Log_Events environment variable set to 4. Login to the Siebel HI client using uagent.cfg and Log off.
Compare the c:\Siebel\Client_1\siebel.log file generated with a 220.127.116.11 dedicated web client to a 18.104.22.168 dedicated web client. The 22.214.171.124 siebel.log file is much larger due to the approximately 1300 new select queries on S_ACC_VIEW_APP.
The S_ACC_VIEW_APP SQL (1300 SQLs) alway happens in the dedicated web client. The Accessibility related SQL also happens in the thin client environment, but only for the first session that each Object Manager process (PID) handles. The S_ACC_VIEW_APP table is related to Accessibiltiy, but we have not enabled Siebel Accessibility? Our HI Object Managers and the uagent.cfg both have the parameter 'AccessibleEnhanced' set to False. This SQL also happens when a user uses the Site Map for the first time in a session.
Why do we still see this sql?
The change is the Siebel version from 126.96.36.199 to 188.8.131.52.
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