2 Replies Latest reply: Feb 5, 2013 7:04 AM by mpatzwahl RSS

    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.