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