Database Administration (MOSC)

MOSC Banner

ORA-03001: unimplemented feature

edited May 15, 2012 4:16AM in Database Administration (MOSC) 5 commentsAnswered
 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,

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center