Discussion Feed

I have a requirement for reporting on the performance of a specific query in Oracle. The performance of this query serves as a proxy for the performance of a very old Oracle Forms application. I have been looking for a way to gather this data but so far have not been able to find a way to do it in AppDynamics.   The query needs to be executed every five minutes and performance data needs to be reported on this query. So far, I have looked at the SQL extension and Custom Metrics from the database agent. Both of these options would give me the ability to submit the query, but neither of them seems to gather execution times for these queries. I have looked at trying to write an SQL in Oracle that would return timing for a query but I have not been able to find something that will work.    Does anyone have any suggestions? ... View more

We are experimenting with docker container monitoring with an eye to deploying this to production in the next couple of weeks. We are currently using a lab environment to make sure we have all of our deployment working properly. We are using RedHat linux with the machine agent running outside of the docker environment. The machine agent is properly configured to capture the docker information and we can view it inside of the controller user interface. Our problem is that whenever the underlying linux server is restarted (it is a lab environment after all), the controller loses all of the data related to the machine and all of the underlying containers. Additionally, the servers page in the controller reverts the server to machine agent (instead of server visibility) level.  What settings do I need to change in order for the metrics to remain and be viewable? Our current docker environment has a number of fixed underlying servers and only the containers running on those servers are transient. Any help that you can give me would be greatly appreciated.   Thanks. ... View more

We have a transaction processing system that is largely implemented using Oracle stored procedures. Each of the transactions are accessed by calling a shell stored procedure where the text does not change. This means that the query ID of the base transaction will never change.  I would like to be able to access the database query data so that I can automatically perform some calculations. I have done enough reading to know that the data I am interested in is stored in Elastic Search.  Here are my questions: - Can I attach Kibana to this Elastic Search instance? If so, what version of Kibana should be used? - Can I query the Elastic Search instance using the standard Elastic Search API? - Has anyone in the community tried to do this? What level of success have you achieved?   Thanks! Dale Chapman ... View more