SET LINESIZE 3500
SET PAGESIZE   3000


set linesize 3500;
@astpro01;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astpro02;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astpro11;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astpro12;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astproportal1;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astproportal2;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astproinfra1;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');
@astproinfra2;
@@header_dbinfo 107 DC
select sum(se.value)/1024/1024 mempga_mb from v$sesstat se, v$statname n where n.statistic# = se.statistic# and   n.name in ('session pga memory');

disconn;

