topic New Oracle extension execution plan in Extensions

New Oracle extension execution plan

amita — Fri, 27 Sep 2024 06:58:59 GMT

I am trying to get the execution plan for in new oracle extension,However after Requesting for the same it is giving me error stating "Couldn't obtain execution plan",

Kindly let me know if something is missing here.

Thanks

Amita

Re: New Oracle extension execution plan

p_devulapalli — Thu, 26 Sep 2024 22:30:28 GMT

Hi @amita

Are all the needed permissions set as below?

https://www.dynatrace.com/hub/detail/oracle-database/

Execution Plan Monitoring

For SaaS customers with access to the Databases app, the execution plan monitoring functionality is also available when analyzing statement performance.

For this feature to work, the DBMS_XPLAN package needs to be available, and the user configured in the Dynatrace extension needs to have permissions to call the DISPLAY_CURSOR function. As per the official documentation this means that SELECT or READ permissions are required on the following views:

V$SQL_PLAN
V$SESSION
V$SQL_PLAN_STATISTICS_ALL
V$SQL

In addition to this, the SELECT permission is also required for V$SQL_PLAN.

Please note that the execution plan monitoring feature may sometimes not work as expected for RAC deployments. This will be fixed as soon as possible.

Re: New Oracle extension execution plan

amita — Mon, 30 Sep 2024 10:49:53 GMT

Hi @p_devulapalli
Thanks for your reply.

I will reverify above config once again.

Amita