使用するpgaを表示します

select s.username username,s.serial# serial,se.sid,n.name,

       max(se.value) maxmem

from v$sesstat se,

     v$statname n,

     v$session s

where n.statistic# = se.statistic#

and s.sid=se.sid

and s.username is not null

group by n.name,se.sid,s.username,s.serial#

order by 2

.csharpcode.csharpcode pre
{
font-size:small;
カラー:black
font-family:consosolas、「Courier New」、courier、monoospace;
background-カラー:菗菗ffff;
//white-space:pre;*/
)
.csharp code pre{margin:0 em;}
.csharpcode.rem{color=0000 ff}
.csharpcode.kwrd{color=0000 ff}
.csharpcode.str{color=red}
.csharpcode.op{color=0000 c 0}
.csharpcode.preproc{color=red}
.csharpcode.asp{background}
.csharrpcode.html
.csharpcode.atr{color=red}
.csharpcode.alt
{
background-彩色:〹f 4 f 4;
width:100%
magin:0 em;
)
.csharpcode.lnum{color=0000 ff}