2 Replies Latest reply on Feb 5, 2013 1:04 PM by mpatzwahl

    Estimated Rows Column, when using /*+ gather_plan_statistics*/


      does anybody know, where the Information of the estimated_rows (e-rows) Output comes from? I would like to auto check, when a explain uses wrong statistics.
      I know that is inside the dbms_xplan.display.display Package but i would like to use it out of a table -col
      By the Way i´m looking for a dbms_xplan output that uses the e-rows and a-rows cols and type=HTML. But i couldn´t find it.