Database Administration (MOSC)

MOSC Banner

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center