My Oracle Support Banner

DBMS_STATS.GATHER_TABLE_STATS Execution In Upg_data_afterseed.sql For S_EVT_ACT Table Takes Very Long Time To Complete (Doc ID 2466219.1)

Last updated on AUGUST 07, 2023

Applies to:

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


While running upgrep_prod the following step is taking approximately 20 hours to complete.

* v8_1_1_14\upg_data_afterseed.sql *

RUN_SQL_30 =
{call DBMS_STATS.GATHER_TABLE_STATS('&Arg1', 'S_EVT_ACT' , cascade=>true)}

Net Cost for SQL 30:   19h:37m:53s

Can this step be removed?


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.