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>
Related examples in the same category