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
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
- Backends|{RAC 2, location (Oracle DB)}|... summary and 2500+ SQLAgent metrics
- Backends|{RAC 3, location (Oracle DB)}|... summary and 2500+ SQLAgent metrics
- Backends|{RAC 4, location (Oracle DB)}|... summary and 2500+ SQLAgent metrics
What you want is:- Backends|{All Oracle RAC (Oracle DB)}|... summary and 2500+ SQLAgent metrics 2500+ metrics instead of 10000+ metrics, i.e. looking at the Oracle RAC as a single unit. If the answer is yes, then, this can be resolved using a custom name formatter that understands Oracle RAC names. Please contact the Professional Service Team, as they can implement/develop this for you. Best Regards, Sergio