Pls your help with the following item:
Can I have visibility of the stored procedure or package execution time?
(For example: Queries, Cursors, functions that are executed inside the procedure or oracle package) with the agent of Oracle Dynatrace 6.5 with the Show SQL Execution Plan or through another form.
There is a similar but an old post, below answered by @Andreas G.
"dynaTrace is NOT able to see into the stored procedure as this is code executed on your Oracle Database. We see the SQL Statements being executed through JDBC. If you want to analyze the inner-workings of your stored procedure you need to use Oracle specific tools"
The following limitations apply for SQL Execution Plan:
Thank you very much for your answer.
That post I had seen before but it only refers to the java agent (by JDBC) and , I mean having visibility of the consumption of SQL objects through the Oracle 6.5 agent for my oracle database. In the attached image in Slow Querys
I checked the documents of database agent but did not find the requested information from you regarding look into the stored procedure. Following is the description of database monitoring:
Might be someone from development team can give us better understanding or the limitations similar to SQL Execution Plan.