select statistics_name, system_status, statistics_view_name from v$statistics_level : v_statistics_level « System Tables Data Dictionary « Oracle PL/SQL Tutorial






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>








30.123.v_statistics_level
30.123.1.select statistics_name, system_status, statistics_view_name from v$statistics_level