If you are talking about Oracle's statement plans cost, I believe it is not available for the moment.
But, it this SQL cost varies significantly, it does impact the timings that Dynatrace detects, and you will be alerted when it varies significantly, also.
Pretty sure it's not directly related to the Cost column in Oracle statement plans.
I believe that the point refers to the fact that we can be alerted when the SQL statements start consuming more time/resources, and in a certain way, reflects the Costs referenced by the statement plans, although not the same in terms of metric.
Thank you. Do you think that such type of a metric can be provided by Dynatrace? Will this enhance the insight of the database (as the execution metric is already available)?
Thank you for your opinion. In this case, the metrics can be available on-demand bases, as we have a SQL bind value. I am doing this brainstorming with you because recently we have seen a wearied behavior of the stress testing in the UAT environment where nothing was clear until a DBA disclosed that there is a query performing a full table scan plus a high cost and without any index. So he had to create an index to enhance the query performance.
The new execution plan cost was reduced from 106 to 3. Therefore, if we can have such types of observations from the monitoring perspective instead of relying on DBAs.