Search notes:

Oracle: SYS.AUX_STATS$

The table aux_stats$ stores collected auxiliary system statistics (dbms_stats.gather_system_stats) to be consumed 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

Fatal error: Uncaught PDOException: SQLSTATE[HY000]: General error: 8 attempt to write a readonly database in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php:78 Stack trace: #0 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(78): PDOStatement->execute(Array) #1 /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php(30): insert_webrequest_('/notes/developm...', 1758199096, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/installed/data-dictionary/base-tables/aux_stats/index(61): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78