AWR report can't pinpoint the Bad SQLs
Pete_Sg1Aug 22 2012 — edited Aug 24 2012DB version : 11.2.0.2
Platform : Solaris 10
In our 2-node RAC DB , we have schemas from 20 applications. When one application faces performance issues , we try to generate AWR for the period in question. But the stats (like Bad SQLs) for this schema get buried because there are SQLs from other application which were performing even more badly.
I know we can't create AWR report for specific schemas. But I wonder how stats are collected in a multi-schema RAC environments which will differentiate between applications .