Oracle PL/SQL/System Tables Views/V statistics level

select statistics_name, system_status, statistics_view_name from v$statistics_level

   <source lang="sql">
  

SQL> SQL> col statistics_name format a26 SQL> col STATISTICS_VIEW_NAME format a30 SQL> SQL> SQL> SQL> select statistics_name, system_status, statistics_view_name

 2  from v$statistics_level
 3  /

STATISTICS_NAME SYSTEM_S STATISTICS_VIEW_NAME

---

-------- ------------------------------

Buffer Cache Advice ENABLED V$DB_CACHE_ADVICE MTTR Advice DISABLED V$MTTR_TARGET_ADVICE Timed Statistics ENABLED Timed OS Statistics DISABLED Segment Level Statistics ENABLED V$SEGSTAT PGA Advice ENABLED V$PGA_TARGET_ADVICE Plan Execution Statistics DISABLED V$SQL_PLAN_STATISTICS Shared Pool Advice ENABLED V$SHARED_POOL_ADVICE Modification Monitoring ENABLED Longops Statistics ENABLED V$SESSION_LONGOPS Bind Data Capture ENABLED V$SQL_BIND_CAPTURE Ultrafast Latch Statistics ENABLED Threshold-based Alerts ENABLED Global Cache Statistics ENABLED Active Session History ENABLED V$ACTIVE_SESSION_HISTORY Undo Advisor, Alerts and F ENABLED V$UNDOSTAT ast Ramp up STATISTICS_NAME SYSTEM_S STATISTICS_VIEW_NAME

---

-------- ------------------------------

16 rows selected. SQL>

 </source>