AWR - question on segments by physical reads section
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
Owner | Tablespace Name | Object Name | Subobject Name | Obj. Type | Physical Reads | %Total |
---|---|---|---|---|---|---|
TLMDBA | TLM_D_SMALL | CASM | TABLE | 15,312 | 44.02 | |
** UNAVAILABLE ** | ** UNAVAILABLE ** | ** UNAVAILABLE ** | AILABLE ** | UNDEFINED | 6,695 | 19.25 |
TLMDBA | TLM_I_SMALL | CASMIXA | INDEX | 508 | 1.46 | |
TLMDBA | TLM_I_SMALL | ACGRIXA |