Purpose
The purpose of this parameter is to gather database and operating system statistics into SYSAUX tablespace. For example, it uses for defining the detail of AWR reports.
Usage
Current setting:
SQL> show parameter statistics_level;
-- default is "TYPICAL"
(options -> BASIC | TYPICAL | ALL)
Change setting permanently:
add this into init.ora file;
*.statistics_level='ALL'
-- BASIC is not enough to get AWR Report
-- TYPICAL is recommended for AWR Report
-- ALL gathers operating system and plan execution statistics records in extra for AWR Report
Then restart the instance to perform.
Change setting for current instance - temporary:
SQL> alter system set statistics_level = ALL;
Result
SQL> show parameter statistics_level;
-- output; ALL
To check detail information, we may look at v$statistics_level view.
SQL> select * from v$statistics_level;
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214
The purpose of this parameter is to gather database and operating system statistics into SYSAUX tablespace. For example, it uses for defining the detail of AWR reports.
Usage
Current setting:
SQL> show parameter statistics_level;
-- default is "TYPICAL"
(options -> BASIC | TYPICAL | ALL)
Change setting permanently:
add this into init.ora file;
*.statistics_level='ALL'
-- BASIC is not enough to get AWR Report
-- TYPICAL is recommended for AWR Report
-- ALL gathers operating system and plan execution statistics records in extra for AWR Report
Then restart the instance to perform.
Change setting for current instance - temporary:
SQL> alter system set statistics_level = ALL;
Result
SQL> show parameter statistics_level;
-- output; ALL
To check detail information, we may look at v$statistics_level view.
SQL> select * from v$statistics_level;
Ref: https://docs.oracle.com/cd/B28359_01/server.111/b28320/initparams240.htm#REFRN10214