Groovy job from Oracle to XML

[CommunityUser]

HI all,

I have  a groovy job that is reading from ORACLE DB and write in XML files. So , what I want to monitor is the following

1-Howmany rows inserted into oracle in hour

2-How may XML files has been created in to the system.

[Arun_Dasetty]

Hi,

Thanks for writing in. We have a sql query detection for oracle and other database backends under snapshot => sql calls section as referred in attached screenshot  but this data is specific to particular execution of BT, and we do not see an option or screen that shows the number of sql queries executed per hour in Lite version of the product.

Regarding the other query, Say if there is an API that returns the number of XML files created or if there API/method that will called for writing xml files and returns count 1 for each call, though in lite version of the product we do not have such feature to collect sum of all values on multiple calls to the particular API/method, we have feature "Method data collectors and Information points" which might help to get such data in our Pro version of appdynamics product.

Let us know if that clarifies your query. Do write back to us for further assistance.

Thanks,

Arun