The change in the queries may help, but not enough to make a difference.
Are the Oracle Databases the starting point of your CAM model?
Does this pattern really trigger 700+ times in a single day? Why would it trigger/run that many time? That seems a bit of overkill, and perhaps your 'trigger' for the CAM model is not unique enough.
I would try changing your 'starting point' in the CAM model to see if that helps.
It may turn out that this application may require modeling exclusively through TPL.
Or you may need to write a custom pattern to infer a more unique trigger for your CAM model.
Are you able to share (export) your CAM definition in this public forum? If not, are you able to share the defintion with me via private message?
Thanks for your observations.
I have changed the required functional component from Oracle DB to another one that triggers much less.
Here are the figures BEFORE that change in my test environment:
And here are those AFTER the change in the same environment, just finished scanning:
Usually the Oracle DB is a good required functional component, many applications are DB + Tomcat/Jboss + Webserver + Website + MQ Series, from which the DB triggers the least. For the particular SAS BAI causing the problem, I recently changed the DB defintion from one single match to 20 matches as the SAS BAI was redefined (from the application point of view). Doing that, I completely oversaw the consequence of having a complex BAI triggering that often.