Large Number of SQL Statements on the S_ACC_VIEW_APP Table (Doc ID 1677126.1)

Last updated on MARCH 02, 2017

Applies to:

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

Symptoms

We observed this change during testing for the 8.1.1.10 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 8.1.1.7 to 8.1.1.10 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 8.1.1.7?

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 8.1.1.10 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 8.1.1.7 dedicated web client to a 8.1.1.10 dedicated web client.  The 8.1.1.10 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?  

Changes

The change is the Siebel version from 8.1.1.17 to 8.1.1.10.  

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms