UPDATE MYTAB SET COL1=REPLACE(COL1,'X','Y');

SQL> alter session set nls_date_Format='dd.mm.yyyy hh24:mi:ss';

Session altered.

SQL> col units for a12
SQL> col message for a25
SQL> set num 15
SQL> col start_time for a30
SQL> col DONE for a10
SQL> set lines 300 pages 400
SQL> --
SQL> select
  2  sid,
  3  message,
  4  sofar,
  5  totalwork,
  6  --substr((sofar/totalwork * 100),1,5)||'%' DONE,
  7   units,start_time,elapsed_seconds
  8  from gv$session_longops
  9  where sofar!=totalwork;

no rows selected

SQL>

SQL>
SQL> select v.TADDR,program,last_call_et,status from v$session v where sid = 1943;

TADDR            PROGRAM                                             LAST_CALL_ET STATUS
---------------- ------------------------------------------------ --------------- --------
                 PlSqlDev.exe                                                  18 INACTIVE

SQL>

select DBMS_SQLTUNE.REPORT_SQL_MONITOR (
         session_id=>&sid,
         report_level=>'ALL') as report 
from dual
/