Re: Comparison of stats and parameters

From: Lothar Flatz <l.flatz_at_bluewin.ch>
Date: Sun, 30 Oct 2022 14:49:38 +0100
Message-ID: <e61b2722-9fe5-84d9-f743-469f69f98d00_at_bluewin.ch>

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

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

Received on Sun Oct 30 2022 - 14:49:38 CET