http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fuser_object_size
Oracle PL/SQL/System Tables Views/user object size - История изменений
2026-05-26T13:49:45Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/user_object_size&diff=2142&oldid=prev
в 13:45, 26 мая 2010
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/user_object_size&diff=2143&oldid=prev
Admin: 1 версия
2010-05-26T10:01:04Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Query user_object_size table==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> SELECT name, type, source_size, parsed_size, code_size<br />
2 FROM user_object_size<br />
3 WHERE type IN ("PACKAGE", "PACKAGE BODY","PROCEDURE", "FUNCTION", "TRIGGER")<br />
4 and rownum < 50<br />
5 ORDER BY type, name;<br />
NAME TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE<br />
------------------------------ ------------- ----------- ----------- ----------<br />
COMPUTE_DISCOUNTS FUNCTION 566 251 572<br />
DATE_RANGE FUNCTION 749 531 734<br />
NEW_ADD_MONTHS FUNCTION 443 308 524<br />
PIPELINEME FUNCTION 219 202 890<br />
UPDATETEMP FUNCTION 183 410 433<br />
VALIDATE_DATE_FORMAT FUNCTION 385 267 666<br />
DEBUG PACKAGE 301 698 457<br />
DEPENDEE PACKAGE 71 234 185<br />
<br />
Page 1<br />
NAME TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE<br />
------------------------------ ------------- ----------- ----------- ----------<br />
GLOBAL_DEF PACKAGE 135 342 310<br />
LOGPKG PACKAGE 124 349 264<br />
NATIVEDYNAMIC PACKAGE 217 429 276<br />
STUDENTDATA PACKAGE 280 642 507<br />
TRIGPACKAGE PACKAGE 59 193 220<br />
DEBUG PACKAGE BODY 1407 0 0<br />
DEPENDEE PACKAGE BODY 150 0 366<br />
GLOBAL_DEF PACKAGE BODY 438 0 505<br />
<br />
Page 2<br />
NAME TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE<br />
------------------------------ ------------- ----------- ----------- ----------<br />
LOGPKG PACKAGE BODY 410 0 0<br />
NATIVEDYNAMIC PACKAGE BODY 668 0 625<br />
ANALYZE_OEM PROCEDURE 521 460 934<br />
DEPENDER PROCEDURE 89 515 321<br />
DYNAMICPLSQL PROCEDURE 1103 0 0<br />
DYNAMICQUERY PROCEDURE 1446 0 0<br />
EXAMPLE_PROC1 PROCEDURE 424 0 0<br />
HIKE_PRICES PROCEDURE 241 355 326<br />
<br />
Page 3<br />
NAME TYPE SOURCE_SIZE PARSED_SIZE CODE_SIZE<br />
------------------------------ ------------- ----------- ----------- ----------<br />
MY_FIRST_PROC PROCEDURE 160 332 327<br />
PRINTTOTALROWS PROCEDURE 827 0 0<br />
REVERSELOB PROCEDURE 1127 2071 678<br />
SHOWEMPS PROCEDURE 885 525 1242<br />
TEMPINSERT PROCEDURE 184 329 540<br />
UPDATECLASSES PROCEDURE 721 775 720<br />
<br />
<br />
Page 4<br />
30 rows selected.<br />
SQL><br />
SQL><br />
</source></div>
Admin