ALTER TABLE MOVE ONLINE Slow After Installing DB RU 19.19 With Wait Event "Online DDL delay"
(Doc ID 2961835.1)
Last updated on JULY 20, 2024
Applies to:
Oracle Database - Enterprise Edition - Version 19.3.0.0.0 and laterInformation in this document applies to any platform.
Symptoms
ALTER TABLE .. MOVE performing slow after upgrading from 19.17 to DB RU 19.19.
In event 10046 trace, we see that in 19.19, the extra time is being spent on wait event "online DDL delay" and this wait event isn't seen in 19.17.
We see in 19.19:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 3 0.00 0.00
direct path write 2 0.00 0.00
online DDL delay 3 1.99 5.99 <<<<<<<<<<<<<<<<<<<<
reliable message 10 0.00 0.00
enq: RO - fast object reuse 5 0.00 0.01
db file sequential read 5 0.00 0.00
enq: CR - block range reuse ckpt 5 0.00 0.01
log file sync 1 0.00 0.00
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
*****************************************************
Versus 19.17:
Event waited on Times Max. Wait Total Waited
---------------------------------------- Waited ---------- ------------
PGA memory operation 3 0.00 0.00
direct path write 2 0.00 0.00
reliable message 10 0.00 0.00
enq: RO - fast object reuse 5 0.00 0.00
db file sequential read 5 0.00 0.00
enq: CR - block range reuse ckpt 5 0.00 0.00
log file sync 1 0.00 0.00
SQL*Net message to client 1 0.00 0.00
SQL*Net message from client 1 0.00 0.00
******************************************************
Changes
Upgrade from 19.17 to 19.19
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 |
| Changes |
| Cause |
| Solution |
| References |