question

Jakub M. avatar image
Jakub M. asked ·

Oracle Database Insights. Inputs wanted!

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.

-------------------------------------------

We are 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)

Beta scope

  • Oracle
  • Database overview (metrics, problems detection,properties)
  • Wait events
  • TopN SQL
  • Explain plans from database views

Interested? Get involved!

  • Comment on this thread to share your inputs, ideas and requests!

Dynatrace Manageddynatrace saasmonitoringdatabaseactivegate
oracleeap.png (587.1 KiB)
13 comments
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

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!

1 Like 1 · ·

Any Updates on EAP or GA availibility @Jakub M.

Could use this in a current project.

1 Like 1 · ·

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.

https://docs.oracle.com/cd/E73210_01/EMCIG/GUID-FBA700A1-B2F0-4A7B-980C-E4816A21FAD4.htm#EMCIG169

2 Likes 2 · ·

As I was reading the post, I thought of the exact same comment. I haven't had an opportunity to explore the current dynatrace options for oracle, but it's next on my list to investigate. We use OEM extensively too. It would be super awesome to have that integration if it's not there already!!!

0 Likes 0 · ·

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

1 Like 1 · ·

I've got a customer at this very moment asking why Dynatrace can't natively pull things like Tablespace from an Oracle database. I would love to either beta what you have or know when beta will be available if not GA.

0 Likes 0 · ·

If i missed it, on thing that clients want is the ability to see the usage of database connections, will this be part what is available?

0 Likes 0 · ·

For managed environments Multi-tenant AG support for Database insights would be great advantage. (Avoiding dedicated AG's for all tenants)

0 Likes 0 · ·

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.

0 Likes 0 · ·

Hey @Jakub M., is there a timeline for RAC support?

0 Likes 0 · ·

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.

4 Likes 4 · ·

+1. This is hugely important!

0 Likes 0 · ·

Done the POC. We find most needy features should include Total Connections from client side to DB, which is missing now. Active Session is helpful but not as useful as Total Connection. Total Connection shall be used for both performance and capacity planning.

0 Likes 0 · ·
Jakub M. avatar image
Jakub M. answered ·

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.

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Kayan H. avatar image
Kayan H. answered ·

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?

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Dustin L. avatar image
Dustin L. answered ·

Hi, also interested on when this may be available. Would this require an agent to be deployed on the Oracle server or will it obtaining metrics through agents on the monitored applications?

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Yep, also interested in this^ --Edit: noticed this was answered already, it'll run on the ActiveGate and monitor the DB remotely

0 Likes 0 · ·
Vlad S. avatar image
Vlad S. answered ·

Looking forward for Oracle, MS SQL and Sybase support

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Kelly M. avatar image
Kelly M. answered ·

Will there be any monitoring information pertaining to monitoring RAC, ASM and Dataguard?

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Intially we will suport only standalone Oracle

1 Like 1 · ·
Dante P. avatar image
Dante P. answered ·

This looks awesome. Is there any news of these features? Really looking to DB Monitoring. From DB Perspective!

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Jose A. avatar image
Jose A. answered ·

Hi, will this feature be availabe in Q3 on oneAgent for Solaris?

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Database insights will run on ActiveGate server and monitor databases remotly.

1 Like 1 · ·
Eliane S. avatar image
Eliane S. answered ·

My customer is very interested in this feature!

Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Ray B. avatar image
Ray B. answered ·

Would these metrics be exposed on the API?

1 comment Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

Yes, those metrics will be available via API

0 Likes 0 · ·
Pedro V. avatar image
Pedro V. answered ·

Hi,
Do you have the step by step to create this dashboard ?

2 comments Share
10 |2000000 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 50.0 MiB each and 250.0 MiB total.

This dashboard will be available with Oracle Database insights.

1 Like 1 · ·

Hello Jakub, When are you plannning to release beta version for this? If our customer is running Oracle database in Solaris, this will be the best way to monitor?

1 Like 1 · ·