Online Table Move Causing Deadlock (ORA-00060)
(Doc ID 2781891.1)
Last updated on FEBRUARY 04, 2025
Applies to:
Oracle Database - Enterprise Edition - Version 12.2.0.1 and laterOracle Database Cloud Exadata Service - Version N/A and later
Oracle Cloud Infrastructure - Exadata Cloud Service - Version N/A and later
Gen 1 Exadata Cloud at Customer (Oracle Exadata Database Cloud Machine) - Version N/A and later
Gen 2 Exadata Cloud at Customer - Version N/A and later
Information in this document applies to any platform.
Symptoms
An alter table online move command generates an ora-60 in the database alert.log even though the command completes successfully.
The trace file shows that both the blocker and waiter are the same session.
Deadlock graph:
- -----------Blocker(s)----------- ------------Waiter(s)------------
Resource Name process session holds waits serial process session holds waits serial
TM-0003CF1D-00000000-00000000-00000000 8 1 SX 1234 8 1 S 1234
*** 2020-09-22T11:02:08.545219-06:00
dbkedDefDump(): Starting a non-incident diagnostic dump (flags=0x0, level=1, mask=0x0)
----- Error Stack Dump -----
----- Current SQL Statement for this session (sql_id=a9dgsn30kq130) -----
alter table USER.EMP move online tablespace BIGTBS01 update indexes
ksedst dbkedDefDump ksedmp ksqdld_hdr_dump 097
ksqcmi ksqgtlctx ktaiam ktagetp_internal 1970
ktagetg_internal ktagetg_ddlX ktagetg_ddl knl_PrepTabInst 868
knld_ProcessCreateT able knldcddl2 able ctccdo_change_dobj_
onlmt ctcdrv onlmt opiexe opiosq0
kpooprx kpoal8 opiodr ttcpip opitsk
opiino opiodr opidrv sou2o opimai_real
ssthrdmain main libc_start_main start
Changes
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 |