Schema growth size per day

Hi to all,

We received task to calculate for each schema growth size in MB or GB per day. I have tried with below query, but it returns ** MISSING ** for one owner. Database is version 19.4 EE. And we do have diagnostic and tuning pack.

select owner

, space_used_delta / (1024 * 1024 ) space_growth_mb

from (select segs.owner

, sum (seg_stat.space_used_delta) space_used_delta

from dba_hist_seg_stat seg_stat

join dba_hist_snapshot snaps

on snaps.snap_id = seg_stat.snap_id

and snaps.dbid = seg_stat.dbid

and snaps.instance_number = seg_stat.instance_number

join dba_hist_seg_stat_obj segs