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

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

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 Champion
Dynatrace Champion

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.