Oracle PL/SQL/System Tables Views/V statistics level — различия между версиями

Материал из SQL эксперт
Перейти к: навигация, поиск
м (1 версия)
 
(нет различий)

Версия 13:45, 26 мая 2010

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>