SQL> SELECT /*+ PARALLEL (a 8) PARALLEL (b 8) */
SUM (space_used_delta) / 1024 / 1024 "USED_MB",
  2    3  SUM (c.bytes) / 1024 / 1024 "TOTAL_MB",
  4  ROUND (SUM (space_used_delta) / SUM (c.bytes) * 100, 2) || '%'"PERCENT"
  5  FROM dba_hist_snapshot sn,dba_hist_seg_stat a,
  6  dba_objects b,
  7  dba_segments c
  8  WHERE     end_interval_time > TRUNC (SYSDATE) - 7
  9  AND sn.snap_id = a.snap_id
 10  AND b.object_id = a.obj#
 11  AND b.owner = c.owner
AND b.object_name = c.segment_name
 12   13  AND c.owner = 'COMAPPO'
 14  AND space_used_delta > 0;
FROM dba_hist_snapshot sn,dba_hist_seg_stat a,
                            *
ERROR at line 5:
ORA-03001: unimplemented feature


SQL>