Switching to Audit Trail takes very long time (Doc ID 730667.1)

Last updated on MARCH 02, 2017

Applies to:

Siebel Tools - Version 8.0.0.2 [20412] and later
Information in this document applies to any platform.
***Checked for relevance on 03-Sep-2010***

***Checked for relevance on 30-Jun-2015***

Symptoms

After upgrading from 7.x to 8.0, switching to an Audit Trail view takes over three minutes in a production environment. Table S_AUDIT_ITEM contains 1,630,000 records. In a test environment, the table contains only 203,000 records, and switching to the Audit Trail view is considerably faster.

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