Re: AWR report looks same for primary and standby database

Thank you so much.

On Thu, 11 Aug 2022, 3:52 pm , <niall.litchfield_at_gmail.com> wrote:

> You'll need at least 12.2 and Note 2409808.1 to configure AWR reporting
> for an Active Data Guard standby.
>
> On Thu, Aug 11, 2022 at 11:16 AM yudhi s <learnerdatabase99_at_gmail.com>
> wrote:
>
>> Hello All, This is version 12c Oracle database and oem is "Enterprise
>> ManagerCloud Control 13c" and its a Exadata system. We have read-only
>> standby database configured using data-guard. The standby database is
>> currently serving some of the reporting jobs which are read-only types. We
>> have a requirement to see how much load those jobs are putting on the
>> standby database and if we can run some of those back on primary.
>>
>> While fetching the AWR report to see the standby database stats and its
>> storage cell related usage statistics, we are seeing all the statistics are
>> same as primary for a specific snap duration. Even the host name is showing
>> as that of primary. So it means they(AWR data) were copied from primary and
>> shipped to standby same as transaction data. So wanted to understand is
>> there any specific configuration require to pull only standby database
>> related AWR reports from oem and related exadata storage cell statistics?
>>
>> Regards
>> Yudhi
>>
>
>
> --
> Niall Litchfield
> Oracle DBA
> http://www.orawin.info
>

--
http://www.freelists.org/webpage/oracle-l