Mega Code Archive

 

Categories / Oracle PLSQL / System Tables Views

 

Select statistics_name, system_status, statistics_view_name from v$statistics_level

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>