SQL> select /*+ monitor gather_plan_statistics*/xmltype.createxml(cursor(select * from big where id=100500)) from dual;

XMLTYPE.CREATEXML(CURSOR(SELECT*FROMBIGWHEREID=100500))
----------------------------------------------------------------------------------------------------------
<?xml version="1.0"?>
<ROWSET>
  <ROW>
    <ID>100500</ID>
    <PAD>x
   </PAD>
    <VAL>0</VAL>
  </ROW>
</ROWSET>


Elapsed: 00:00:07.05

PARSING IN CURSOR #139767668692080 len=113 dep=0 uid=138 oct=3 lid=138 tim=3101973252663 hv=4265235640 ad='c7b942e8' sqlid='4d4fh0zz3np5s'
select /*+ monitor gather_plan_statistics*/xmltype.createxml(cursor(select * from big where id=100500)) from dual
...
PARSING IN CURSOR #139767665048600 len=99 dep=2 uid=138 oct=3 lid=138 tim=3101973457486 hv=2683116143 ad='bce225a0' sqlid='5c38sa2gyu6mg'
SELECT "BIG"."ID" "ID","BIG"."PAD" "PAD","BIG"."VAL" "VAL" FROM "BIG" "BIG" WHERE "BIG"."ID"=100500
END OF STMT
...
STAT #139767665048600 id=1 cnt=1 pid=0 pos=1 obj=137739 op='TABLE ACCESS FULL BIG (cr=158534 pr=156897 pw=0 str=1 time=105485 us cost=43205 size=109 card=1)'
...
STAT #139767668692080 id=1 cnt=0 pid=0 pos=1 obj=137739 op='TABLE ACCESS BY INDEX ROWID BATCHED BIG (cr=0 pr=0 pw=0 str=0 time=0 us cost=4 size=109 card=1)'
STAT #139767668692080 id=2 cnt=0 pid=1 pos=1 obj=137741 op='INDEX RANGE SCAN BIG_ID_I (cr=0 pr=0 pw=0 str=0 time=0 us cost=3 size=0 card=1)'
STAT #139767668692080 id=3 cnt=1 pid=0 pos=2 obj=0 op='FAST DUAL  (cr=0 pr=0 pw=0 str=1 time=2 us cost=2 size=0 card=1)'

SQL> select * from table(dbms_xplan.display_cursor('4d4fh0zz3np5s', null, 'allstats last'));

PLAN_TABLE_OUTPUT
-------------------------------------------------------------------------------------------------
SQL_ID  4d4fh0zz3np5s, child number 0
-------------------------------------
select /*+ monitor gather_plan_statistics*/xmltype.createxml(cursor(sele
ct * from big where id=100500)) from dual

Plan hash value: 3016543793

------------------------------------------------------------------------------------------------
| Id  | Operation                           | Name     | Starts | E-Rows | A-Rows |   A-Time   |
------------------------------------------------------------------------------------------------
|   0 | SELECT STATEMENT                    |          |      1 |        |      1 |00:00:00.01 |
|   1 |  TABLE ACCESS BY INDEX ROWID BATCHED| BIG      |      0 |      1 |      0 |00:00:00.01 |
|*  2 |   INDEX RANGE SCAN                  | BIG_ID_I |      0 |      1 |      0 |00:00:00.01 |
|   3 |  FAST DUAL                          |          |      1 |      1 |      1 |00:00:00.01 |
------------------------------------------------------------------------------------------------

Predicate Information (identified by operation id):
---------------------------------------------------

   2 - access("ID"=100500)


21 rows selected.

select dbms_sqltune.report_sql_monitor('4d4fh0zz3np5s') from dual;

DBMS_SQLTUNE.REPORT_SQL_MONITOR('4D4FH0ZZ3NP5S')
---------------------------------------------------------------------------------------------------------------
SQL Monitoring Report

SQL Text
------------------------------
select /*+ monitor gather_plan_statistics*/xmltype.createxml(cursor(select * from big where id=100500)) from dual

Global Information
------------------------------
 Status              :  DONE (ALL ROWS)
 Instance ID         :  1
 Session             :  TC (21:11922)
 SQL ID              :  4d4fh0zz3np5s
 SQL Execution ID    :  16777216
 Execution Started   :  08/06/2019 09:14:35
 First Refresh Time  :  08/06/2019 09:14:35
 Last Refresh Time   :  08/06/2019 09:14:42
 Duration            :  7s
 Module/Action       :  SQL*Plus/-
 Service             :  pdb
 Program             :  sqlplus
 Fetch Calls         :  1

Global Stats
==========================================================================
| Elapsed |   Cpu   |    IO    | PL/SQL  | Fetch | Buffer | Read | Read  |
| Time(s) | Time(s) | Waits(s) | Time(s) | Calls |  Gets  | Reqs | Bytes |
==========================================================================
|    6.36 |    1.21 |     5.15 |    0.00 |     1 |   159K | 1741 |   1GB |
==========================================================================

SQL Plan Monitoring Details (Plan Hash Value=3016543793)
===============================================================================================================================================
| Id |               Operation               |   Name   |  Rows   | Cost |   Time    | Start  | Execs |   Rows   | Activity | Activity Detail |
|    |                                       |          | (Estim) |      | Active(s) | Active |       | (Actual) |   (%)    |   (# samples)   |
===============================================================================================================================================
|  0 | SELECT STATEMENT                      |          |         |      |           |        |       |          |          |                 |
|  1 |   TABLE ACCESS BY INDEX ROWID BATCHED | BIG      |       1 |    4 |           |        |       |          |          |                 |
|  2 |    INDEX RANGE SCAN                   | BIG_ID_I |       1 |    3 |           |        |       |          |          |                 |
|  3 |   FAST DUAL                           |          |       1 |    2 |         6 |     +2 |     1 |        1 |          |                 |
===============================================================================================================================================


1 row selected.