long run preupgrade due to check tablespace usage
Hi,
When I run preupgrade tool it stacks on tablespace usage SQL:
select ds.tablespace_name,
row_number() over (partition by tablespace_name order by 1) rn,
round(nvl(sum(ds.bytes) over (partition by ds.tablespace_name),0),2) as inuse
from sys.dba_segments ds) where rn =1;
It runs hours.
I purged dba_recyclebin before but it doesn't help.
current Oracle version: 12.2.0.1.190115
BR.