My Oracle Support Banner

Siebel 21.4 Update PostInstallDBSetup Utility Is Modifying DESC Sort Indexes to ASC (Doc ID 2789946.1)

Last updated on SEPTEMBER 13, 2021

Applies to:

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

Symptoms


The Siebel 21.4 PostInstallDBSetup utility was executed and it took 6 hours to run in the Performance Testing environment.
It was noticed that many indexes were modified by verifying the import_cus_schema.log file.
The indexes modified in this log were all indexes that have  DESC sort order columns and these indexes modification took around 5 hours to execute.

It seems that PostInstallDBSetup is modifying the indexes from DESC to ASC sort, because the ddlimp utility does not have the /9 Y switch parameter.




STEPS
-----------------------
The issue can be reproduced as following:

1. Run Siebel Postinstalldbsetup manually (Instructions to run postinstalldbsetup can be found in

Siebel Database Upgrade Guide> Chapter 10 Upgrading the Siebel Database> Rerunning Post Installation Database Update);

Check each setup.ini parameter meaning in Siebel Database Upgrade Guide > Chapter 10 Upgrading the Siebel Database > Post Installation Database Update);


2. Check Siebel-root\siebsrvr\log\PostInstallDBSetup_<date-time>\SeedSchemaManifest_<date-time>\Common\import_cus_schema.log file. These indexes contain columns in DESC order and were recreated in ascending order, which may affect performance. (This log snippet shows an execution in a standard environment. The S_EVT_ACT table did not contain many records.)

 

2021-08-24 13:50:38          Merging   table                         S_EVT_ACT ... 

2021-08-24 13:50:39            Modifying index                   S_EVT_ACT_F10 ... 1.296s

2021-08-24 13:50:39            Creating  index                   S_EVT_ACT_F88 ... 0.172s

2021-08-24 13:50:40            Modifying index                   S_EVT_ACT_M10 ... 0.782s

2021-08-24 13:50:40            Modifying index                   S_EVT_ACT_M11 ... 0.562s

2021-08-24 13:50:41            Modifying index                    S_EVT_ACT_M2 ... 0.828s

2021-08-24 13:50:42            Modifying index                    S_EVT_ACT_M3 ... 0.672s

2021-08-24 13:50:42            Modifying index                   S_EVT_ACT_M56 ... 0.297s

2021-08-24 13:50:43            Creating  index                   S_EVT_ACT_M57 ... 0.547s

2021-08-24 13:50:44            Modifying index                    S_EVT_ACT_M6 ... 1.187s

2021-08-24 13:50:44            Modifying index                    S_EVT_ACT_M8 ... 0.375s

 

 

Changes

 Siebel SES update 21.4 (or above) binaries installation.

Cause

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
Symptoms
Changes
Cause
Solution
References


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