Performance Issue Observed When Data Is Inserted Into S_VALDN_INST
Last updated on SEPTEMBER 22, 2017
Applies to:Siebel CRM - Version 184.108.40.206  and later
Information in this document applies to any platform.
When a data validation is triggered data is inserted into S_VALDN_INST.
During the insertion we see spike sin the database which is causing application slowness and thus causing performance issues to the user/Agent.
Only have History logging for events where Status = Error. It seems that S_VALDN_INST table gets blown up with millions of records with Status = 'Completed'.
Not willing to have Logging disabled as they still need to check for the Error events.
Currently, The validation history can be reviewed via Site Map > Administration Data Validation > Validation History.
This shows the result of each rule evaluated. If the history is not required, then the Enable Log parameter in the business service context can
be set to N. However, the Validation History shows the results of all rules evaluated whether they return errors or not
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