Oracle stored procedures

[mkulov]

Hi,

Is it possible to monitor the performance of individual SQL statements inside Oracle stored procedure?

Customer is having complex Oracle stored procedures and would like to track performance on individual statements inside each sp.

Thanks,

Martin

[Babar_Qayyum]

Hello @mkulov 

Have a look at the below thread:

https://community.dynatrace.com/t5/Open-Q-A/Execution-time-of-queries-inside-stored-procedues/m-p/11...

Regards,

Babar

[mkulov]

Hi @Babar_Qayyum ,

Looks like there was supposed to be Database Insights module which will provide the above.

Is this correct?

Given that the Oracle Insights module is now deprecated, should we expected something new to be released?

Thanks,

Martin

[Julius_Loman]

The Oracle Database Extension provides you with the most consuming SQL statements. But not for all statements.