hakan01

Sorry we are using DPA 12.0.3074 Thanks Hakan

in Oracle DPA Query Plans Comment by hakan01 May 2020

Hi, I am not sure how DPA works to get the explain plan but as a basic example you can add a hint to the sql /*+ GATHER_PLAN_STATISTICS */ Then the following will get the explain plan with estimated and actual rows SELECT * FROM TABLE(DBMS_XPLAN.display_cursor(format=>'ALLSTATS LAST')); I can try attaching an example if…

in DPA Oracle Execution Plans Comment by hakan01 June 2020

Hi,

in For Oracle database monitored it would be really useful to get the A-Rows (Actual Rows) and E-Rows (Estimated Rows) returned in the explain plan Comment by hakan01 November 2022

Hi,

in For Oracle database monitored it would be really useful to get the A-Rows (Actual Rows) and E-Rows (Estimated Rows) returned in the explain plan Comment by hakan01 November 2022

hakan01

Comments