Search notes:

Oracle: Init parameter STATISTICS_LEVEL

The value of statistics_level can be set to
all
typical The default value. It collects all statistics except timed operating system statistics and plan execution statistics (aka row source statistics).
basic Disables the collection of some statistics.
The list of statistics that can be enabled or disabled with statistics_level can be queried from v$statistics_level:
select
   statistics_name,
   description,
   session_status,
   system_status
from
   v$statistics_level
where
   activation_level = 'ALL' -- or 'TYPICAL'
order by
   lower(statistics_name);

Relationship to TIMED_STATISTICS

The value of timed_statistics must be true if statistics_level is changed to typical or all.
Vice versa, timed_statistics cannot be set to false if statistics_level is typical or all.
select p.name, p.value
from v$parameter p
where p.name in ( 'statistics_level', 'timed_statistics' );
--
-- NAME             VALUE
-- ---------------- -------
-- timed_statistics TRUE
-- statistics_level TYPICAL

alter session set timed_statistics = false;
> ORA-02097: parameter cannot be modified because specified value is invalid
> ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC

Relationship to _ROWSOURCE_STATISTICS_SAMPFREQ

Jonathan Lewis suspects that setting statistics_level to all implicitly sets _rowsource_statistics_sampfreq to 1.

Misc

In order to enable automatic shared memory management, the value of statistics_level must either be typical or all.
Changing statistics_level as system level causes all advisors that are affected by this parameter to be restarted (MOS Note 2673186.1).

See also

Prerequisites for filling V$SQL_PLAN_STATISTICS and V$SQL_PLAN_STATISTICS_ALL
timed_statistics, timed_os_statistics
Setting fast_start_mttr_target to a non-zero value and statistics_level to typical or all enables the MTTR Advisory.
Setting statistics_level to at least typical is a prerequisite for v$sga_target_advice to be populated (the other one is to set db_cache_advice to on).
ORA-00044: timed_statistics must be TRUE when statistics_level is not BASIC

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...', 1758198907, '216.73.216.150', 'Mozilla/5.0 App...', NULL) #2 /home/httpd/vhosts/renenyffenegger.ch/httpsdocs/notes/development/databases/Oracle/adminstration/init-parameters/statistics_level/index(104): insert_webrequest() #3 {main} thrown in /home/httpd/vhosts/renenyffenegger.ch/php/web-request-database.php on line 78