1查看谁在用临时段
SELECT se.username,sid,serial#,sql_address,machine,program,tablespace,
segtype,contents FROM v$session se,v$sort_usage su WHERE se.saddr=su.session_addr;
2如何查看oracle软件使用了多少内存
select 'SGA' as name
      ,round(sum(value) / 1024 / 1024, 2) || 'M' as "SIZE(M)"
from   v$sga
union
select 'PGA' as name, round(value / 1024 / 1024, 2) || 'M' as "SIZE(M)"
from   v$pgastat
where  name = 'total PGA allocated';