New Oracle extension execution plan

[amita]

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

[p_devulapalli · Accepted solution]

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.

[amita]

Hi @p_devulapalli 
Thanks for your reply.

I will reverify above config once again.

Amita