Large Number of SQL Statements on the S_ACC_VIEW_APP Table
Last updated on MARCH 02, 2017
Applies to:Siebel Tools - Version 126.96.36.199 [IP2013] and later
Information in this document applies to any platform.
We observed this change during testing for the 188.8.131.52 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 184.108.40.206 to 220.127.116.11 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 18.104.22.168?
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 22.214.171.124 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 126.96.36.199 dedicated web client to a 188.8.131.52 dedicated web client. The 184.108.40.206 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 220.127.116.11 to 18.104.22.168.
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