Comparison of stats and parameters
From: Pap <oracle.developer35_at_gmail.com>
Date: Sun, 30 Oct 2022 15:43:13 +0530
Message-ID: <CAEjw_fi7DKGZ44NkWeqScQMHura1xB4ezQa6P+f9LiZQN0++1A_at_mail.gmail.com>
Hello Listers,
Actually we have a customer application running on Oracle 19.15 version databases with two sides(primary and Disaster recovery) active-active configuration i.e both read and write and each of them having in sync using golden gate replication. At any point in time the majority of the applications write activity is happening on one side(i.e we call the primary side for that time). and that same thing is replicated to the other side using GGS replication and vice versa.
Date: Sun, 30 Oct 2022 15:43:13 +0530
Message-ID: <CAEjw_fi7DKGZ44NkWeqScQMHura1xB4ezQa6P+f9LiZQN0++1A_at_mail.gmail.com>
Hello Listers,
Actually we have a customer application running on Oracle 19.15 version databases with two sides(primary and Disaster recovery) active-active configuration i.e both read and write and each of them having in sync using golden gate replication. At any point in time the majority of the applications write activity is happening on one side(i.e we call the primary side for that time). and that same thing is replicated to the other side using GGS replication and vice versa.
We have many times encountered issues while pointing application traffic from one side to other. Things running fine on one side behave badly when switched to the other side and it's because of differences in object statistics and also sometimes differences in object structures or DB parameters because the DBA team missed to apply changes to both sides. So I wanted to understand from experts here, is there any easy/quick way or existing oracle tool available , to compare the basic optimization things like object statistics, DB parameters, difference in Sql execution paths etc between two sides/databases and based on that we can trigger some automatic alerts, so as to avoid potential issues beforehand?
-- http://www.freelists.org/webpage/oracle-lReceived on Sun Oct 30 2022 - 11:13:13 CET