Search notes:

Oracle: V$SQL_PLAN_STATISTICS_ALL

v$sql_plan_statistics_all aggregates information from v$sql_plan, v$sql_plan_statistics and v$sql_workarea and contains statistics for execution plan row sources that require SQL memory for sort or hash join operations.
v$sql_plan_statistics_all allows to compare the estimates of the optimzer for an SQL statement with the actual exection figures that the statement had.

See also

See also Prerequisites for filling V$SQL_PLAN_STATISTICS and V$SQL_PLAN_STATISTICS_ALL
v$sql_plan_statistics and the structural differences between v$sql_plan_statistics and v$sql_plan_statistics_all.

Index