AnsweredAssumed Answered

Monitoring the Oracle RAC Cluster.

Question asked by NikhilKotagiri on Jan 22, 2010
Latest reply on Mar 13, 2018 by Hiko_Davis
Hello All,

We are   is using Oracle RAC (This configuration produces 4x the number of sql calls than normal), because of this reason for each SQL Query we are getting 20( 5 metrics for each SQl in each Oracle RAC) metrics so for this reason it is producing large number of metrics obviously which is more painfull to the EM.
We are trying to modify the SQlAgent.pbd (attached)file but i am not getting exactly which parameter we have to change in the pbd file.
So the bottom line is if we have 500 queries we have to get 2500 metrics but in our case we are getting 10000 metrics.For your Info I have attached a screen shot , in that you can find four databasenodes of the Oracle RAC and SQL node under each Database.

We are using
Introscope EM:7.2.3
Wily Agent version:7.2.3(weblogic).

Please   post me if you have any sueestions on the above issue

Thanks,
Nikhil

Outcomes