Hi,
I sent you a statement I used to compare cdb and pdb parameter.
Maybe you can use it as a blueprint to compare your 2 dbs via dblink.
Thanks
Lothar
SELECT
pdb_name,
name,
con_id,
value
FROM ( SELECT
pdb_name,
name,
p.con_id,
value,
COUNT(DISTINCT p.con_id) OVER(
PARTITION BY name
) settings,
MIN(value) OVER(
PARTITION BY name
) min_value,
MAX(value) OVER(
PARTITION BY name
) max_value
FROM
gv$system_parameter p,
cdb_pdbs d
WHERE p.con_id = d.con_id
AND inst_id = 3)
WHERE
settings > 1
AND max_value != min_value;
Am 30.10.2022 um 11:13 schrieb Pap:
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?
Regards
Pap
