select sum(bytes)/1024/1024/1024 from dba_segments
where tablespace_name='SYSAUX' and segment_name='STREAMS$_APPLY_SPILL_MSGS_PART'

select Apply_name "Apply Name",
xidusn||'.'||xidslt||'.'||xidsqn XID,
first_scn "First SCN",
first_message_create_time "First Message Time",
message_count "Message Count",
spill_creation_time "Spill Time"
from DBA_APPLY_SPILL_TXN
order by "Spill Time";

   	Apply Name	XID	First SCN	First Message Time	Message Count	Spill Time
1	APP$ORCL7	922.18.45569218	351943428766	30/09/2019 13:17:46	25754109	30/09/2019 13:18:17