This discussion is archived
2 Replies Latest reply: Feb 5, 2013 5:04 AM by mpatzwahl RSS

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

mpatzwahl Newbie
Currently Being Moderated
Hi,

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.

Thanks

Marco

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points