track_autoupgrade_copy_progress.sql

This script will be useful for tracking progress of GBS copied to Target system. Need to execute it on Target system.

set lines 120 pages 200

prompt 'process started at 9:14AM on 3/18'
col sofar_gb format 9999999
col avg_gb_copy_per_min format 999999

SELECT name, value/(1024*1024*1024) sofar_GB,
       value/(1024*1024*1024) / ((sysdate - to_date('18-MAR-2026:09:14','DD-MON-RRRR:HH24:MI'))*(24*60)) avg_gb_copy_per_min
FROM v$sysstat
WHERE name IN ('physical write total bytes', 'physical write bytes');