Database Tuning (MOSC)

MOSC Banner

AWR - question on segments by physical reads section

edited Oct 22, 2009 8:28AM in Database Tuning (MOSC) 2 commentsAnswered
 Hi,

While analyzing AWR report for an application which deployed into RAC platform, I see there a row reported with UNAVAILABLE/UNDEFINED values.

Is that normal for RAC platform ?. Would you help me out with this issue. This application is experiencing serious performance issues after migrated to RAC.

Thanks for your help,

Ravi

Segments by Physical Reads

  • Total Physical Reads: 34,782
  • Captured Segments account for 69.7% of Total

OwnerTablespace NameObject NameSubobject NameObj. TypePhysical Reads%Total
TLMDBATLM_D_SMALLCASM TABLE15,31244.02
** UNAVAILABLE **** UNAVAILABLE **** UNAVAILABLE **AILABLE **UNDEFINED6,69519.25
TLMDBATLM_I_SMALLCASMIXA INDEX5081.46
TLMDBATLM_I_SMALLACGRIXA

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