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

This product reached the end of support date on March 31, 2021.

Can SQL Execution Plan be Shown if The Purepath/Trans-Flow Doesn't Stitch Up to Database Tier

waikeat_chan
DynaMight Pro
DynaMight Pro

Hi,

The situation is that we are monitoring Oracle Forms using AppMon, which is not supported and thus, stitching only stops at App Tier. But anyway, client still wants to give database agent a try and see what we can get.

Of course we can get the user calls, session, total wait time etc... kinds of metrics as shown in screenshot below. WHat about execution plan? Is it possible to retrieve them on-demand in this kind of.....rare situation? Is there any other way to drill-down/show execution plan without entering the context or purepath tree of context of database dashboard?

Best Regards,

Wai Keat

2 REPLIES 2

Joe_Hoffman
Dynatrace Leader
Dynatrace Leader

Wai,

Execution Plans requires the SQL text as input. And SQL text is not captured by the Database agent as it focuses on DB-wide metrics as opposed to transactional metrics. So unless you can capture the SQL from the Java agent side, the DB agent will not be able to provide any additional visibility into Explain plans.

Michal_Weyer
Newcomer

Explain plans are available from database live views.