aux_stats$
stores collected auxiliary system statistics which are used by the optimizer. sname
contains the name of set of parameters pname
contains the name of parameter pval1
stores the parameter value in number, pval2
in character format. begin dbms_stats.gather_system_stats('start'); … do stuff … dbms_stats.gather_system_stats('stop' ); end; /