Open for Voting

DPA Oracle Execution Plans

Hi,

I noticed that inside DPA when reviewing the execution plan we are missing the important and useful Estimated Rows and Actual rows within the plan.

Is this something that can be added please?

Parents
  •  DPA is gathering from the V$SQL_PLAN table, AFAIK we don't add hints to queries as they are being executed. If you add the hint to your queries, I believe the data will get stored in V$SQL_PLAN, and then they might get displayed in DPA. If that doesn't work, open a support ticket and one of our SEs can work with you to get the data you need. HTH

Comment
  •  DPA is gathering from the V$SQL_PLAN table, AFAIK we don't add hints to queries as they are being executed. If you add the hint to your queries, I believe the data will get stored in V$SQL_PLAN, and then they might get displayed in DPA. If that doesn't work, open a support ticket and one of our SEs can work with you to get the data you need. HTH

Children
No Data