SELECTs.sid sid, lpad(s.username,12) oracle_username, lpad(s.osuser,9) os_username, s.program session_program, lpad(s.machine,8) session_machine,
(select ss.value from v$sesstat ss, v$statname snwhere ss.sid = s.sid andsn.statistic# = ss.statistic# andsn.name = 'session pga memory') session_pga_memory,
(select ss.value from v$sesstat ss, v$statname snwhere ss.sid = s.sid andsn.statistic# = ss.statistic# andsn.name = 'session pga memory max') session_pga_memory_max,
(select ss.value from v$sesstat ss, v$statname snwhere ss.sid = s.sid andsn.statistic#...
