I'm happy to inform you that with ActvieGate 157 EAP with metrics is open. Please feel invited. New features will be added one by another.
working on Database Insights for Oracle that will help you resolve your
database performance issues using the power of our unified AI monitoring platform.
Draft mock (final design is subject to change)
Solved! Go to Solution.
This would be a great feature. Thanks for sharing the mockup and scope, it's really great to get a heads up on what is coming this way!
This link talks about viewing tablespace free space and size: https://www.dynatrace.com/capabilities/database-mo...
Will that also be available in Q3? And will that also be available via the API in Q3?
We have close to 1000s of Oracle DBs and we manage them by using Oracle Enterprise Manager- OEM. Do we have any plugin available for Dynatrace to collect the metrics from OEM or some sort of native DB tools, at the moment OEM Support webhooks or external calls.
We have a need for a way to run sql queries against columns in tables in Oracle databases, and monitor and alert on the values returned.
We have several oracle databases where a table is used to track the status of jobs submitted for processing. Each column represents a different stage of processing, and is somewhat similar to a print queue. We currently have monitoring set up to run an sql query counting rows in each column based on a particular Status. Thresholds in the monitoring system will alert when count values exceed preset thresholds in the monitoring system. Different columns have different count thresholds for alerting.
Dynatrace has no such capabilities. As of now, writing our own custom plugin would be the only solution available. I've submitted an RFE for this, with additional details: https://answers.dynatrace.com/spaces/483/dynatrace-product-ideas/idea/210664/need-an-oracle-plugin-to-query-columns-in-table-an.html
It is activegate plugin. It is licensing as Custom metrics
see description here https://www.dynatrace.com/support/help/get-started/reference/calculate-monitoring-consumption/?_ga=2.48981221.252539616.1552891028-109556350.1547634183
Refer to the snapshot above, where column is not sortable so far. Indeed in user-mixed env, we need sort.
Also i want capture alert the top one Query at any specific time period. Currently the metrcis such as Application Wait time, is accumulation, and need further dig into top query manually to identify which one induce or suffer the long waiting.
This looks interesting for our use case, but:
When using infrastructure like Oracle Exadata where I connect via the same hostname but different service names+user/password - how would I split those to different environments?
Multiple active gates in the same subnet? Multiple active gates on a single linux machine?
We love this data and it is super useful to have in-context with all other data inside of Dynatrace. It really helps in troubleshooting issues and making sure users have a single pane of glass to view full-stack metrics of any issue at hand.
We had previously (prior to 187) the custom database insight metrics coming in and tying back to the SID of the database where the OneAgent is running. This was a HUGE win for the Database teams in that they could see things, out the box, in line with all the other metrics. This feature, however, was removed. Would love to see this come back together.
There needs to be a better way to get to this data other than a single button on the technologies page, (currently hiding on the top right). We are working on getting more people engaged inside the tool and the accessibility is something we are always cognizant. The union of the process groups and this data was a big help here and we would love to see it opened back up, or have a way to do the configuration to pull it together on our own. Being separate really reduces value.
100 top SQLs looks not adequate while multiple applications share the central DB. But if the 100 top is configured to pull from special schema or user, it may be enough. Now my suggestion is to either increase top sql from default 100 to a biggger, configurable numbers, or to limit top sql to the selected schema or users.
Hi @Jakub M.,
Pls add metric Un Used Tablespace (absolute value and percent of Total Tablespace) in Oracle Insights Plug-in.
Usecase: An oracle admin would like to keep track of Un-Used Tablespace in all of the tables of their Ora DB instances so that they can ensure a minimum level at all times.
If Un-Used Tablespace goes below 10%, an automation script/bot can be executed to add more space.