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 OCTOBER 29, 2018

Applies to:

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

Goal

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?

Solution

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
Goal
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.