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

<p>1 версия</p> <p><b>Новая страница</b></p><div>==Search DBA_OBJECT_SIZE for package and procedure size==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt; select Owner,<br /> 2 Name,<br /> 3 Type,<br /> 4 Source_Size+Code_Size+Parsed_Size+Error_Size Total_Bytes<br /> 5 from DBA_OBJECT_SIZE<br /> 6 where Type in (&quot;PACKAGE BODY&quot;,&quot;PROCEDURE&quot;) and rownum &lt; 10<br /> 7 order by 4 desc;<br /> <br /> OWNER NAME TYPE TOTAL_BYTES<br /> ------------------------------ ------------------------------ ------------- -----------<br /> SYS DIUTIL PACKAGE BODY 59325<br /> DBMS_REGISTRY PACKAGE BODY 47351<br /> DIANA PACKAGE BODY 45907<br /> STANDARD PACKAGE BODY 34458<br /> PIDL PACKAGE BODY 16577<br /> PSTUB PROCEDURE 3812<br /> PSTUBT PROCEDURE 2753<br /> XML_SCHEMA_NAME_PRESENT PACKAGE BODY 2728<br /> SUBPTXT2 PROCEDURE 2469<br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt;<br /> <br /> <br /> <br /> &lt;/source&gt;</div>

Admin