V$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.
Name of the statistic/advisory
Description of the statistic/advisory
Status of the statistic/advisory for the session:
System-wide status of the statistic/advisory:
Indicates the level of STATISTICS_LEVEL that enables the statistic/advisory:
If there is a single view externalizing the statistic/advisory, then this column contains the name of that view. If there is no such view, then this column is null. If there are multiple views involved, then the DESCRIPTION column mentions the view names.
Indicates whether the statistic/advisory can be set at the session level (YES) or not (NO)
The ID of the container to which the data pertains. Possible values include:
0: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs.
1: This value is used for rows containing data that pertain to only the root
n: Where n is the applicable container ID for the rows containing data