http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2FV_DATAFILE 2026-05-24T11:40:28Z История изменений этой страницы в вики MediaWiki 1.30.0 http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_DATAFILE&diff=2234&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://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/V_DATAFILE&diff=2235&oldid=prev 2010-05-26T10:01:14Z

<p>1 версия</p> <p><b>Новая страница</b></p><div>==I/O (expressed in database blocks) by datafile==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> <br /> SQL&gt;<br /> SQL&gt; select DF.Name File_Name,<br /> 2 FS.Phyblkrd Blocks_Read,<br /> 3 FS.Phyblkwrt Blocks_Written,<br /> 4 FS.Phyblkrd+FS.Phyblkwrt Total_IOs<br /> 5 from V$FILESTAT FS, V$DATAFILE DF<br /> 6 where DF.File#=FS.File#<br /> 7 order by FS.Phyblkrd+FS.Phyblkwrt desc;<br /> <br /> FILE_NAME<br /> ------------------------------------------------------<br /> BLOCKS_READ BLOCKS_WRITTEN TOTAL_IOS<br /> ----------- -------------- ----------<br /> C:\ORACLEXE\ORADATA\XE\SYSTEM.DBF<br /> 4954 405 5359<br /> C:\ORACLEXE\ORADATA\XE\SYSAUX.DBF<br /> 2294 398 2692<br /> C:\ORACLEXE\ORADATA\XE\UNDO.DBF<br /> 1219 1422 2641<br /> C:\ORACLEXE\ORADATA\XE\USERS.DBF<br /> 6 3 9<br /> C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\<br /> DATA_1B.DBF<br /> 5 2 7<br /> C:\ORACLEXE\APP\ORACLE\PRODUCT\10.2.0\SERVER\DATABASE\<br /> DATA_1A.DBF<br /> 5 2 7<br /> <br /> <br /> 6 rows selected.<br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;</div>

Admin