조회 : 264
ttitle '1. Current pga, uga session memory' select a.sid, a.username, substr(a.program, 1, 25) as pgm, a.terminal, max(decode(c.name, 'session pga memory', trunc(value/1000)||'K', 0)) pga, max(decode(c.name, 'session uga memory', trunc(value/1000)||'K', 0)) uga from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.statistic# and c.name like 'session%' group by a.sid, a.username, substr(a.program, 1, 25), a.terminal; ttitle '2. Sum of current pga, uga session memory' select 'Current PGA, UGA session memory SUM:' as sum, sum(decode(c.name, 'session pga memory', trunc(value/1000),0))||'K' pga_sum, sum(decode(c.name, 'session uga memory', trunc(value/1000),0))||'K' uga_sum from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.statistic# and c.name like 'session%'; ttitle '3. Max(peak) pga, pga session memory' select a.sid, a.username, substr(a.program, 1, 25) as pgm, a.terminal, max(decode(c.name, 'session pga memory max', trunc(value/1000)||'K', 0)) pga_max, max(decode(c.name, 'session uga memory max', trunc(value/1000)||'K', 0)) uga_max from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.statistic# and c.name like 'session%' group by a.sid, a.username, substr(a.program, 1, 25), a.terminal; ttitle '4. Sum of max(peak) pga, uga session memory' select 'Max(peak) PGA, UGA session memory SUM:' as sum, sum(decode(c.name, 'session pga memory max', trunc(value/1000), 0))||'K' pga_m_sum, sum(decode(c.name, 'session uga memory max', trunc(value/1000), 0))||'K' uga_m_sum from v$session a, v$sesstat b, v$statname c where a.sid = b.sid and b.statistic# = c.statistic# and c.name like 'session%';
제목 | 작성자 | 날짜 |
---|---|---|
공대여자 | ||
공대여자 | ||
mins01 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 | ||
공대여자 |