how to see progress of create pluggable database mytest12 from NON$CDB@clone_link when using ASM
I am running oracle 19c an cloning from a non cdb to a pluggable database using below command. I wish to see the progress of the process as it has been running since 6 hours ago.
create pluggable database mytest12 from NON$CDB@clone_link
All I see are some trace files showing some hanging happened at some point.
*** 2023-08-02T13:22:56.086895+00:00 (CDB$ROOT(1))
HM: Session with ID 494 serial # 39254 (FG) on single instance 1 is hung
and is waiting on 'PX Deq: Execute Reply' for 96 seconds.
Session was previously waiting on 'PX Deq: Execute Reply'.
Final Blocker is Session ID 496 serial# 30664 on instance 1