Search notes:

Oracle: SYS.AUX_STATS$

The table aux_stats$ stores collected auxiliary system statistics which are used by the optimizer.

Columns

The primary key of this table is sname and pname.
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.
These statistics can be collected, for example, with
begin
   dbms_stats.gather_system_stats('start');
   
   … do stuff …

   dbms_stats.gather_system_stats('stop' );
end;
/

Links

MOS Note 2791983.1: How to Update Db_file_multiblock_read_count (MBRC) Value Of Sys.aux_stat$ (sic!) Table

Index