PDBs allow for easier database consolidation, resource isolation, and quick cloning of databases. Cloning a PDB involves creating a copy of an existing PDB (the source) into another container database (the target). However, during this process, it can be helpful to monitor the progress to ensure everything goes smoothly. In this blog post, we’ll explore a useful SQL query that helps monitor the progress of the PDB cloning process.
SELECT SID, SERIAL#, CONTEXT, SOFAR, TOTALWORK, ROUND(SOFAR/TOTALWORK*100,2) "%_COMPLETE", OPNAME
FROM gv$SESSION_LONGOPS
WHERE OPNAME LIKE '%%kpdbfCopyTaskCbk%%' AND TOTALWORK != 0 AND SOFAR <> TOTALWORK
ORDER BY 6 DESC;
SID SERIAL# CONTEXT SOFAR TOTALWORK %_COMPLETE OPNAME TIME_REMAINING
826 40428 0 1293375 1405760 92.01 kpdbfCopyTaskCbk 232
810 637 0 1276351 1405760 90.79 kpdbfCopyTaskCbk 271
1985 13052 0 1270271 1405760 90.36 kpdbfCopyTaskCbk 285
30 62755 0 1225215 1405760 87.16 kpdbfCopyTaskCbk 394
21 64371 0 1203519 1405760 85.61 kpdbfCopyTaskCbk 449
1978 55794 0 1199679 1405760 85.34 kpdbfCopyTaskCbk 459
2747 31213 0 1170367 1405760 83.26 kpdbfCopyTaskCbk 538
DBADEEDS 
Leave a comment