http://www.sqle.ru/index.php?action=history&feed=atom&title=Oracle_PL%2FSQL%2FSystem_Tables_Views%2Fprocess
Oracle PL/SQL/System Tables Views/process - История изменений
2026-05-24T19:23:11Z
История изменений этой страницы в вики
MediaWiki 1.30.0
http://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/process&diff=2202&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://www.sqle.ru/index.php?title=Oracle_PL/SQL/System_Tables_Views/process&diff=2203&oldid=prev
Admin: 1 версия
2010-05-26T10:01:11Z
<p>1 версия</p>
<p><b>Новая страница</b></p><div>==Get oracle installation path==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL><br />
SQL> select c.value || "\ORA" || to_char(a.spid,"fm00000") || ".trc"<br />
2 from v$process a, v$session b, v$parameter c<br />
3 where a.addr = b.paddr<br />
4 and b.audsid = userenv("sessionid")<br />
5 and c.name = "user_dump_dest"<br />
6 /<br />
C.VALUE||"\ORA"||TO_CHAR(A.SPID,"FM00000")||".TRC"<br />
------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------<br />
C:\ORACLEXE\APP\ORACLE\ADMIN\XE\UDUMP\ORA00604.trc<br />
</source><br />
<br />
<br />
<br />
<br />
==Query process for The Current Usage of the PGA Memory==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL> --<br />
SQL><br />
SQL> select<br />
2 program ,pga_used_mem ,pga_alloc_mem ,pga_max_mem<br />
3 from<br />
4 v$process<br />
5 order by pga_used_mem desc;<br />
PROGRAM<br />
--------------------------------------------------<br />
PGA_USED_MEM PGA_ALLOC_MEM PGA_MAX_MEM<br />
------------ ------------- -----------<br />
ORACLE.EXE (SHAD)<br />
5774313 10843381 25916661<br />
ORACLE.EXE (LGWR)<br />
4427613 9271617 9926977<br />
ORACLE.EXE (SHAD)<br />
1220113 1315025 3127161<br />
ORACLE.EXE (MMON)<br />
1136145 1538885 2652997<br />
ORACLE.EXE (D000)<br />
653677 659665 1211217<br />
ORACLE.EXE (CJQ0)<br />
524517 752465 1735505<br />
ORACLE.EXE (SMON)<br />
519985 1014609 1801041<br />
ORACLE.EXE (RECO)<br />
488969 883537 1080145<br />
ORACLE.EXE (DBW0)<br />
362765 1521749 1669849<br />
ORACLE.EXE (q000)<br />
302965 555857 555857<br />
ORACLE.EXE (CKPT)<br />
PROGRAM<br />
--------------------------------------------------<br />
PGA_USED_MEM PGA_ALLOC_MEM PGA_MAX_MEM<br />
------------ ------------- -----------<br />
295405 1651229 1651229<br />
ORACLE.EXE (q001)<br />
223941 359249 359249<br />
ORACLE.EXE (MMNL)<br />
216201 424785 424785<br />
ORACLE.EXE (QMNC)<br />
207757 359249 359249<br />
ORACLE.EXE (PMON)<br />
207373 359249 359249<br />
ORACLE.EXE (MMAN)<br />
206901 359249 359249<br />
ORACLE.EXE (PSP0)<br />
206581 359249 359249<br />
ORACLE.EXE (S003)<br />
200913 200913 293713<br />
ORACLE.EXE (S002)<br />
200913 200913 293713<br />
ORACLE.EXE (S000)<br />
200913 200913 293713<br />
ORACLE.EXE (S001)<br />
200913 200913 293713<br />
ORACLE.EXE (J003)<br />
86048 621393 621393<br />
ORACLE.EXE (J001)<br />
86048 856273 1473361<br />
ORACLE.EXE (J000)<br />
86048 921809 1511633<br />
ORACLE.EXE (J002)<br />
86048 621393 621393<br />
PSEUDO<br />
0 0 0<br />
<br />
26 rows selected.<br />
SQL> --<br />
</source><br />
<br />
<br />
<br />
<br />
==Query v$process a, v$session==<br />
<br />
<br />
<br />
<br />
<!-- start source code --><br />
<br />
<source lang="sql"><br />
<br />
SQL><br />
SQL> select a.spid<br />
2 from v$process a, v$session b<br />
3 where a.addr = b.paddr<br />
4 and b.audsid = userenv("sessionid")<br />
5 /<br />
SPID<br />
------------<br />
972<br />
SQL><br />
</source></div>
Admin