Large Number of SQL Statements on the S_ACC_VIEW_APP Table
(Doc ID 1677126.1)
Last updated on AUGUST 02, 2018
Applies to:Siebel Tools - Version 22.214.171.124 [IP2013] and later
Information in this document applies to any platform.
We observed this change during testing for the 126.96.36.199 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 188.8.131.52 to 184.108.40.206 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 220.127.116.11?
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 18.104.22.168 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 22.214.171.124 dedicated web client to a 126.96.36.199 dedicated web client. The 188.8.131.52 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 184.108.40.206 to 220.127.116.11.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!