My Oracle Support Banner

Database Upgrade to 19c slow when adding constraints to WRH$ tables (Doc ID 2807855.1)

Last updated on JULY 20, 2024

Applies to:

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

Symptoms

Database Upgrade to 19c  slow when adding constraints to WRH$ tables.

catupgrd0.log  shows:

The below command takes lot of time.

04:06:46 SQL> alter table WRH$_ACTIVE_SESSION_HISTORY
04:06:46 2 add constraint WRH$_ACTIVE_SESSION_HISTORY_PK primary key
04:06:46 3 (dbid, snap_id, instance_number, sample_id, session_id, con_dbid)
04:06:46 4 using index WRH$_ACTIVE_SESSION_HISTORY_PK
04:06:46 5 /

Table altered.

Elapsed: 00:28:51.96

 

 ..

04:38:46 SQL> alter table WRH$_FILESTATXS
04:38:46 2 add constraint WRH$_FILESTATXS_PK primary key
04:38:46 3 (dbid, snap_id, instance_number, file#, con_dbid)
04:38:46 4 using index WRH$_FILESTATXS_PK
04:38:46 5 /

Table altered.

Elapsed: 00:59:03.42

 

 and so on for various add constraint on WRH$ tables.

 

 

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.