My Oracle Support Banner

Performance Issue When Altering S_WFA_INST_PROP Table During PostInstallDB After Applying 22.7 Update (Doc ID 2932310.1)

Last updated on APRIL 19, 2023

Applies to:

Siebel CRM - Version 22.7 and later
Information in this document applies to any platform.


While executing PostinstallDb utility against the database after generating the SQL files using Defer-Generate DDL Files only option from the installer there is observed a performance issue.

It was determined that the faulty SQL required 2 hours to execute in order to alter S_WFA_INST_PROP table from LONG_VAL to CLOB:


Executing all the other scripts from generate_schema.ddl excluding the above-mentioned SQL takes around 3-4 minutes to execute.

The issue can be reproduced at will with the following steps:
1. Stop all Siebel services.
2. Perform update installation to 22.7.
3. Generate generate_schema.ddl from the installer using Defer-Generate DDL Files only option.
4. Execute PostInstallDB utility.

Note that the navigation steps are mentioned in the bookshelf links above.


 Update installation from 20.2 to 22.7.


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.