Showing results for 
Show  only  | Search instead for 
Did you mean: 

Could Dynatrace Run This Oracle DB Query?



Hello everyone,

So I have an Oracle database query with a format more or less like this:

select "REUPLOAD_VALUE" COLUMN,count(*) from DBNAME.REG_VALUE where status='REUPLOAD'    
and the output will be a table like the one below.
COLUMN                | COUNT(*)


Is it possible to use Dynatrace, perhaps with an extension, to retrieve the result from the COUNT(*) column?

Then from the result, we will set a threshold, and if it exceeds a certain value, then an alert will be sent.

If possible, could you please assist in showing an example of how to do this?

Thank you.


DynaMight Guru
DynaMight Guru

Hi @agylpradipta. Yes it's possible, one easy approach is do it with a script:

  1. Execute the query from command line. Save output to txt.
  2. Parse the output txt.
  3. Use the Metrics API to ingest you REUPLOAD_VALUE METRIC.
  4. Create a Metric Event based on your metric from step 3.
  5. Cron your script and you're done!!!!


The true delight is in the finding out rather than in the knowing.

Is there a simpler approach? For instance, I just came across this extension, could we use that?

You could use that, but the extension is deprecated so I wouldn't use something that is not supported anymore.

Rather use this one:

I've just come across the following extension version, which seems to be new and not deprecated -> Can we use this?

If so, would anyone here be willing to share how to use it, referring to the Oracle database query I sent earlier?

Thank you.

Yes, you can use it. 
You need to build your own extension. I would recommend using the extension plugin for VSCode

Then you need to build the extensión, refer to SQL datasource here


Featured Posts