This discussion is archived
4 Replies Latest reply: May 22, 2012 8:35 AM by castorp RSS

** MISSING ** entry for owner and object_name in AWR Segment statistics

castorp Explorer
Currently Being Moderated
Hello,

I have an AWR report which shows entries like this in the segment statistics section:
Segments by Physical Reads

    Owner       Tablespace Name          Object Name           Subobject Name   Obj. Type     Logical Reads   %Total
** MISSING **   USERS             ** MISSING: 205065/205065   ** MISSING **     UNDEFINED     3,967           2.60
APP_USER        USERS             SYS_LOB0000123236C00006$$                     LOB           3,747           2.45
** MISSING **   USERS             ** MISSING: 205069/205069   ** MISSING **     UNDEFINED     3,521           2.30
Is this something I should be worried about?
If yes, what could be the cause for such an entry?

My Oracle version:
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
On a RHEL (not sure about the version though)

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points