ORA-03001: unimplemented feature
HI Experts.
Please suggest for below error. Oracle version is 11.2.0.2.0 on HP 64BIT machine.
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,
0