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:

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

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