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

<p>1 версия</p> <p><b>Новая страница</b></p><div>==The Current Usage of the SGA==<br /> <br /> <br /> <br /> <br /> &lt;!-- start source code --&gt;<br /> <br /> &lt;source lang=&quot;sql&quot;&gt;<br /> <br /> SQL&gt;<br /> SQL&gt;<br /> SQL&gt; select * from v$sgastat<br /> 2 where rownum &lt; 50;<br /> POOL NAME BYTES<br /> ------------ -------------------- ----------<br /> fixed_sga 1287016<br /> buffer_cache 184549376<br /> log_buffer 2904064<br /> shared pool dpslut_kfdsg 256<br /> shared pool hot latch diagnostic 80<br /> s<br /> shared pool ENQUEUE STATS 8360<br /> shared pool transaction 90576<br /> shared pool KCB buffer wait stat 3352<br /> istic<br /> shared pool invalid low rba queu 320<br /> e<br /> shared pool KQF optimizer stats 2396<br /> table<br /> shared pool CCursor 3910332<br /> shared pool ksunfy: system-globa 3000<br /> l sta<br /> shared pool DISPATCHERS INFO 2504<br /> shared pool plwpil:wa 4252<br /> shared pool kzekm heap descripto 164<br /> r<br /> shared pool kelt translation tab 300<br /> le<br /> shared pool kglsim recovery area 1980<br /> shared pool procs_kfgbsg 440<br /> POOL NAME BYTES<br /> ------------ -------------------- ----------<br /> shared pool service names array 20<br /> shared pool qtree_kwqbspse 28<br /> shared pool SHARED SERVERS INFO 2824<br /> shared pool ASH buffers 2097152<br /> shared pool sga listelement 1024<br /> shared pool object queue hash ta 3136<br /> ble d<br /> shared pool PX subheap desc 140<br /> shared pool PX msg pool struct 728<br /> shared pool Managed Standby Proc 28672<br /> Arra<br /> shared pool KQR M SO 147976<br /> shared pool KSIR SGA 96<br /> shared pool BRANCH TABLE SEGMENT 45864<br /> ED AR<br /> shared pool KGKP sga 20<br /> shared pool SGA Obsolete Param S 16<br /> ource<br /> shared pool osp pool handles 4<br /> shared pool SGA - SWRF Time Mode 64<br /> l Bas<br /> shared pool KSK SGA 64860<br /> shared pool sys event stats for 195776<br /> Other<br /> shared pool spfile callback tabl 224<br /> e: ks<br /> shared pool kcrrny 25320<br /> shared pool Service-level trace 268<br /> setti<br /> shared pool LRMPD SGA Table 77392<br /> shared pool namhsh_kfgsg 144<br /> shared pool msg Q child latches 144<br /> shared pool plwda:PLW_STR_NEW_LE 4<br /> N_VEC<br /> shared pool Prefetch history buf 284<br /> fer a<br /> shared pool Prefetch client coun 32<br /> t per<br /> shared pool ptr to sessions unde 4<br /> r idl<br /> shared pool returns from metrics 759808<br /> req<br /> shared pool xslongops 4040<br /> shared pool qm_init_uga_helper: 16<br /> qmkm<br /> <br /> 49 rows selected.<br /> SQL&gt;<br /> SQL&gt; --<br /> &lt;/source&gt;</div>

Admin