set line 230
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
col MACHINE for a30
col PROGRAM for a40
col USERNAME for a15
select * from (
select s.sid, s.serial#, s.logon_time,s.username, s.machine, s.program,s.process, s.sql_id, p.pga_alloc_mem/1048576 size_m, p.spid
from v$session s, v$process p where s.paddr=p.addr
and p.pga_alloc_mem > 104857600 order by 7 desc
)
where rownum < 11;
alter session set nls_date_format='yyyy-mm-dd hh24:mi:ss';
select sysdate from dual;
col MACHINE for a30
col PROGRAM for a40
col USERNAME for a15
select * from (
select s.sid, s.serial#, s.logon_time,s.username, s.machine, s.program,s.process, s.sql_id, p.pga_alloc_mem/1048576 size_m, p.spid
from v$session s, v$process p where s.paddr=p.addr
and p.pga_alloc_mem > 104857600 order by 7 desc
)
where rownum < 11;