http://sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fv_sgastat
Oracle PL/SQL/System Tables Views/v sgastat - История изменений
2026-04-30T17:58:39Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/v_sgastat&diff=2332&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/v_sgastat&diff=2333&oldid=prev
Admin: 1 версия
2010-05-26T10:01:23Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==compute sum of bytes on pool==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> break on pool skip 1<br />
SQL> select pool, name, bytes<br />
2 from v$sgastat<br />
3 where rownum < 20<br />
4 order by pool, name;<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
shared pool AW SGA 24<br />
KGX 107568<br />
branch 14880<br />
call 22048<br />
dummy 3276<br />
kcrrny 25320<br />
kfasga 1048<br />
kfdsga 44<br />
kffsga 48<br />
kfmsg 3088<br />
kksss 3840<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
shared pool knlsg 80<br />
kohsg 4<br />
kzull 80<br />
kzulu 64<br />
list 3584<br />
************ ----------<br />
sum 184996<br />
buffer_cache 171966464<br />
fixed_sga 1287016<br />
log_buffer 2904064<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
************ ----------<br />
sum 176157544<br />
<br />
19 rows selected.<br />
SQL><br />
SQL><br />
SQL><br />
<br />
<br />
<br />
</source><br />
<br />
<br />
<br />
<br />
==Query v$sgastat==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
<br />
SQL><br />
SQL> declare<br />
2 x varchar2(32767);<br />
3 begin<br />
4 for i in 1 .. 10 loop<br />
5 x := x || " procedure X"||i||";";<br />
6 end loop;<br />
7 execute immediate "create or replace package MEMTEST is "||x||" end;";<br />
8 x := replace(x,";"," is y number; begin y := 0; end;");<br />
9 execute immediate "create or replace package body MEMTEST is "||x||" end;";<br />
10 end;<br />
11 /<br />
PL/SQL procedure successfully completed.<br />
SQL> alter system flush shared_pool;<br />
System altered.<br />
SQL> exec memtest.x1;<br />
PL/SQL procedure successfully completed.<br />
SQL> select * from v$sgastat where name like "PL/SQL MPCODE";<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
shared pool PL/SQL MPCODE 24456<br />
1 row selected.<br />
SQL> exec memtest.x2;<br />
PL/SQL procedure successfully completed.<br />
SQL> select * from v$sgastat where name like "PL/SQL MPCODE";<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
shared pool PL/SQL MPCODE 24456<br />
1 row selected.<br />
SQL> exec memtest.x3;<br />
PL/SQL procedure successfully completed.<br />
SQL> select * from v$sgastat where name like "PL/SQL MPCODE";<br />
POOL NAME BYTES<br />
------------ -------------------------- ----------<br />
shared pool PL/SQL MPCODE 24456<br />
1 row selected.<br />
SQL> exec memtest.x4;<br />
PL/SQL procedure successfully completed.<br />
<br />
SQL><br />
SQL><br />
<br />
<br />
</source></div>
Admin