http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FV_statistics_level 2026-04-06T13:43:02Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_statistics_level&diff=2186&oldid=prev 2010-05-26T13:45:19Z

<p></p> <table class="diff diff-contentalign-left" data-mw="interface"> <tr style="vertical-align: top;" lang="ru"> <td colspan="1" style="background-color: white; color:black; text-align: center;">← Предыдущая</td> <td colspan="1" style="background-color: white; color:black; text-align: center;">Версия 13:45, 26 мая 2010</td> </tr><tr><td colspan="2" style="text-align: center;" lang="ru"><div class="mw-diff-empty">(нет различий)</div> </td></tr></table>

http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_statistics_level&diff=2187&oldid=prev 2010-05-26T10:01:09Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==select statistics_name, system_status, statistics_view_name from v$statistics_level==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt; col statistics_name format a26<br /> SQL&gt; col STATISTICS_VIEW_NAME format a30<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; select statistics_name, system_status, statistics_view_name<br /> 2 from v$statistics_level<br /> 3 /<br /> STATISTICS_NAME SYSTEM_S STATISTICS_VIEW_NAME<br /> -------------------------- -------- ------------------------------<br /> Buffer Cache Advice ENABLED V$DB_CACHE_ADVICE<br /> MTTR Advice DISABLED V$MTTR_TARGET_ADVICE<br /> Timed Statistics ENABLED<br /> Timed OS Statistics DISABLED<br /> Segment Level Statistics ENABLED V$SEGSTAT<br /> PGA Advice ENABLED V$PGA_TARGET_ADVICE<br /> Plan Execution Statistics DISABLED V$SQL_PLAN_STATISTICS<br /> Shared Pool Advice ENABLED V$SHARED_POOL_ADVICE<br /> Modification Monitoring ENABLED<br /> Longops Statistics ENABLED V$SESSION_LONGOPS<br /> Bind Data Capture ENABLED V$SQL_BIND_CAPTURE<br /> Ultrafast Latch Statistics ENABLED<br /> Threshold-based Alerts ENABLED<br /> Global Cache Statistics ENABLED<br /> Active Session History ENABLED V$ACTIVE_SESSION_HISTORY<br /> Undo Advisor, Alerts and F ENABLED V$UNDOSTAT<br /> ast Ramp up<br /> STATISTICS_NAME SYSTEM_S STATISTICS_VIEW_NAME<br /> -------------------------- -------- ------------------------------<br /> <br /> 16 rows selected.<br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;</div>

Admin