http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FV_db_cache_advice 2026-05-25T16:05:34Z История изменений этой страницы в вики MediaWiki 1.30.0 http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_db_cache_advice&diff=2260&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_db_cache_advice&diff=2261&oldid=prev 2010-05-26T10:01:17Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Query v$db_cache_advice for factor,==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt; col size_for_estimate format 9,999 heading SIZEMB<br /> SQL&gt; col ESTD_PHYSICAL_READ_FACTOR format 99.99 heading EST_P_READ_FACTOR<br /> SQL&gt; col ESTD_PHYSICAL_READS format 99,999 heading EST_P_READS<br /> SQL&gt; col BUFFERS_FOR_ESTIMATE format 99,999 heading #BUFFERS<br /> SQL&gt;<br /> SQL&gt; select<br /> 2 SIZE_FOR_ESTIMATE<br /> 3 ,SIZE_FACTOR<br /> 4 ,BUFFERS_FOR_ESTIMATE<br /> 5 ,ESTD_PHYSICAL_READ_FACTOR<br /> 6 ,ESTD_PHYSICAL_READS<br /> 7 from v$db_cache_advice<br /> 8 /<br /> SIZEMB SIZE_FACTOR #BUFFERS EST_P_READ_FACTOR EST_P_READS<br /> ------ ----------- -------- ----------------- -----------<br /> 4 1 499 0<br /> 8 2 998 0<br /> 16 .0976 1,996 1.48 90,836<br /> 32 .1951 3,992 1.36 83,188<br /> 48 .2927 5,988 1.31 80,414<br /> 64 .3902 7,984 1.28 78,687<br /> 80 .4878 9,980 1.27 77,977<br /> 96 .5854 11,976 1.26 77,148<br /> 112 .6829 13,972 1.20 73,447<br /> 128 .7805 15,968 1.19 72,746<br /> 144 .878 17,964 1.01 61,880<br /> 160 .9756 19,960 1.00 61,386<br /> 164 1 20,459 1.00 61,347<br /> 176 1.0732 21,956 1.00 61,189<br /> 192 1.1707 23,952 .99 60,893<br /> 208 1.2683 25,948 .97 59,521<br /> 224 1.3659 27,944 .92 56,728<br /> 240 1.4634 29,940 .89 54,547<br /> 256 1.561 31,936 .86 52,938<br /> 272 1.6585 33,932 .81 49,405<br /> 288 1.7561 35,928 .80 49,376<br /> 304 1.8537 37,924 .80 49,336<br /> 320 1.9512 39,920 .75 46,040<br /> 23 rows selected.<br /> SQL&gt;<br /> <br /> &lt;/source&gt;</div>

Admin