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?
Solved! Go to Solution.
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.