My Oracle Support Banner

DB Upgrade from 11.2.0.4 to 19.xx is slow while adding Columns with Default Values to AWR Tables(WRH$_SEG_STAT,WRH$_SQLSTAT,WRH$_SGASTAT) (Doc ID 3034902.1)

Last updated on JULY 16, 2024

Applies to:

Oracle Database - Enterprise Edition - Version 19.10.0.0.0 and later
Information in this document applies to any platform.

Symptoms

 DB Upgrade from 11.2.0.4 to 19xx(19.10 & higher) is slow when adding Columns with Default Values to AWR Tables(WRH$_SEG_STAT,WRH$_SQLSTAT,WRH$_SGASTAT) -

1. c1201000.sql (1 operation)

SQL> alter table wrh$_sgastat add (stattype number default 0);                                         
Elapsed: 00:04:58.01

2. c1202000.sql (2 operations)

01:36:57 SQL> alter table WRH$_SQLSTAT add (obsolete_count number default 0);                             
Table altered.
Elapsed: 00:02:23.27

01:39:20 SQL> alter table WRH$_SEG_STAT add (
01:39:20 2 gc_remote_grants_total number
01:39:20 3 ,gc_remote_grants_delta number
01:39:20 4 ,im_scans_total number default 0
01:39:20 5 ,im_scans_delta number default 0
01:39:20 6 ,populate_cus_total number default 0
01:39:20 7 ,populate_cus_delta number default 0
01:39:20 8 ,repopulate_cus_total number default 0
01:39:20 9 ,repopulate_cus_delta number default 0
01:39:20 10 ,im_db_block_changes_total number default 0
01:39:20 11 ,im_db_block_changes_delta number default 0
01:39:20 12 );
Table altered.
Elapsed: 00:04:29.33

3. c18.sql (1 operation)

01:44:27 SQL> alter table WRH$_SEG_STAT add (im_membytes number default 0);
Table altered.
Elapsed: 00:03:10.72

 

 

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