sql monitor and GATHER_PLAN_STATISTICS

[satish]

Dear Erman,

DB VERSION 12.1.0.2

We had a confusion on actual and estimated row counts with sql monitor and GATHER_PLAN_STATISTICS hint.Will these columns shows cumulative values from both  sql monitor and GATHER_PLAN_STATISTICS ?
Which one is better?

Thank you

[ErmanArslansOracleBlog]

Those 2 are both good methods.
Actual rows are cumulative, but estimated rows are not.

See this -> http://kerryosborne.oracle-guy.com/2010/02/09/gather_plan_statistics/

[Roshan]

Hi Erman,

what is the difference between cumulative and incremental rows?

[ErmanArslansOracleBlog]

Cumulative - total rows for multiple executions
incremental rows? What do you mean by that? Probably you mean the rows calcauted for each execution of a row source.
We were talking in terms of actual and estimated rows.

For instance;

per execution -> E-rows = 15 (not cumulative)  - estimated per execution
15 executions/starts ->  A-rows = 225 (cumulative) - cumulative counts