AWR report looks same for primary and standby database
From: yudhi s <learnerdatabase99_at_gmail.com>
Date: Thu, 11 Aug 2022 15:46:38 +0530
Message-ID: <CAEzWdqd8YDS4N-+05kqeno8KRX2WoJt8YLo+bvF4k1uMsv1HnQ_at_mail.gmail.com>
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.
Date: Thu, 11 Aug 2022 15:46:38 +0530
Message-ID: <CAEzWdqd8YDS4N-+05kqeno8KRX2WoJt8YLo+bvF4k1uMsv1HnQ_at_mail.gmail.com>
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
-- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 11 2022 - 12:16:38 CEST