Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

E40402-15
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

V$STATISTICS_LEVEL

V$STATISTICS_LEVEL displays the status of the statistics/advisories controlled by STATISTICS_LEVEL.

Column Datatype Description
STATISTICS_NAME VARCHAR2(64) Name of the statistic/advisory
DESCRIPTION VARCHAR2(4000) Description of the statistic/advisory
SESSION_STATUS VARCHAR2(8) Status of the statistic/advisory for the session:
  • ENABLED

  • DISABLED

SYSTEM_STATUS VARCHAR2(8) System-wide status of the statistic/advisory:
  • ENABLED

  • DISABLED

ACTIVATION_LEVEL VARCHAR2(7) Indicates the level of STATISTICS_LEVEL that enables the statistic/advisory:
  • BASIC

  • TYPICAL

  • ALL

STATISTICS_VIEW_NAME VARCHAR2(64) 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.
SESSION_SETTABLE VARCHAR2(3) Indicates whether the statistic/advisory can be set at the session level (YES) or not (NO)