SQL> create table t
  2  as
  3  select rownum c
  4    from xmltable('1 to 500000');

Table created.

SQL>
SQL> update /*+ monitor*/t
  2     set c = c + 1;

500000 rows updated.

SQL>
SQL> select dbms_sqltune.report_sql_monitor('f9dx3wufpykrz')
  2    from dual;

DBMS_SQLTUNE.REPORT_SQL_MONITOR('F9DX3WUFPYKRZ')
--------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL Monitoring Report

SQL Text
------------------------------
update /*+ monitor*/t set c = c + 1

Global Information
------------------------------
 Status              :  DONE
 Instance ID         :  1
 Session             :  TC (84:53047)
 SQL ID              :  f9dx3wufpykrz
 SQL Execution ID    :  16777231
 Execution Started   :  08/23/2019 18:04:26
 First Refresh Time  :  08/23/2019 18:04:26
 Last Refresh Time   :  08/23/2019 18:05:18
 Duration            :  52s
 Module/Action       :  SQL*Plus/-
 Service             :  pdb
 Program             :  sqlplus@db-19-siha (TNS V1-V3)

Global Stats

===================================================================
| Elapsed |   Cpu   |    IO    |  Other   | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) | Waits(s) |  Gets  | Reqs | Bytes |
===================================================================
|      52 |    8.59 |     1.81 |       41 |     1M |   22 |   6MB |
===================================================================

SQL Plan Monitoring Details (Plan Hash Value=931696821)
==============================================================================================================================================================
| Id |      Operation       | Name |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Read | Read  | Activity |           Activity Detail            |
|    |                      |      | (Estim) |      | Active(s) | Active |       | (Actual) | Reqs | Bytes |   (%)    |             (# samples)              |

==============================================================================================================================================================
|  0 | UPDATE STATEMENT     |      |         |      |        51 |     +2 |     3 |        0 |      |       |    38.46 | enq: CR - block range reuse ckpt (9) |
|    |                      |      |         |      |           |        |       |          |      |       |          | reliable message (11)                |
|  1 |   UPDATE             | T    |         |      |        53 |     +0 |     3 |        0 |      |       |    57.69 | log buffer space (16)                |
|    |                      |      |         |      |           |        |       |          |      |       |          | log file switch completion (1)       |
|    |                      |      |         |      |           |        |       |          |      |       |          | Cpu (13)                             |
|  2 |    TABLE ACCESS FULL | T    |    500K |  217 |        51 |     +2 |     3 |       1M |   22 |   6MB |     3.85 | db file scattered read (2)           |
==============================================================================================================================================================

PARSING IN CURSOR #140490733870984 len=38 dep=0 uid=78 oct=6 lid=78 tim=965570210 hv=2640268031 ad='65b8eff0' sqlid='f9dx3wufpykrz'
update /*+ monitor*/t
   set c = c + 1
END OF STMT
-- skipped
EXEC #140490733870984:c=8588759,e=51711780,p=762,cr=7294,cu=1065328,mis=0,r=500000,dep=0,og=1,plh=931696821,tim=1017282021
STAT #140490733870984 id=1 cnt=0 pid=0 pos=1 obj=0 op='UPDATE  T (cr=7279 pr=749 pw=0 str=3 time=51655200 us)'
STAT #140490733870984 id=2 cnt=1007798 pid=1 pos=1 obj=24825 op='TABLE ACCESS FULL T (cr=1546 pr=762 pw=0 str=3 time=197360 us cost=217 size=2500000 card=500000)'