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. v$sql_plan_statistics
and the structural differences between v$sql_plan_statistics
and v$sql_plan_statistics_all
.